By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Locked Records

P: n/a
I have an Access application. It's a multi user system run over the
network with A2K2. The initial page displays the results of a couple
queries that summarize the status of several "accounts" based on data
in the system. The porblem is while one user is viewing this screen
it locks all the records of anything being queried so other users can
not update data until the user moves off the screen. How can I query
any of my tables I want to and present that in a form and leave the
records unlocked so other users can still update any record? I don't
want to generate additonal tables if possible.

thanks

Jeremy Smith
je****@mail.com
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Jeremy Smith" <je****@mail.com> wrote in message
news:21**************************@posting.google.c om...
I have an Access application. It's a multi user system run over the
network with A2K2. The initial page displays the results of a couple
queries that summarize the status of several "accounts" based on data
in the system. The porblem is while one user is viewing this screen
it locks all the records of anything being queried so other users can
not update data until the user moves off the screen. How can I query
any of my tables I want to and present that in a form and leave the
records unlocked so other users can still update any record? I don't
want to generate additonal tables if possible.

thanks

Jeremy Smith
je****@mail.com


Set the query's Recordset Type to "Snapshot".
Nov 12 '05 #2

P: n/a
Thanks but I tried that first and it didn't work...that's why I'm
puzzled. The query in question is a query built from a sub query.
The sub query pulls about three tables of data together. I set both
querys to snapshot as well as the recordset property on the subform
that is connected to the query. So I'm still looking.

Thanks

Jeremy Smith

"Matthew Reeves" <mr*****@nospam.bytemyzer.com> wrote in message news:<vn************@corp.supernews.com>...
"Jeremy Smith" <je****@mail.com> wrote in message
news:21**************************@posting.google.c om...
I have an Access application. It's a multi user system run over the
network with A2K2. The initial page displays the results of a couple
queries that summarize the status of several "accounts" based on data
in the system. The porblem is while one user is viewing this screen
it locks all the records of anything being queried so other users can
not update data until the user moves off the screen. How can I query
any of my tables I want to and present that in a form and leave the
records unlocked so other users can still update any record? I don't
want to generate additonal tables if possible.

thanks

Jeremy Smith
je****@mail.com


Set the query's Recordset Type to "Snapshot".

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.