[Rollin_Again]

Originally Posted by gamecockfan

Are you able to open the tables. forms, etc.?

Yes I am.

Is the backup DB being moved to a different location after the copy is being made?

One potential problem that I see is if the DB is copied to a different location is that the when the DB copy is made the AutoExec macro and it's associated VB code is also copied to the backup copy. When you try to open the backup copy the AutoExec macro will try to fire again. Since you "hard coded" the value for OldDbName in the original code an error may occur because the filepath will change if opened from a different location.

Regards,
Rollin

[computerman29642]

Originally Posted by Rollin_Again

Yes I am. What happens if you copy the backup DB to the same directory as the original DB?

Regards,
Rollin

It does that now.

I believe I have found that the problems is when the folder i son a network. I just tried using the code on a database that is on my desktop, and it opened just fine.

However, I thought I tested that before.

[computerman29642]

Nevermind, I just tried it on the network, and it worked just fine. I am not sure what was going on.

Is this possible....Could the macro be setup to run at the end of the week or month?

[computerman29642]

Well, it was working. When I was using the backup copy of the database, the buttons on the sitchboard stopped working. I got an error message "Command could not be executed."

Have you tried clicking on all the buttons, and then re-clicking the first one again?

[Rollin_Again]

Originally Posted by gamecockfan

Have you tried clicking on all the buttons, and then re-clicking the first one again?

Which buttons are you talking about? I am unable to duplicate the error.

BTW...If you want the code to fire on the last day of the month you can use an IF statement

If Date = DateSerial(Year(Date), Month(Date) + 1, 0) Then

'Your code here

End If

Regards,
Rollin

[computerman29642]

I do not remember how the database works that I sent you. When I open my database, a switchboard is displayed.

When the backup copy is created, I can open the backup copy and click the buttons on the switchboard just fine. However, onece I go down the list, and then re-click the first button on the sitchboard again, I get the error message.

Would you like for me to capture the error message?

[Rollin_Again]

I don't get a switchboard on the copy you sent to me. Can you send me an updated copy?

Regards,
Rollin

[computerman29642]

I have attached a updated version of the database as you requested.

[computerman29642]

I forgot to change the database name in the Backup module for the attached database.

[Rollin_Again]

Did you protect the code? Since I can't access the module to make the name change the DB is not being copied.

Regards,
Rollin

[computerman29642]

Sorry, I changed the startup of the database. I have re-attached the database. The code should work now.

[Rollin_Again]

I'm getting the same error now too. Can you repost the DB after removing any protection you have added. I am unable to view the tables and code since the print option is the only available option I have.

Regards,
Rollin

[computerman29642]

Once again I apologize. I have attached the requested file.

[Rollin_Again]

I am clueless why this is happening. The problem does not occur when the backup copy is made from the unprotected DB and the switchboard is run manually. Maybe OBP might be able to shed some light on this. I'll send him a PM.

Regards,
Rollin

[computerman29642]

Sounds good. Thank you very much Rollin for the help and effort.