Disable SMB Leasing again

<<The only thing I am not sure about is if Leasing has to be disabled at each pc.>>

  No it does not.   leasing is a "server" feature and it only needs to be done on the machine that is sharing the directory with the DB.

Jim.

This is bizarre...have you made accurate benchmarking to see if actually you have issue.
Just create an iterator of a big table and let it run on all scenarios,,,use the Stopwatch Class to get accurate readings.
Then you need some monitoring on both the Network performance of the Workstations/Server.
Ensure you have an issue and get back to see what is missing

Thanks Jim/John

Due to go back to client on Wednesday next. I will report back next day. If anyone has other ideas please let me know.

If the data was corrupted would it still open and could it cause this problem?

I have compacted and repaired the data many times

Corruption can cause many issues...one common issue is that Keys/indexes are gone causing everything to slow down.
Examine carefully your tables at design level...make sure that there is a primary key on each table.

I would suspect the server/network despite having been checked over.  What I would do is take Access out of the picture; get a directory of files that is quite large (GB's worth).  

 Have one user only copy the files to a folder on the PC and note the bandwidth.   Then have two users do the same thing at the same time and compare bandwidth results.

  Bandwidth utilization is dependent on numerous factors.

  And too be clear; what exactly is the issue your having?   Is the app performing poorly?

Jim.

What exactly are you using to calculate the ethernet speeds?

Hi Jim

The app is running painfully slow 2 seconds to select from a simple dropdown, 30 seconds to open app.

Hi Mike We were only using Task manager to test access Ethernet speed

Hi John  The problem is only occurring with one client. No problems with others in multi user environment

The problem is only occurring with one client. No problems with others in multi user environment

Can you clarify this...do you have an issue with all the clients when they are using the application or no matter what with only one...
If its only one then what OS/Office/Patch Level/Differences with other Workstations (Antivirus,Installed Applications,NetWork Connection)
If is only one pc how about physical changing to another network outlet...another switch...cables

Hi John

Client was a bad term to use. By Client I mean customer. So I have dozens of non related customers each with multi user environment without issue. Only one problem customer as described above. Sorry for that misleading info. Also we have tried cable change without effect. It seems (at the moment) that it is the action of more than one user accessing data that is the problem Single user any station no issue

<<It seems (at the moment) that it is the action of more than one user accessing data that is the problem Single user any station no issue>>

 That is most likely not Access though.

  Leasing is related to Oplocks under SMB1 (more or less the same thing, just a new and improved version) and allows client side caching of a file.   Really doesn't have to do anything with networking speed.

  Again, I would suggest performing a test as I outlined having Access totally out of the picture.

Jim.

Have you tried to replace the switch...when a switch goes bad ..then it behaves like hub...meaning that if you have a 8 port hub..the speed is divided by the number of ports.(/8)..or active connections(/?)...it's has being some years I had this piece of info without chance for verification....so just give it a try

Hi Jim Yes we intend to carry out that test on Wednesday.

Hi John  Yes we took a spare switch with us last time. But that is an interesting comment.

Hi All

Just had a new customer install on a two user server Same problem both windows 10. So now I am also looking to see if there is anything wrong with my application.

If you go to Tools, Options are there any settings there that could cause an issue? My application is taking 30-60 seconds just to load. But only when more than one user is accessing data???????

Should I have the Open database with record level locking set to yes on the .mdb data file

<<When two or more users are accessing data the ethernet speeds are 1-1000kbs when one user is accessing data the ethernet speeds are in the tens of megabits and usually running up to 10 times faster.>>

  Low and behold, I have the same thing happening at a client over the pas week.   We have not determined anything yet....bunch of things going on and it's difficult to tell if it's a server/network issue causing the app problems, or the app causing sever/network issues.

<<Should I have the Open database with record level locking set to yes on the .mdb data file>>

  You can, but I doubt it will be honored.   Record Level Locking was an add-on and more often than not, doesn't work.  Also some operations are always done at the page level regardless.

Jim.

Well Jim you never know I may be able to help you for a change.  My application has been the same format for 15 years. My customers download the installation file (built with SageKey software) and has been installing since. The only problem being the SMB Leasing 6 months ago.

I have a version that has been out of date and circulation for 2 years We are just testing this as we know nothing has changed on it for years

What I am hoping is that the old version also has a problem proving that something like a MS update has changed things.

A colleague suggested doing a compact and repair on both front and back end to ensure any updates apply to both parts and does not cause any incompatibility issues.

I will let you know.

Something else that may be relevant is that when trying to open the back end data on the server from the local pc with access runtime all we get is a grey screen. You can see the Access blank heading but cannot see the tables or anything else. When it closes you can see it is compacting. (I have it set to compact on close)???

Do you have a startup form on the BE?

We have to go to the server right click data file and choose access to open the file. So I guess that means no.  With our app there is no need for a user to directly access the data file.

<<Something else that may be relevant is that when trying to open the back end data on the server from the local pc with access runtime all we get is a grey screen>>

   Access runtime has no design features, so that would be correct....your are not going to see anything.       But now saying that, I can't say that I've ever actually tried it<g>.

Jim.

Well that's cleared that up. Cheers Jim

<<...   But now saying that, I can't say that I've ever actually tried it<g>.>>

 That wasn't entirely helpful was it?  

 I did test this and on a BE in runtime mode, you do get a gray screen and nothing else.

Jim.

Hi Jim

Can you tell me if the problem you have with an installation is going on a windows 2016 server

<<Can you tell me if the problem you have with an installation is going on a windows 2016 server>>

  Yup it is.

Jim.

I have two very competent IT companies looking at it for the last 4 hours. The suggestion, because we have exhausted all we can exclude, is to put a NAZ Drive on the system and try to eliminate that element of Micro Soft

NAZ Drive

Probably you are meaning NAS drive...that will be "guided"...by some Linux distro Variant.....usually Linux and Access don't go along very well but it would be interesting....

We're running out of options. We thought we had it cracked. The two windows 7 machines were using SMB1 and the windows 10 SMB2 or 3 Set them all at 1 and bingo all worked……… for 10 minutes. Then back to problem. Checking SMB status showed no changes to our settings?????

This is starting to get bizzare...
The definite suggestion would be to make SURE that everything is set to same SMB level...workstations + server

Bizzare is how we see it. It's as if something else is locking the data file. When you watch the access speed with task manager you see an initial surge of data transfer up to 30Mgps then within 5 seconds it goes to 20-90 Kbps.

We are now pinning our hopes on a NAS drive or better hoping Jim figures it out with his customer issue

<<We are now pinning our hopes on a NAS drive or better hoping Jim figures it out with his customer issue>>

  We're heading more and more into the territory of a network issue.   Doing some spot Wire Shark captures, we're seeing a lot of Dup Ack's, Spurious re-transmissions, and a host of other things that something is amiss with the network.

Jim.

Thanks Jim

Yes John we are checking. Thanks

Derek/Jim ..have you checked the MTU size along with Jumbo frames... maybe there's an inconsistency that forces the packages to retransmited

Hi John  Not as far as I know. I will get it Checked. Thanks

Did you ever try to swap the switch?

We're still hunting here, but it turns out that some of the servers had multiple NIC's on the same sub-net.  That cleaned up a lot of the errors when the network got busy, but I haven't re-visited the throughput issue since then, nor done further network analysis.   Right now I'm focused on some app changes they need.

Jim.

Multiple NIC on same subnet...probably this is the issue...just for kicks just leave only ONE(1) NIC and report back

Our Problem appears to be data. When we remove February and March from the data all works OK. There is no problem compacting and repairing any of the full data. I have created new DB container and imported data still same problem. No issue with windows 7. Problem still with windows 10. This is really weird.

Did you go back to this issue yet Jim

Still never managed to fix this issue. Customer has given up on that windows 10 machine. Windows 7 still fine.

My thanks to you both

Hum, not sure why I was getting your previous comment notifications.

 I did pin this down and it was the network setup.  Servers had multiple nics on the same subnet.

Jim.