CODING FOR VB & ACCESS AS MULTIUSER

Dear all,

 

   I want to develop one multi user application using vb as fornt end & access as back end. Now, I want help regarding connection between VB & Access.

   1. Is it possible to use Access as Multi User Database, if possbile please provide same sample coding how to connect the database and at the time of inserting/deletion/update what should I do.

Please help

 

Chandan

 

Hi

Yes you always use the access database in a multi user environment, there is no issue in this(depends on the size and type of use)


code is pretty simple :

Dim con As New OleDb.OleDbConnection
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source C:\AddressBook.mdb"

con.Open()

MsgBox("A Connection to the Database is now open")

con.Close()

MsgBox("The Connection to the Database is now Closed")

Where C:\AddressBook.mdb is the acess database you want to connect.

thnx

Adil...:))

If you keep the number of simultanoues users to a minimum, you'll be fine.  Access is not specifically designed for multi-user applications although it does work.