Query - Open as Snapshot

[jonathanchye]

I have a front/back end database and have a few "read only" queries. I've checked their settings and they are all set to open as "Snapshot" and also record locking set to "No Locks".

I noticed that when I open this query on my frontend, a record locking file is created on the backend thus preventing me from editing the table.

Is there a reason why this is so? How should I create an Access "read only" query? I know about passthrough queries but I don't think that would apply for an Access only situation?

I am using MS Access 2010.

 

[StarGrabber]

Tried to reproduce this behaviour. Without success.

What do you mean by saying "editing the table"? Do you want to open it in 'design view' mode?

-----------------------
StarGrabber

 

[jonathanchye]

Hi,

Sorry I should've phrased my question better. I have a front end that I would only like to use as a view only platform. I have this front end displaying some data from a linked table via query. I made sure any record locking is off, query "opens" table as snapshot mode and also disallow any form of editing in the form.

I find that if the front end is open, I cannot edit (open in Design mode) the table in the back end. I was thinking in "Snapshot" mode I still should be able to edit the table. The more I think about it perhaps this is a limitation of Access vs SQL database.

 

[boblarson]

If a table is in use (which a query would be doing so with a table) then you cannot go into design view of a table. Changing the type to snapshot or anything else, will not change that fact.