VB6 with MS Access

[azan]

Hi,

I'm new to VB6. I'm using VB6 and MS Access as database. Is it possible for multi user to access my MS Access table (mdb) and open/edit/update simotaniously at one time. If yes, how and what is the example code.

Please advice me. Thank you.

[Shuja Ali]

Yes it is possible to use MS Access database in a multi-user environment. You will have to put your access DB in a shared location where all the client's (VB programs) can access it.

Also read this for a better understanding of how MS-Access can be shared
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

[azan]

Thanks Shuja Ali.

Another thing want to know, is it posible for more than one user to open the same Access (mdb) table at the same time? because i was thinking of developing a small programme where two workstation can open (and manipulate) the same Access table at the same time.

Please advice.

Thank you.

[DataMiser]

Yes so long as it is not being open for exclusive access

[Teranoz]

And access has a limited number of connections at the same time.
Theoretical is is 255, but in practice it is a lot lower.

[dglienna]

Wrong. Access can handle 3-5 concurrent transactions at a time, and no more. If you have more users, then you need a middle tier to hit the db, and send it to the other tier (users)

Otherwise, use SQL Express, which is free

[azan]

Thank you for the answers.

Got any sample code (partial would be just fine) on how to share Access db?

[vb5prgrmr]

Access 2k7 specs http://office.microsoft.com/en-us/ac...CH100621861033

Access 2k7 specs http://office.microsoft.com/en-us/ac...CH062525931033

Access 2k2 & 2k3 specs http://support.microsoft.com/kb/302524

as for 2k and 97 those documents cannot be found

[dglienna]

The link in my signature.

As far as 255 concurrent users, I wouldn't like to DBA that mess.

http://en.allexperts.com/q/Using-MS-...imum-Users.htm

[dglienna]

The link in my signature.

As far as 255 concurrent users, I wouldn't like to DBA that mess.

http://en.allexperts.com/q/Using-MS-...imum-Users.htm

[azan]

Thank you so much for all the answers.