Access 2007 - Copy linked table to a local table or have linked tableas read-only

S

Stuart

Hi

We have an accounting system with all our tables in there. I noticed
that I can write directly to the accounting systems tables which we
don't really want to be able to do.

I was thinking someone could help explain how we can copy the linked
table to a local table and refresh this every so often to ensure its
kept up to date.

Can someone help me by outlining the best way to do this?

Thanks alot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Table Manager Errors 12
Macro to copy linked table and paste as local table 2
Linked Table and Read Only Issue 1
Rename Linked Table (If Needed) 6
change connection string to linked table with VBA 10
Linked table behavour 1
swap tables when more than one table is linked to primary table 7
Changing a Table to a Linked Table? 4

Top