MS Access dying a slow death

[kell...@gmail.com]

My MS Access FE/BE database uses SMB networking for multi-user access. With the most recent Windows 10 updates, Microsoft is beginning the end of SMBv1 functionality, and thus killing all networked MS Access databases. For now, I've re-enabled SMBv1 on all machines but I suspect future Windows updates will make it increasingly difficult to maintain anything that uses SMBv1.

I've obviously been away from the programming community for some time, but it's eerie how few recent articles I've found on the topic.

My database is mdb, do later versions of MS Access and the accdb format still suffer from the same corruption issues and reliance on SMBv1 to disable oplocks?

If I migrate my backend tables to SQL Server Express, and link my Access front end via ODBC, will that function properly with SMBv2/v3?

Thanks,
Kyle

[Ron Weiner]

kell...@gmail.com formulated the question :

> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com

I love working with Access. I think that currently it is the best
rapid development tool available. To my mind Access has only two
shortcommings.

The first is that you have to either own Access or install a runtime to
be able to use the applications created in it.

The second is Access often does not behave well in a multi-user
networked senario.

There are workarounds for both shortcommings, Install the Access
runtime for the first, and use Sql Express as a backend for the second.

As far as you last question, my experience has been that Sql Express
can be installed on just about any Windows OS. Currently I have an old
Sql Express 2008 installed on a Windows 10 Home workstation that got
the free Microsoft upgrade from Windows 7. I am sure that microsoft
has good documentation for exactly which OS's Sql Express plays well
with.

Go for it, I don't think you will be dissapointed.

Rdub

[Steve Hayes]

--
Steve Hayes
http://www.khanya.org.za/stevesig.htm
http://khanya.wordpress.com

[Patrick Finucane]

I came across this link and the workarounds. https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/

[kell...@gmail.com]

Glad to see it's not just me having this issue, and there are still MS Access desktop users relying on Windows networking for multi-user databases. Hopefully they'll come up with a solution for SMB 2/3 that will play nice with oplocks.

[Patrick Finucane]

The subject line of this post is MS-Access dying a slow death. When I see it, I keep seeing US dying a slow death. Trump's racist policies of separating children from their parents reminds me of the slavers in the 1800s that sold the slave children to other plantation owners. In fact, Jeff Sessions used the Bible quotes used by the slavers in justifying slavery to justify the separation. It is being reported that some of these kids will never see their parents again due to the misplanning by the US. I would like to think the US is not as racist a nation as it appears to be with the Trump cult, but it is. We are sinking with this fool Trump at the helm, pissing off everybody he can. He is a man filled with hate for all and will lead the US downward to destruction. Fuck him and the horse he rode in on.

[Steve Hayes]

On Wed, 27 Jun 2018 08:00:50 -0700 (PDT), Patrick Finucane
<patrickf...@gmail.com> wrote:

>On Monday, June 18, 2018 at 5:19:02 PM UTC-4, Patrick Finucane wrote:
>> On Wednesday, June 13, 2018 at 12:27:18 AM UTC-4, kell...@gmail.com wrote:
>> > My MS Access FE/BE database uses SMB networking for multi-user access. With the most recent Windows 10 updates, Microsoft is beginning the end of SMBv1 functionality, and thus killing all networked MS Access databases. For now, I've re-enabled SMBv1 on all machines but I suspect future Windows updates will make it increasingly difficult to maintain anything that uses SMBv1.
>> >
>> > I've obviously been away from the programming community for some time, but it's eerie how few recent articles I've found on the topic.
>> >
>> > My database is mdb, do later versions of MS Access and the accdb format still suffer from the same corruption issues and reliance on SMBv1 to disable oplocks?
>> >
>> > If I migrate my backend tables to SQL Server Express, and link my Access front end via ODBC, will that function properly with SMBv2/v3?
>> >
>> > Thanks,
>> > Kyle
>>
>> I came across this link and the workarounds. https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/
>
>The subject line of this post is MS-Access dying a slow death. When I see it, I keep seeing US dying a slow death.

Are WE dying for lack of a relational database to replace MS Access?


---
Ignore the following - it's spammers for spambot fodder.

djbash...@gmail.com
searchdat...@gmail.com
toman...@gmail.com
adultsing...@gmail.com
gburd...@gmail.com
datingpers...@gmail.com
girlsda...@gmail.com

[jamesfo...@gmail.com]

It's a shame to hear about that, especially with Microsoft becoming such a big Linux fan recently. :) I was hoping to use SMB with Access again soon. I've had a lot of success with using SQL Server Express as a backend. You don't even need to change the queries to TSQL. Please continue to let us know of your progress.

