How to keep a Table Local

  • Thread starter Thread starter Michael Carakatsane
  • Start date Start date
M

Michael Carakatsane

Had a problem with users sharing a table called Summary in
my Access database. To keep the users using there own
Summary table, I was told to split the database to a
backend with the tables except Summary. Then give each
user a frontend mdb with the forms, queries, etc. and table
Summary.

How do I do this? If I use the splitting wizard, all the
tables go to the backend. What do I have to do from the
start or with this split database to have Summary in the
frontend mdb.

Thanks for any help.

Michael
 
Michael,

After you have used the wizard, go to the Database Window in the
frontend database, delete the link to the Summary table, then use the
File|Get External Data|Import menu to copy the Summary table from the
backend database. Then, open the backend database, and delete the
Summary table from there.

- Steve Schapel, Microsoft Access MVP
 
Back
Top