Multiple access to Single Database
-
hello all... i have a database in Access 2000...i want to access single database from multiple location...how can i do in VB .net...i have tried accessing the database by Imports System.Data.OleDb...its giving error saying "The Jet microsoft database is already exclusively opened by another user...or you may not have rights to access it.." if accessing the single database on server through multiple exe then giving above error....let me know if anybody has solution how to do it.... thanks in advance
-
hello all... i have a database in Access 2000...i want to access single database from multiple location...how can i do in VB .net...i have tried accessing the database by Imports System.Data.OleDb...its giving error saying "The Jet microsoft database is already exclusively opened by another user...or you may not have rights to access it.." if accessing the single database on server through multiple exe then giving above error....let me know if anybody has solution how to do it.... thanks in advance
-
hello all... i have a database in Access 2000...i want to access single database from multiple location...how can i do in VB .net...i have tried accessing the database by Imports System.Data.OleDb...its giving error saying "The Jet microsoft database is already exclusively opened by another user...or you may not have rights to access it.." if accessing the single database on server through multiple exe then giving above error....let me know if anybody has solution how to do it.... thanks in advance
If someone has the database open in Access it will be locked exclusive. Also, make sure your application is running under an account that has Read and Write rights to the folder where your database resides. If you don't have Write access, then your database will appear locked. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome