Sharing an Access DB with multiple users

[TA2724]

I created an access database for the sole purpose of sharing approved data with my entire company. The end users will view the data in a Form which utilizes several tabs and also gives them the ability to run pre-set queries out of the Form. The Form was created using several queries which were built from tables off of the server. The tables update every day, as does the information in my Form. The problem I am running into is that it takes about 2 minutes to open the DB (the DB opens directly to the form and all queries run immediately to update), which is annoying to end users and might deter them from actually using the tool. I have tried moving the DB to SharePoint, but that did not work due to the size of many of the tables.



Any suggestions how else I can improve performance and share the data? I am an intermediate user, so more detail the better.

[RuralGuy]

The best Multi-User link I've found: http://www.accessmvp.com/TWickerath/.../multiuser.htm

[orange]

Please tell us more about your database. Is it Split?
Can you describe this in more detail?

several queries which were built from tables off of the server.

You may wish to investigate "Linked tables".