Speed of linked mdb's

F

FB

It might help if u created the program mdb on the users
computers instead of on the server as is suggeted in the
online help:

Share only the tables in the database

You can put only the tables on a network server, and keep
other database objects on users' computers. In this case,
the database's performance is faster because only data is
sent across the network. Also, users can customize their
forms, reports, and other objects for their individual
needs and preferences without affecting other users.

You can separate the tables from the other database
objects by using the Database Splitter Wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Multiple Users/Permissions Suggestions 5
Question about permissions for linked table 0
User Level Security problem in Access 2003 2
Can't delete table "You do not have the necessary permisions to us 2
Removing Admin Permissions from my database 1
Database Security 0
Network Folder Permissions 4
Best way to deploy Access read-only database that is linked to SQL tables 6

Top