CODING FOR VB & ACCESS AS MULTIUSER

Asked By Chandan Mukherjee
05-Feb-10 04:17 AM
Earn up to 0 extra points for answering this tough question.

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

 

  re: CODING FOR VB & ACCESS AS MULTIUSER

Adil Saud replied to Chandan Mukherjee
05-Feb-10 07:14 AM
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...:))


  Access will start to get flaky at around ten simultaneous connections over a mapped drive

Robbe Morris replied to Chandan Mukherjee
10-Feb-10 09:16 AM
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.
Create New Account