Access WIndows 2012

Hello,

I replaced an old Windows 2008 SP2 32bits server by a new Windows 2008 Essential R2 64bit server

We have a Access MDB database accessed from 4 PC clients Windows 7 PRO

After moving DBF files to new server, we are experimenting very slow access to DBF files

Clients config has not changed just the server has changed from 2008 SP2 to S012 R2

Accessing Word and Excel files seems OK, just MDB files is very slow

Thank you for your help
gadsadAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pramod UbheCommented:
try disabling local firewall/antivirus.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Also, do the following in the app:

1. Keep a constant connection open to the BE for the life of the FE app.   This can be as simple as having a hidden form bound to a small table, or a recordset or table opened in code with a global variable.

2. Add the line:

dbEngine.SetOption "MaxBuffers", 65535

 To the start-up of the FE.

Jim.
0
gadsadAuthor Commented:
I will try to disable firewall and antivirus

I do not understand what is BE and FE, sorry
When do we add this line? dbEnfine....in Access?
If you can be more precise
Thank you
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
"FE" and "BE" refer to "Front End" and "Back End".   Front end being all the forms, reports, etc.  everything except tables.   BE is the tables only and should be the only thing on the server being shared.    Each user should have a copy of the front end.


Jim
0
gadsadAuthor Commented:
The fact is that the Access database is a simple MDB file located on a share folder on the 2012 R2 server; I have no way to change it. I just would like to make it work as good as it was working on Windows 2008 SP2 server

 What I will try to do tomorrow:
- deactivate Antivirus
- deactivate Firewall
- try to change to present 10/100 switch to a gigabyte switch

If it does not work, I may try to disable SMB3 and SMB2 on the Windows 2012 server. Is it a good idea? Any risk to do that? should I also disable SMB2 on PC clients (there are all Windows 7 SP1 PCs)

Thank you for your help
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<If it does not work, I may try to disable SMB3 and SMB2 on the Windows 2012 server. Is it a good idea? >>

 The answer is, "it depends".   Some server features in 2012 rely on SMB3, so no, you generally don't want to disable it.  There is also the performance impact for everything else besides Access.

 A work around for that is to use two "dummy" instances and the constant connection technique (or in this case, the app simply being open).

By leaving two instances of the app open constantly (ie. sitting at a menu), client side caching and OPLOCKS will not come into play.  The file will always be left in "multi-user" mode as far as the OS is concerned, so there will be no overhead in it arbitrating locks.

As a quick test, simply open the app 2x on the server (both running at the same time), then let all the regular users use it and see if the issue goes away.   If not, the problem is not related to SMB2/3.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.