How to run mdb database with lan and vb6?

How to run mdb database with lan and vb6?

Hi George,

Networking with Access database is possible and easy by just using or configuring you Connection String.

Example:

Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:Program FilesMicrosoft Visual StudioVB98Database EditorDBEditor.mdb"

All you have to do is change the path, just locate the database on the network. Like this: Your computer is located at the server which has the IP address of 192.168.0.1 and in my documents folder or "192.168.0.1My DocumentsDatabase.mdb".

Your connection string goes like this:

Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = 192.168.0.1My DocumentsDatabase.mdb"

Or you can use the name of the computer.

Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = \ServerMy DocumentsDatabase.mdb".

But if the error goes like this "Database is in use" or "Database lock for computer 1" when editing, adding, deleting and updating records at the same table at the same time then it is normal because Access Database automatically locks the database if one have edited, add, delete or update records in it. If that is your problem just capture the error in your vb6 code. Like this:

On Error Goto err:

Your code goes here.

Err:

If err.description = "" then

Else

mgsbox err.description

End if

Or

On error resume next.

Thanks.