Database Access Interrupted

[Llobid]

Ladies and Gentlemen...

I appreciate any help you can give me on this problem. I'm not even sure it's an Access problem, but it seems to happen exclusively while in Access. First, I am using Access 2007, networked on Windows Vista computers. The program has been installed on 3 computers for some time now ... without problem. However, we put the program on 2 more computers and recently while in the database, the clients have been receiving the following error message.

Your network access was interrupted. To continue, close the database and then open it again.

When they click OK, the database closes and they lose all of their input in the form in which they were working. They can be working along fine, but after several minutes the error message pops up. Any help you have for me would be appreciated.

 

[boblarson]

I certainly hope that you have split the database and have the backend (where the data tables are) on the file server (or on one computer) and then each computer having a frontend (where your forms, reports, queries, macros, etc. are) linked to that backend.

You aren't trying to open a single accdb file from one location are you?

It sounds like you are running into network disruption issues which can happen sometimes frequently. It all depends on how stable your network is and if you are suffering packet loss, you can wind up with a corrupted database file. So, make sure that the split is done so that will minimize the chances of corruption. However, if the error message pops up frequently then you should have your network checked to see if packets are being dropped frequently.

 

[Pat Hartman]

Ask you network people to check the NIC on the two newly added computers. If one of them is faulty, they could be causing the problem. If the network people don't want to be bothered, see if you can isolate the issue by removing one of the new computers from the equation.

 

[Llobid]

Bob...

The database is split and the back end resides on one of the older Dell computers. The two new computers are HPs.

Pat...

Unfortunately, I are the network people. No, actually I have another person who is dealing with the wireless networking of the computers and network printer. I will have him check the network interface card, but I'm not sure that is the problem, since it seems to be happening on both the new computers.

Is there a setting in Access 2007 (which I'm not as familiar with) that could be causing the dropped connection or is it definitely a problem with the network and not Access?

 

[Pat Hartman]

I would not run Access on a wireless network at all. Access is extremely sensitive to blips in the network connection. If you have no choice, I would recommend converting the back end to SQL Server. You can use the Express version which is free if you don't have the standard version. The difference is that the Express version limits the size of the database which shouldn't be a problem for you.

 

[shsh_shah]

I would not run Access on a wireless network at all. Access is extremely sensitive to blips in the network connection. If you have no choice, I would recommend converting the back end to SQL Server. You can use the Express version which is free if you don't have the standard version. The difference is that the Express version limits the size of the database which shouldn't be a problem for you.

I have a question here what if both backend and front end running on same PC and same folder in Vista? And I use following bekiw but i get
"network access interrupted .to continue please close and open again"

Dim stDocName As String

stDocName = "Cl Closing 2 Opening Qry"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Please help?