access autoexec on another box

[texas]

I have 2 computers in my office.

Outlook is setup to launch certain databases when emails arrive with a string in the body of the email, using the rules wizard.

I would like to move all the databases over to my second computer and have them run on that box.

So I’m looking for ideas on how to launch the databases with out them running on my primary computer.

[SergioV]

I'd say it should work that way if :

1.- You moved your databases to the second PC in the same drive/path you have them in the first
2.- You connect to the same account in Outlook AND
3.- Your rules are stored in the server, NOT the PC #1 ( can be saved both ways as far as I remember )

I'd recomend trying and smile... or trying and writing back here your detected symptoms

[texas]

the second computer is not running Outlook. is there some way to "trigger" an Access database on another machine?

[SergioV]

mmmhhh.... I can't think of a "natural" way to do it... but if you can have a program there, that checks, for example, a file in a shared folder and according to this start Access...

[texas]

would this work...?


have a VB app on my computer that executes another VB.exe(2) app on the second pc. set the second(2) vb app "on open" to launch the Access db.


sounds like a krack head plan....

[SergioV]

well, seems you have all you need now then.... but let me ask you ... how did you handle the start of that second app ?

[texas]

i have not started on the code.....


i'm now working on moving the access db over to msde and creating a triger that will do all the updates that i need. so far it's working.


so.....

the outlook wizard will open a small database that will send todays date to the msde table on the second computer. when that table gets updated it will trigger rest of the db... with any luck....

i/we cant think of any othe way around this.....

[SergioV]

Other alternatives are.... if you can have Access open in PC2, waiting for that change being executed from PC1 in a table (attached) or having a winsock based program in PC2 waiting for that trigger to start even more than one process... choice is yours