Software

Ask something
Discussion Locked

Switch between Access 2000 back-ends?

0 helpful
3 replies

by yozein

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a database that needs to be archived annualy. (I had been manually compacting the current file into a "2001.mdb", "2002.mdb", etc)

I want to automate this for the users so it needs to be idiot-proof. My system is split into a front-end/back-end setup and here's what I really want to give them:

1) A command button that will perform the backup process, could prompt them for the filename to save as.
2) The ability to switch the data file to use as the back-end so they can use the same front-end to view the data from 2001, 2002, etc.

Is there a simple way to change the file being used for the back-end? There are a lot of tables but they all come from the same file. All of these files are the same structure, just with each year's specific data.

Anybody know how to pull this off?

3 replies

by swardco

The easiest and most idiot-proof method is to run through the database tables collection, determine if the table is linked, then change the property where the table is linked to. You can of course add in a input box for the users to select which year they want (I wouldn't have them type in a path just a year), then you could quickly switch back and forth between any year. You could use the same basic technique for the backup also except prompt them for a backup database name. I would also try and keep the backup copies in a different location then the yearly locations but that would require a little more programming on your part.

Steve Ward

by yozein

I actually solved it on my own (pretty close to that technique) but you were the only response I got so you can have the points!

This discussion is closed to new replies.