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

It depends on how you are using it. If the Telephone directory is strictly for look up with no editing then you can just create a recordset of it for each call from a different PC. The Db will only be in use long enough to make a local recordset copy, which allows others to connect to it after.

If multiple users are editing it then you need to check on the record locking aspects where you would only lock a record as it is being edited--not the whole Db.

Answer 2

there is not any way you're able to do it because of the fact the database is locked on a similar time as somebody else opens it for modifying. do no longer use get right of entry to, very constrained. use a rdbms structures that helps dissimilar consumers/connection. attempt db2, btrieve, then use pervasive sq. or sq. or oracle. VB won't be that stable. there is yet differently, by ability of allowing dissimilar consumer's get right of entry to on the database. it is not hassle-free to describe right here, attempt learning on it.