James A. Fortune
CDMAP...@FortuneJames.com (Not active, maybe soon)

[Albert Kallal (Access MVP)]

>> Trump's racist policies of separating children from their parents

Are you insane? The policy was not Trumps, it was the previous admin's policy.

Trump signed a executive order to STOP this process. How come Obama did nothing in this regards?

So a policy from Obama era is Trumps fault, but Trump is the first president to sign a EO saying this process must stop.

So explain to everyone here why Obama did nothing about this issue then? Why did Trump have to come along and fix this issue?

Regards,
Albert

[Patrick Finucane]

Albert, you are Canadian. You are not a US citizen. You are a wealth of information with Access, completely clueless in your understanding of US politics. Trump is evil. He is evil like the guy that did the Mai Lai massacre in Vietnam. He is a stain on the US and will be so in history. He is a dumbass Birther for God's sake and wanted 5 black kids to be executed even tho they were found innocent by DNA. Racists are a dime a dozen now in the US, Trump spread his sunshine of shit on the US and the weeds came. Trump even calls Nazis and white supremacists good people. BTW Albert, what Trump did, Obama did not. What Trump did was a crime against humanity, it is terrorism. Abd he was so fucked up he didn't even have a method in place to unite families again. He gave everybody unique immigration numbers with no link between the two. Here is an article you might want to read. https://www.factcheck.org/2018/06/did-the-obama-administration-separate-families/ Btw, crossing the border undocumented is a misdemeanor, not a felony. Trump brought in terror into the mix.

[Patrick Finucane]

On Thursday, August 2, 2018 at 6:52:59 PM UTC-4, Albert Kallal (Access MVP) wrote:

Albert, your post has gotten me riled up. So I apologize slightly. Are you a Nazi sympathizer or a white supremacist? I've never read anything from you that would suggest that until I read your post. I do not know if you are married and have children. If so, do you support the gov't telling you your kids are going for a bath and taken away from you and never returned to you? I can't believe you'd be that heartless and psychopathic but one never knows.
What Trump did was a crime against humanity and families. And Republicans parade like assholes claiming they are the Family-values party. I'd punch any Republican that attempted to mess with my family. Family values my ass.

[Patrick Finucane]

On Thursday, August 2, 2018 at 6:52:59 PM UTC-4, Albert Kallal (Access MVP) wrote:

Albert, a male that is HIV positive was fucking boys in a Phoenix immigration prison. Girls are getting sexually molested in these cages. Did that happen with Obama? Do you support the sexual abuse of children that are separated from their parents? I'm thinking that the people you hang out with are bad for your personality and life. You are being influenced by lowlifes. Separate yourself from the haters and get back to thinking for yourself.

[Joan Wild]

Take it somewhere else please. This has nothing to do with Access.
Joan

[Patrick Finucane]

On Saturday, August 4, 2018 at 1:23:36 PM UTC-4, Joan Wild wrote:
> Take it somewhere else please. This has nothing to do with Access.
> Joan

So says Joan, a supporter of Trumps ripping kids from mother's arms and then losing them, never to be returned to the parents. OK, Joan. You made your point. Keep supporting your turd.

[Patrick Finucane]

On Saturday, August 4, 2018 at 1:23:36 PM UTC-4, Joan Wild wrote:

> Take it somewhere else please. This has nothing to do with Access.
> Joan

Joan, I want to address your post.

First, there was a two week period recently where there were no Access posts. You could post something with your knowledge but you didn't.

Second, the lunatic we have as a president is more important to me than Acces. He can send this world into a world war.

Third, the group that visits here is international. I do not want them to think all Americans support our shithead president. Trump is lowering us in the world. So if they see that there is a person who can look at a turd and say it smells like a turd, fine by me. And Trump is a turd. Folks, Trump is a traitor to the US. He leads it, but he does not represent the US. He is and will be a shitstain in history books soon to come.

IF you want Access, start posting some Access stuff, Joan.

[Joan Wild]

Charter for CDMA...
Access is a RDBMS for the Windows Operating System. It includes WYSIWYG
design tools for easy creation of tables, reports, forms and queries
and a database programming language called VBA (Visual Basic for
Applications).

The purpose of the group will be to provide technical help to people
who use Access to create simple databases as well as to people who use
VBA to create complex databases.

[Patrick Finucane]

Then start providing technical help or simply shut up. You come here and make a post every six months or so and think you are king shit? You could be passing on your knowledge yet you don't.

[Joan Wild]

Patrick Finucane wrote:

...

>
> IF you want Access, start posting some Access stuff, Joan.

By the way, I did answer someone's question. As you say, there isn't a
lot of traffic here. There's no point in me posting when a person's
question is already answered.