Macro: remote execution

[DajTwo]

Hi all

In an Access 2003, front end back end config, how can I have the front end execute a macro located in the back end database with vba on a command button?

The macro is ised to update the tables from a restricted server.

Thanks!!!

 

[Remou]

Check out Run, for example:

Dim ac As New Access.Application

'Database with a function
ac.OpenCurrentDatabase ("C:\docs\ltd.mdb")

'Function that needs to be run with one variable
ac.Run "SetVar", CurrentDb.name

http://lessthandot.com

 

[DajTwo]

Thanks

I used the runapp command in a macro.. and seems to work well.

I will keep your method in mind though!!!

Thanks again