View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Viggy Viggy is offline
external usenet poster
 
Posts: 1
Default 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/