Split database

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
I have a database, and then I splitted it to two databases
so more people can use it as the same time.

First database is "Patient.mdb" which has linked
tables,queries, and forms.
The second is " Patient-be.mdb" which has only tables.

If I want to put in one more a table, what
should I do? ________
I did put new table(A) at back-end (patient-be.mdb)and
relinked the Font-end. However, the table (A)isn't appear
at Font-end.

Please help me!
 
You will need to use the Get External Data - Link Tables
to link to the new table. Just relinking the existing
tables will not show the new table.

HTH

Byron
 
after you create the table in the "be" database is what we call it here, open up your split database(with the queries, etc), click on your tables tab, then click new, then click linked table. Choose the new linked table from the "be" database when prompted, it should appear in your linked database, unless you have it hidden. Another tip too when using the linked databases, crate relationships in the "be" database for enhanced speed and reliability, your linked database will automatically contain the relationships when you reopen it. Hope this helps.
 
Back
Top