Solved

Problems with Access DB on Windows Server 2012 R2

Posted on 2014-07-23
4
2,173 Views
Last Modified: 2014-08-19
Hello,
At our customers, we have the following problem with Windows Server 2012 R2:
On the Windows 7/8 clients there is installed a VB6 application. This application accesses an Access database, which is located on a file share on the server.
Sporadically, maybe 2-3 times in a month, the VB6 application crashes on the clients, the database will get corrupted and needs to be repaired (duplicate entries in tables, primary keys have been removed.) In the event log, there are no error messages from the Access database. only customers with Windows Server 2012 R2 have this problem, customers with 2008 R2 for example, have no problems.
At Google, i have found that it's possible to downgrade SMB 3.0 to SMB 1.0, but i think it's not the solution because SMB 1.0 was used by Server 2003 and XP clients.
Does anyone have the same issues with Server 2012 R2 and Access, or know how to resolve this problem?
Thanks in advance.
0
Comment
Question by:SirAskALot
4 Comments
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 40214619
Haven't seen this problem specific to 2012.  I've OFTEN seen Access databases crash.  It's why I don't use them.  I use a SQL Database with an Access front end.  I would suggest, depending on if you still have the source code to the VB6 app, convert it to a SQL database instead.

Also, make sure VSS is disabled.  If memory serves (and it's been a while), snapshots can cause the access databases to crash, so we stopped using them with the drive that Access was storing the data on.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40214664
OPLOCKs has been problematic in the past, but now with 2012, there is no way to turn them off.  A work a round for that is to have two instances of an application running somewhere that connects to the DB.

 With the DB held open, OPLOCKs will no longer come into play.

 I just answered another question where they are trying that to see if it is OPLOCKs causing the problem or not for them.   It may be something else and un-related.

 All things being equal, Access databases should not corrupt and unlike Lee, I've seen the opposite; corruption for me has been infrequent.

But as said, a good solution is to move to SQL Server.  The issue with JET/ACE DB's is that all the DB processing is carried out client side (no server side process), so there are a multitude of factors that can contribute to a DB corrupting.

The free version of SQL server can now handle up to 10GB and with the SQL Server Migration Assistant, it's fairly straight forward.   Your app may need adjustment, but the changes are usually few.

 Then on top of that, you get the benefits of online backups, recovery with roll-forward, etc.

 If you want to stick to JET/ACE, then look for patterns.  Same users, same approx time each month, etc.   It can be anything from the stations, to the networking, to the server OS.

 For example, years ago, many NIC cards had a test protocol installed where the card would disconnect itself from the network, test, and then re-connect.   Only apps that ever would complain were the Access ones.  Reason being is that the cache is maintained on the client at the milli-second level, so data traffic is almost constant.

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40214709
If you decide to upsize to SQL Server, use the SQL Server Migration Assistant for AccessSQL Server Migration Assistant for Access, not the Access upsizing wizard.  But before you do that, make sure that all of your tables contain a primary key.  Without that, you will not be able to edit data in your SQL Server tables or delete records from those tables.

I also add a field of datatype "timestamp" to all of the tables on the SQL Server.
0
 

Author Comment

by:SirAskALot
ID: 40269602
Now we decided to move the Access database to a virtual Windows 7, running on the Windows 2012 Server.
Thank you for your help.
Regards
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now