Table Links in FE, BE database

  • Thread starter Thread starter bcollier
  • Start date Start date
B

bcollier

Our database is split into Front End and Back End. I
created a new new table and input one record to test. Then
gave the job of entering data to secretary. Her computer
shows ALL the records, even the one I put in. My table
only shows the one record I input. This table does not
appear to be linked (no arrow by the table name and
properties does not state Linked). How can I get this
back? Is Article 209862 the only way... I hope not.

Thanks
 
Go to File->Get External Data-> Link Tables. In the window
that pops up locate the Database(BE) and select the table
and you should be OK. you might want to delete the table
with out the link. If you dont then another table with a
suffix 1,2... would be created. BE SURE TO TAKE THE BACKUP
BEFORE YOU DELETE ANY THING FROM YOUR EXISTING SYSTEM.

Just to be on the safe side.


HTH
 
Okay, I see what I did wrong. But, the new file has a
Number 1 extension and if you delete the other file
(original) you lose the link again. What gives? Do we live
forever with those unlinked tables?

Thanks
 
Hi

When you link to a remote table, you end up with a pointer. For practical
purposes this pointer is a table (it acts just like any other table that's
created locally). At the time you link to remote table, by default the
pointer is given the same name as the remote table unless there is already
another table with the same name (you cant have two tables with the same
names whether local or linked), in which case the pointer will use the same
name as the remote table with the 1 extension.

So, if I link to a remote table called tbl, I would have a pointer
lled ->TBL (note the arrow). If I link to the same table AGAIN, I would
have a pointer ->TBL1.

Okay, I see what I did wrong. But, the new file has a
Number 1 extension and if you delete the other file
(original) you lose the link again. What gives? Do we live
forever with those unlinked tables?
Click to expand...

Try renaming the "new file" without the 1. (Delete the "1" extension from
the newly created link)


HTH
Immanuel Sibero
 
Back
Top