Update append query

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,

I have an append query that I run, which usually I append about 300 records
per update. My question is Can I run the append query while other users
are logged in the database and using the same table that is being updated?
What can happen? I seems to be a pain to tell users to logged off. Any
tips or website or book suggestions will be appreciated. Thank you in
advance.
 
Access is a multi-user program, and the default is optimistic record
locking. You should be able to append the new records without too much
drama. The worst that can happen is that you end up with some records
appended and not others, but I would not expect that to be an issue.

If you have multiple users in the same database, presumably you have already
split it into 2 files: a shared back end, and a front end installed on each
workstation. If that's a new idea, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html
 
Back
Top