Using VBA to Backup some tables in the Backend database

[anasser]

I have a database in Access 2002 the tables for the database are linked
from another Access 2002 database located in the same folder (its done
this way for support purposes so the time to transfer the corrupt
frontend database, if so, over the Intranet would be fast since the
size is smaller). I would like to have the user to be prompted once
between the 25th and the end of the month whenever they are connected
to the network, to save a set of tables from the backend database to a
fixed location on the network in a specific file (named specially for
this specific user).

How can I do this in VBA (from the frontend database) or maybe from a
VBScript that can be installed on all the users machines for this
database?

Any help please let me know. Thanks in advance...

 

[Arvin Meyer [MVP]]

I wouldn't bother prompting the user. Write a small database front-end thast
uses the TransferDatabase Method to move tables to another database file.
Use a scheduled task that runs automatically once a month on the server, if
possible, or from a workstation if you can't run it from the server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[anasser]

I was unable to use the TransferDatabase Method to move tables to
another database file on the network, unless I am doing it wrong...Do I
need to include a new reference for that? and how can I schedule a task
through the workstation? do you mean writing a VBScript for it?

 

[Arvin Meyer [MVP]]

I was unable to use the TransferDatabase Method to move tables to
another database file on the network, unless I am doing it wrong...Do I
need to include a new reference for that? and how can I schedule a task
through the workstation? do you mean writing a VBScript for it?

TransferDatabase should work without any additional references.

Scheduling a task is done with the Windows Task Scheduler which you'll find
in the Control Panel:

Start ... Control Panel ... Scheduled Tasks ... Add Scheduled Task
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

TransferDatabase should work without any additional references.

Scheduling a task is done with the Windows Task Scheduler which you'll find
in the Control Panel:

Start ... Control Panel ... Scheduled Tasks ... Add Scheduled Task
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access