|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
VB.net reading access97 slow on network
I am reading/writing to a access97 database using vb.net with OleDb. The application works fine on a PC that has the Access97 tables located on the local machine. When the Tables are put on a remote machine the app still works. The problem comes in when Access97 has those same tables open on the remote machine. It then takes 10-15 seconds to access the data. I've tried the same senario on the local machine and I don't see any differance if Access97 is open or not. The default open mode is shared in Access97 and there are no locks.
Thanks Bob |
|
#2
|
|||
|
|||
|
it happens with access 2000 as well
i believe when the db is open remotely, the client has to wait for the db to decide if the CLIENT is allowed to do anything (who ever opens the db has priority) As you know when a user has the db open in the design mode, clients cant event get to it (and it takes a while to even tell you that someone else has exclusive rights) so i guess this is the same scenario, its trying to figure out if the db is in design mode and who has exclusive access.. my .02 cents |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > .Net Development > VB.net reading access97 slow on network |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|