Linking tables makes linked database readonly

  • Thread starter Thread starter redtux
  • Start date Start date
R

redtux

Using Access 2000, when I link tables in two mdbs the source database becomes
readonly, ie: I cant make any changes to modules, forms, reports etc if I
have the database open (even when linked tables are not being accessed)

Is there any way around this?
 
Do you have rights to write in the directory where the database is to which
your tables are linked?
 
Maurice said:
Do you have rights to write in the directory where the database is to which
your tables are linked?
--
Click to expand...

yeah no problems there - the problem arises when anyone has either source or
target DB open
 

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

Record-Locking remains open after closing 0
linked tables 3
linking tables and relationships 3
Ghost references to deleted tables in a back end database (Access2000 XP) 5
Linked Table Security in MS Access 4
SQL Server Backend is Read Only 7
Linked Table Issue to Oracle 1
table is linked to what other Access database? 8

Back
Top