J
John Ortt
I have an access database (Create1.mdb) which is used to compile data from
one of our mainframes on a weekly basis. This data is then saved onto
linked tables in a separate database for the users to view stats.
This is all carried out by a macro, and after it has downloaded all the data
from the server and compiled it, the next stage is to open up a separate
database which pulls in additionnal data from a separate server and adds it
to the stats database
This macro which updates this database has a command line which reads
""C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
d:\temp\Create2.mdb".
When the Create2 Database opens there is an Autoexec Macro to continue the
process.
This has always worked well but I now wish to have another database open the
"Create2" database but without running the Autoexec. I would like it to run
a separate macro (called "Alternative" for example).
Is there any way that I can open the "Create2" database with other Access
database's and run different macros depending on which database opened
"Create2"?
Any help would be greatly appreciated.
Thankyou,
John Ortt
one of our mainframes on a weekly basis. This data is then saved onto
linked tables in a separate database for the users to view stats.
This is all carried out by a macro, and after it has downloaded all the data
from the server and compiled it, the next stage is to open up a separate
database which pulls in additionnal data from a separate server and adds it
to the stats database
This macro which updates this database has a command line which reads
""C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
d:\temp\Create2.mdb".
When the Create2 Database opens there is an Autoexec Macro to continue the
process.
This has always worked well but I now wish to have another database open the
"Create2" database but without running the Autoexec. I would like it to run
a separate macro (called "Alternative" for example).
Is there any way that I can open the "Create2" database with other Access
database's and run different macros depending on which database opened
"Create2"?
Any help would be greatly appreciated.
Thankyou,
John Ortt