Read only woes with linked table

tom_crisp

Board Regular
Joined
Jul 28, 2006
Messages
133
I have an Access application (a) on a network drive that contains a couple of queries and a form. There is a linked table that resides in another database (b) on the same drive, in the same folder.

The reason for this is that (b) is an admin application for adding/amending data, and (a) is just a viewer for finding records and clicking on links in them. (a) will be used by many people, whereas only one person at a time will be using (b)

The form in (a) contains a subform that has a query as its control source. The query (a) runs on the linked table (b).

This all works perfectly for me as I have read/write access to the drive, however people that only have read access get a blank white box where the subform data should be. I have tried re-linking the table, but I am unable to do this either.

How can I make this form work for the read only people without changing their access rights?

Thanks in advance.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

tom_crisp

Board Regular
Joined
Jul 28, 2006
Messages
133
I ended up putting a button on the admin side (b) that copied the table to (a), using the transferdatabase method, that needs to be pressed after any changes are made.

I'm happy with the solution, but am still interested to see if there is a better one.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,561
Messages
5,765,109
Members
425,260
Latest member
worldbfreebase

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top