Multiple tabels point to one table error

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

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\database.mdb)
=> copiedTable (\\computer\folder\database.mdb)

yet when I go to the database there is no table named copiedTable.

What am I doing wrong?

Jim
 
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\database.mdb)
=> copiedTable (\\computer\folder\database.mdb)

yet when I go to the database there is no table named copiedTable.

What am I doing wrong?
Click to expand...

You're simply copying the *LINK*. The "table" in the frontend isn't a
table; it's just a pointer to the actual table in the backend. When
you copy it, you're making a copy of the pointer, and it continues to
point to the same actual backend table.

Why do you copy a table at all? This would seem to be a VERY rarely
needed (not to mention timeconsuming and bloating) operation!

John W. Vinson[MVP]
 
Well, doesn't that explain a few things! Thanks!

I have a very small table, 118 rows, of categories, subcategorizes and
descriptions. For one report I have to modify those subcategorizes to
make the report sum properly. It works great the first time but doesn't
there after because I've changed the underlying table I thought I copied.

So, how do I resolve this?

Jim
 
So, how do I resolve this?
Click to expand...

Find a better way to generate the report than modifying the contents
of your table!!

Perhaps you need a second table joined to the categories table to
"recategorize" it for the purposes of this report, or a call to the
Switch() function (or a custom VBA function) to do the same.

John W. Vinson[MVP]
 
Back
Top