linked tables

I have a linked table in Access from another Access database. I want the
table to update when changes are made in the other database, but I do not
want any changes I make to the table to update in the other database
(essentially, I don't want to accidentally make a change to someone else's
table). Is there any way to make the linked table go only one way (with me
being unable to make changes but for the table itself to still get updates
from its original source)?

You can try this --
Backup database Backupdatabase

Create select query by adding the table twice in the design view. Join the
two by a couple of fields. Name the query. Try making a change.

If you can not then hide the orignal table.

"LT" wrote:

I have a linked table in Access from another Access database. I want the
table to update when changes are made in the other database, but I do not
want any changes I make to the table to update in the other database
(essentially, I don't want to accidentally make a change to someone else's
table). Is there any way to make the linked table go only one way (with me
being unable to make changes but for the table itself to still get updates
from its original source)?

Hi,

Can you please explain these steps a little more? Would creating a query
from the linked table still allow me to see updates from the original table
while not allowing my changes to show up on the original?


Thanks,
Lou


"KARL DEWEY" wrote:

You can try this --
Backup database Backupdatabase

Create select query by adding the table twice in the design view. Join the
two by a couple of fields. Name the query. Try making a change.

If you can not then hide the orignal table.

"LT" wrote:

I have a linked table in Access from another Access database. I want the
table to update when changes are made in the other database, but I do not
want any changes I make to the table to update in the other database
(essentially, I don't want to accidentally make a change to someone else's
table). Is there any way to make the linked table go only one way (with me
being unable to make changes but for the table itself to still get updates
from its original source)?

By doing the steps I proposed you create a query that is not updateable (I
believe, that is why I suggested you check).

Then hide the linked table.

"LT" wrote:

Hi,

Can you please explain these steps a little more? Would creating a query
from the linked table still allow me to see updates from the original table
while not allowing my changes to show up on the original?


Thanks,
Lou


"KARL DEWEY" wrote:

You can try this --
Backup database Backupdatabase

Create select query by adding the table twice in the design view. Join the
two by a couple of fields. Name the query. Try making a change.

If you can not then hide the orignal table.

"LT" wrote:

I have a linked table in Access from another Access database. I want the
table to update when changes are made in the other database, but I do not
want any changes I make to the table to update in the other database
(essentially, I don't want to accidentally make a change to someone else's
table). Is there any way to make the linked table go only one way (with me
being unable to make changes but for the table itself to still get updates
from its original source)?