[OBP]

Can you outline for which is the Current problem, as you seem to have had a few.
Is the Switchboard or the backup?

[computerman29642]

When the backup is created, everything appears to work properly. However, if you click on the first button on the switchboard, it will open just fine. Then if you click on the second button (Preview Report), it will work fine as well. Now, go back and click on the first button again, and you will get an error message.

[OBP]

The Access "Switchboard" is not a standard Form, which is what I use for my Main Menu (switchboard) in my databases. I think an element of the Switchboard is stored outside of the database and it may be losing it's link to it.
If you change your Switchboard to a normal Form with Command Buttons it should overcome the problem.
How are creating your "Backup"?

[Rollin_Again]

Tony,

Thanks for joining and trying to provide some assistance. The backup is being created automatically when the DB is first opened. This is accomplished by using the AutoExec macro to fire some VBA code. The VBA code is nothing more than using FSO (File Scripting Object) to copy the DB to another location after appending the date to the backup DB name. Do you know of any other ways to automatically backup the DB when it is first opened or when it is closed?

Regards,
Rollin

[computerman29642]

Tony, if you think the best thing to do is create a "Main Form" instead of using the switchboard, I will certainly be happy to do that.

[computerman29642]

Tony, I created my own switchboard form (frmSwitchboard). I tried running the database to create the backup, but now I get permission type errors.

Please review the attached database.

[computerman29642]

Do you think the permissions issue is because it is being created on a network?

[computerman29642]

I tried to create the backup locally instead of on the network, but I am still getting permission errors.

Do you think it maybe due to how I have the startup setup?

[Rollin_Again]

I'm not sure since I'm not super proficient with Access. The only other thing I can think is that since the DB is open when it is being copied it may be corrupting the DB somehow. The only other solution I can think of is to use a VBS script or to compile a VB executable file that will first copy the DB in question to another location and then open the original for the user to work on. Instead of clicking the Access icon or DB shortcut the user would actually click on the EXE or VBS file instead which would programatically open the DB after first making the backup. Would that work for you? If so, will all users have the network drive mapped the same or will they be able to access using a set file path such as \\ServerName\Directory\Resource

Regards,
Rollin

[computerman29642]

Rollin, Once the database has been completed, it will not be on a network. It will only be on a local hard drive.

Is there a way to have the code delete the old backup when a new backup is created?

[Rollin_Again]

Originally Posted by gamecockfan

Rollin, Once the database has been completed, it will not be on a network. It will only be on a local hard drive.

Is there a way to have the code delete the old backup when a new backup is created?

Absolutely. Do you only want to maintain 1 backup copy or multiple copies? I like to keep several backups as a safety precaution. The code I use at work keeps the last 5 copies of my Excel workbook in a backup directory. The same theory could be applied to Access.

Regards,
Rollin

[computerman29642]

Absolutely. Do you only want to maintain 1 backup copy or multiple copies? I like to keep several backups as a safety precaution.

In your opinion, how many backup copies should I keep? I was thinking like two copies.

[Rollin_Again]

Copy and Paste the code below into a text file and then manually change the file extension to .vbs

Change the path to reflect your DB file that you would like to open (vSource)
Change the Destination path to reflect where backup should be saved (vDestination)

Then change the line so that the original DB path is shown
wshShell.Run "MSACCESS.EXE C:\Test\Test.mdb"

Dim vSource
Dim vDestination
Dim objFSO
Dim wshShell
vSource = "C:\Test\Test.mdb"
vDestination = "C:\Test\Backup\" & Replace(Date, "/", "_") & ".mdb"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set wshShell = WScript.CreateObject ("WSCript.shell")
objFSO.CopyFile vSource, vDestination

wshShell.Run "MSACCESS.EXE C:\Test\Test.mdb"
set objFSO = nothing
Set wshShell = nothing

Run the VBS file and the backup should be made and the original DB opened automatically. From now on when you need to open the DB just open from the VBS instead of clicking the saved MDB file.

It only saves one copy and it is updated each time the DB is opened. If you want to change this later we can look into it.

Regards,
Rollin

[computerman29642]

Thanks Rollin'.

[computerman29642]

Roliin, the code appears to be working. Thank you very much.