multiple user DB access via Excel (troubleshooting?)
 

I am currently programming using an Excel/VBA front-end, that links to a
medium sized Access DB, using ADO. The front end will be used by 4
computers, linked via a local server, all running Windows 2000
professional.
Does anyone know of any websites that cover possible issues related to
multiple users using the same VBA front end to link to the same DB?
For instance, there is a concern that if two users simulataneously
attempt to query the database (SQL, via ADO), that an error may occur?

Thanks,
Viggy


---
Message posted from http://www.ExcelForum.com/

multiple user DB access via Excel (troubleshooting?)
 

Try this:

MSDN - ADO 2.8 Programmer's Reference
What is a Lock?

http://msdn.microsoft.com/library/de...hatisalock.asp

--

Viggy wrote in message ...
I am currently programming using an Excel/VBA front-end, that links to a
medium sized Access DB, using ADO. The front end will be used by 4
computers, linked via a local server, all running Windows 2000
professional.
Does anyone know of any websites that cover possible issues related to
multiple users using the same VBA front end to link to the same DB?
For instance, there is a concern that if two users simulataneously
attempt to query the database (SQL, via ADO), that an error may occur?

Thanks,
Viggy


---
Message posted from http://www.ExcelForum.com/