Append Query in Multi-User Environment

[Bonediggler1]

Hello-

I am building a DB that will be shared among several users. I am planning on splitting the DB to one back end file and distributing as many front-end .mde files as needed (probably no more than 3 or 4).

One of the tables in the back end will need to be updated daily via an append query and I am wondering:

1) What is the most efficient way of doing this (i.e. can this be done without involving me or the users)?
2) In the event the users have to run the query themselves (via a button, etc), what happens if two users run it at the same time?


Thank you!

 

[Remou]

You can run the query at a set time with the task scheduler, or you can run the query with the first mde opened. You should add the date to a suitable table to say the query has run.

http://lessthandot.com

 

[Bonediggler1]

Thanks Remou I think I will try the Task Scheduler...

 

[Remou]

If you are using the task scheduler, you might like to consider a little VBScript. You can use ADO to run the query.

http://lessthandot.com