use common Access Database for VB program?

Question

Dear,
I am using the same Access database for my VB program(Telepghone Index) in different computers with ODBC connection.The databse is stored in one PC and shared the folder via network. on client PCs this is mapped as a drive and made ODBC connection with DB. When i open on one PC it is ok; but at the same time if i open the program on another PC it is showinig "Database is already in use" and can;t get connection. pls opt me a solution....

thanking u

urs gini

Answer 1

create more than one user then try to open it on the sharing network..

Answer 2

VB can get right of entry to many of the financial databases obtainable. that is attainable to construct sq. statements to get right of entry to the documents directly from notwithstanding database Clipper makes use of. As i don't comprehend something approximately Clipper or the form/database used for the equipment i'm no longer able to help greater. VB is an entire programming language and you will desire to be waiting to application what you prefer. i might recommend using the later version VB.internet. in my view i think it helps greater flexibility plus added stepped forward function.

Answer 3

there's no way you can do it because the database is locked while somebody else opens it for editing. do not use Access, very limited. use a rdbms systems that allows multiple users/connection. try db2, btrieve, then use pervasive sql or SQL or oracle. VB is not really that strong.

there's another way, by allowing multiple user's access on the database. it's hard to explain here, try researching on it.