Updating Tables on a scheduled basis?

[Adam]

Hi All,

I have database which has which I would like to copy the tables as it
is access by many different users, so I would like to reduce the risk
of corruption.

I was thinking of setting up another database which tables the last 3
months worth of data from the main database. This would probably be
done from linking the tables I need then running a make table query.

If there anyway I can have the make table query run automated without
my prompt?

Please advise

Adam

 

[Arvin Meyer]

Build a small database as a container to run the code. Use the OnOpen event
of a form to run the SQL or query, and set the form to open on startup. Use
the Windows scheduler to open the database so the code will run.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Adam]

Can you explain a little further please?

I understand the idea of making another small database but how could
the queries in that small database update the tables in my main
database?

 

[Arvin Meyer]

Here's some SQL which from the code running database (Data1.mdb), takes data
from TableOld in a second database (Data2.mdb) and makes a table (Table1)
and puts the data into a third database (Data3.mdb):

SELECT PersonID, * INTO Table1 IN 'C:\Data3.mdb'
FROM [E:\Data2.mdb].TableOld
WHERE (((TableOld.PersonID)=5));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access