LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 459
Default 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/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IS IT POSSIBLE TO HAVE MORE THAN ONE USER ACCESS THE SAME EXCEL Sh perl New Users to Excel 1 September 22nd 09 08:51 PM
Excel / Access User Conference Damon Longworth Excel Discussion (Misc queries) 0 June 19th 07 05:25 PM
Excel / Access User Conference Damon Longworth Excel Worksheet Functions 0 June 19th 07 05:25 PM
Multi-user access to Excel Bob Excel Discussion (Misc queries) 3 July 19th 06 10:07 PM
Excel allows access to more than one user to same file Bernie G Excel Discussion (Misc queries) 2 March 8th 06 09:03 AM


All times are GMT +1. The time now is 01:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"