| Reggie Laffond 2005-04-07, 8:04 pm |
| When you copy and paste a linked table in a front end database you are
simply creating a second linked table pointing to the same table in the back
end. When you do that you have not created anything new in the backend
database.
Remember, the name of a linked table has nothing to do with the name of the
actual table it is pointing to. You can rename the frontend linked table to
any new name and it will still be linked to the same source table in the
backend.
In your case you have two linked tables with different names (copiedTable
and originalTable) both pointing to the same backend table.
"Rover" < rover44614@RemoveThi
sStuffNetscape.net> wrote in message
news:TNKdnWuJJY4Vf7j
fRVn-rA@massilloncabletv.com...
> I have a database that is split. The tables reside on a server and the
> queries forms reports etc. reside separately. I just found out that a
> copy of a table (I do that copy in a form) appears to just be pointing
> to the original table. Furthermore any updates I do to the copied table
> are happening on the original table.
>
> In the linked Table Manager:
> => originalTable (\\computer\folder\d
atabase.mdb)
> => copiedTable (\\computer\folder\d
atabase.mdb)
>
> yet when I go to the database there is no table named copiedTable.
>
> What am I doing wrong?
>
> Jim
>
|