Split database - how to run VBA stored in the backend?

[Tim Cali]

I notice that for a split database, only tables are stored in the backend.
What about code/procedures?

Is it possible to store modules in the backend and invoke the routines from
them from the front end?

If so, how?

 

[chas]

Hi Tim,

in the VBA editor select Tools>References and then Browse
to the backend .MDB file that you want. I can't see why
you would want to do this though as the whole point of
splitting the databases up is to seperate the code from
the data, it may make more sense to put the code into its
own MDB file seperate from the backend tables and the
frontend application..

hth

chas

 

[Tim Cali]

Would not there be a time when a routine should be rewritten, say to execute
differently/faster? In that case, wouldn't code on the backend be easier to
modify?