How to keep a Table Local

[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

 

[Steve Schapel]

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