Ok Mike,
You need to add the table to ClientsData then in the Clients DB click the
Tables Container and right-click in the blank are where the other table
objects are located and choose Get External Data, then link (NOT IMPORT) to
the ClientsData and click on the new table to link it.
Just to let you know there is an additional benefit to splitting. You can
add a local table (that is not linked) to the Clients db. This will allow
you to store or set up temp tables the user can use without affecting other
users. For instance, say you have a temp mailing table. You can have the
user select the records they want and they will be added to the table and
used for mailing labels....other users can select other records for their
list and the lists stay separate because everyone has their own local list.
I use this technique for creating tempory data for reports and such.
HTH
Paul
"MikeZ" <mz****@telus.net> wrote in message
news:eMgkd.78926$E93.52909@clgrps12...
Hi,
Although I am new to Access, I do try to experiment a bit. although this
time I may have gotten over my head. Hopefully someone can help me out. No
doubt a simple question for many of you.
I have found it necessary to use the Database Splitter Wizard to split my
database. I was quite surprised how well it works. After several months I
need to add another table (tblReturnedFunds) to my ClientsData.mdb and so
far had no luck in figuring out how to do it.
The two tables I have are Clients.mdb (forms, queries, reports etc..) and
ClientsData.mdb. No doubt a beginners question, but I would really would
appreciate some advice in this regard.
Thank you all in advance.
Mike