run backend macro from frontend form

[tractorvix]

I have a frontend system which works very well. However, I would like to be able to call a macro (which updates table contents) which is stored in the backend database.

I have considered opening the backend using the call shell function and then setting up the macro to run on open, but I can see problems occuring as the information can only be updated once a day.

Any ideas?

Vix

 

[lupins46]

Why is the macro in the backend?

 

[tractorvix]

The backend has lots of ODBC links to our AS400 system. I'd rather the users didn't have access to these tables directly. The macro pulls the info from the AS400 into the appropriate tables.

The tables that it creates are then linked in the frontend to minimise the potential damage they could do!

Vix

 

[crobg]

You can use a run app macro that opens the back end database with the run macro switch. (/x)