Running Queries

[Guest]

g am new to Access and working on a request tracking database that will be
used by multiple users (6) throughout the day. The users would like to run
several basic queries that display the requests that they have input into the
database for the day. Can the users run the queries during the day when
other users are logged into the database?

 

[Guest]

If they are just plain old Select queries that don't change the data, Yes
provided the database is set up properly.

1. All users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.

2. Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)

3. The database should be split between a front end and back end with a copy
of the FE on each user's computer.

 

[Guest]

Thanks for the info. I have done all below except change the Name
AutoCorrect option and database split. I found that the queries I created on
my local machine and copied to the shared database will not run. I
re-created my queries on the shared database and they now run fine.