By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Allow Multiple Users

P: 38
All -

I have an access application that I want to put on a citrix box. Does access alow for multiple users where it will lock records like in MS sql server? If so, can some explain the configuration that needs to be done to an app?

Thank you in advance,

-Dev1
Mar 19 '08 #1
Share this Question
Share on Google+
5 Replies


Scott Price
Expert 100+
P: 1,384
Your question is far to general to give a specific answer to!

Yes, Access does record locking. It uses a temporary .ldb file to keep track of who is updating which record and keeps other users from updating the same record.

As a general overview, you split the database into two files: A 'front-end' .mdb file that contains the code/queries/report/forms and a 'back-end' .mde file that contains the tables. The .mde file resides on your server, each user gets a copy of the .mdb file. Access has wizards to help you with each step of this process, from the splitting to the linking.

Regards,
Scott
Mar 19 '08 #2

P: 38
Scott Price:

Thank you for your response. That is exactly what i have designed! I have a front end and a backend. Then if the front end is stored on say 5 user machines then when the user goes to open the front end .mdb will he/she have to go:

1. Tools, Database Utilities, Linked Table Manager
2. Select all etc...

each time the want to use the application? Or is that a one time deal?

Thank you!
-Dev1


Your question is far to general to give a specific answer to!

Yes, Access does record locking. It uses a temporary .ldb file to keep track of who is updating which record and keeps other users from updating the same record.

As a general overview, you split the database into two files: A 'front-end' .mdb file that contains the code/queries/report/forms and a 'back-end' .mde file that contains the tables. The .mde file resides on your server, each user gets a copy of the .mdb file. Access has wizards to help you with each step of this process, from the splitting to the linking.

Regards,
Scott
Mar 19 '08 #3

Scott Price
Expert 100+
P: 1,384
One time deal. Once the link is established, it stays as first established until parameters change.

There are various ways of dealing with re-linking, but the simplest is the best as long as you have a fairly static situation where the network layout doesn't change much.

Regards,
Scott
Mar 19 '08 #4

P: 38
Scott Price:

Thanks a bunch!! That really helps. Our network is very static so that should work great. Thank you very much for you assistance!!

-Dev1


One time deal. Once the link is established, it stays as first established until parameters change.

There are various ways of dealing with re-linking, but the simplest is the best as long as you have a fairly static situation where the network layout doesn't change much.

Regards,
Scott
Mar 19 '08 #5

Scott Price
Expert 100+
P: 1,384
Not a problem!

Regards,
Scott
Mar 20 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.