backup database on a table level

[shopwise]

I have quoting software which contains an access backend. It is not possible to move the location of this software's database file to my web directory but I would like 4 of the tables to be contained in my website's database.

I have therefore duplicated the 4 necessary tables from database1 (quoting software) to database2 (website's database) and now require that they be backed up regularly into my database2 (website's database).

I assume it is not possible via Access to back up database files on a table level rather than on a database level?

Can a programmer create an app to achieve this? If yes, what type of programmer?

 

[SkipVought]

Hi,

you might get better answers if your post in one of the many MS Access forums in Tek-Tips.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Andrzejek]

In your Access VBA you can connect to Database2 (website's database), collect all info from your 4 tables from your database1 (quoting), delete all records in your DB2 and insert all new info from DB1.

You may just want to get the new records added only to DB2, but you need to remember about other records that were updated.

I don't know how often you want to do this, but if that was me, I would create a small program in VB 6, create an EXE, use my Task Scheduler to schedule this program to run every X days/weeks/months/whatever.

Have fun.

---- Andy

 

[shopwise]

thanks for your response Andrzejek!

As I do not know programming, wondering as follows:

If I create a make table query to accomplish what you have described, can I create a macro to run this query and then use my Task Scheduler to schedule the macro to run every so often?

Don't know if automating this would work because Access prompts me every time I manualy run the make tabe query indicating that I am deleting records.

 

[PHV]

Can't you use linked tables in your website's database ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ettienne]

What about replication?
Access supports replication.

 

[shopwise]

I have tested using linked tables in the past but I believe that I cannot upload a database to my webserver if the linked tables reside in a database outside of my web directory.

As far as replication, can you please simply describe what this accomplishes?

 

[ettienne]

Replication:

http://dfenton.com/DFA/Replication/index.php?title=Main_Page