Allow Multiple Users

[Dev1]

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

[Scott Price]

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

[Dev1]

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

[Scott Price]

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

[Dev1]

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

[Scott Price]

Not a problem!

Regards,
Scott