By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Modify a remote macro or startup procedure

P: n/a
I have hundreds of Access (2.0,97,2K) databases that I need to insert a
sub procedure into, which is to be ran at every startup.

Does anybody know of a way to remotely, programmatically either:
1) modify all autoexec macros to add an action to run this procedure
OR
2) designate it to be ran from TOOLS>STARTUP, inserted into a form
Any code examples or suggestions would be appreciated.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Anybody have ANY ideas?

da*******@yahoo.com wrote:
I have hundreds of Access (2.0,97,2K) databases that I need to insert a sub procedure into, which is to be ran at every startup.

Does anybody know of a way to remotely, programmatically either:
1) modify all autoexec macros to add an action to run this procedure
OR
2) designate it to be ran from TOOLS>STARTUP, inserted into a form
Any code examples or suggestions would be appreciated.


Nov 13 '05 #2

P: n/a
da*******@yahoo.com wrote:
Anybody have ANY ideas?

da*******@yahoo.com wrote:
I have hundreds of Access (2.0,97,2K) databases that I need to insert


a
sub procedure into, which is to be ran at every startup.

Does anybody know of a way to remotely, programmatically either:
1) modify all autoexec macros to add an action to run this procedure
OR
2) designate it to be ran from TOOLS>STARTUP, inserted into a form
Any code examples or suggestions would be appreciated.


You could try some sort of DoCmd.TransferDatabase but I'm not sure if
that does macros (or copyobject).
You'd need to copy it into your working database, modify it then copy it
back to the target database.
Not sure how those commands would handle older versions though.

--
This sig left intentionally blank
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.