mdb backup

[Alex Dybenko]

hi,
before running backup you have to be sure, that all forms/reports/recordsets
are closed, else you will get such message. You can loop through all
forms/reports and close them. As for Autoexec macro - perhaps you opening
some form or recordset before you calling mcBackup, you have to call
mcBackup in a first line of Autoexec macro

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Lateral]

Hi Alex,

Thanks for the quick reply!

I have only the following items in the Autoexec macro:

Run Macro - mcBackup
Run Code - fRefreshlinks ()

I also have a "Switchboard" specified at startup.

As I am new to Access, any ideas how I can resolve this? I want a backup to
be done automatically every time a user starts the application.

Regards
Greg

 

[Lateral]

Hi Alex

I figured out how to get it all to work!

I simply moved the invocaction of the Switchboard from the Startup to the
Autoexec macro and everything is not working.

I have a question, my application will have upto 5 users and I really only
want one of the users to be doing the backup automatically. What is the
easiest way to do this? Please remember that I am new to Access.

Thanks
Regards
Greg

 

[Alex Dybenko]

Hi,

I have a question, my application will have upto 5 users and I really only
want one of the users to be doing the backup automatically. What is the
easiest way to do this? Please remember that I am new to Access.

to identify certain user you can use windows login, which you can get using
following API:
http://www.mvps.org/access/api/api0008.htm

but if you have other users opened same backend - this backup will fail.


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com