Concurrent Connections

[kbsudhir]

Hi All,

I am workig in multi-user environment. I have created a databasen access 2003. Which gets updated (addition of new records only) from excel.
Appro. 18users will use it at once. How to enable all them to update records without any problems.:dunno

I have bo Idea about the concurrent connections.:(

Please guide.

I appreciate any help in this regard.

Thanks
Sudhir

:help

[Carl A]

This is worth a read. If you google concurrent connections in Access you will find many more on this subject

http://www.15seconds.com/issue/010514.htm

You may want to think about switching to sql server or MySQL

HTH

[kbsudhir]

Thanks Carl, it was really very informative link.
Alas I can't switch to any other database other than access.

Still if you have any links or info on how to enable Concurrent connections in macros will bw great.

Thanks for your time Carl.

:hi:

Sudhir