Passing input arguements to a database

[Fozzie22]

Hi everybody,

Ok here is the scenerio. I have an updater database that when executed checks the version of another database on the users computer with the copy on the server. If they are different the it copies the server database to the users computer and opens it. Simple.

What I would like to do is extend the process so that the updater database can perform the task mentioned above to my other 5 databases.

My thoughts on the problem would be to pass an input arguement to the updater database, like a number, and that number would then indicate which database to update and open on the users computer.

Does anyone know if you can pass input arguements to an access database using a shortcut on the desktop or can somebody suggest a simpler way of doing this.

Thanks

Foz

 

[CautionMP]

I don't have an answer, but here is a direction, try looking at Startup command-line options in the application help file.
You can specify /x macro as a startup option for a shortcut.
Without fully visualizing your process I'm thinking you could create a macro in the updater for each database and call the macro based on which shortcut...

Hope this helps,
C...only half a cup of coffee...P

Instant programmer, just add coffee.

 

[Fozzie22]

Thanks

That sounds like a good idea. I will look into it