Reconnect at startup

A

Anne

Allen Browne has on his website guideline for splitting the database, which
is easily understandable.
Also listed is a function to run which is called
Reconnect Attached tables on Start-up
Except I do not understand what I would have to do, to get this to run.
I copied the function into a module.... and then what do I do?
It seems to me that perhaps autoexec macro needs to be put into a shortcut?
Since the Frontend and Backend do not need to be reconnected everytime you
open the database. Can this be done from a command prompt?
Can anyone give me a clue on how to do this?
Anne
 
A

Allen Browne

Hi Anne

When your application starts, use RunCode in your AutoExec macro to call a
function. In your function, use OpenRecordset to open one of the linked
tables. If that fails, then you need to run the Reconnet() code. Your
function will use error handling to handle the case where that fails.

The code at:
http://members.iinet.net.au/~allenbrowne/ser-13.html
assumes that the front end and back end are in the same folder. If that is
not the case, and you need a more comprehensive example, there is one in
Microsoft's solutions.mdb example database at:
http://msdn.microsoft.com/library/officedev/bapp2000/mdbdownload.htm
 
Top