Start ADP WITHOUT attaching to the Backend first.

[sparkbyte]

I would like to have my ADP NOT attempt to attach to the SQL server backend when it first starts up.

So that I can use some VBA code to do some error checking and handling as athe connection is attempted.

Is there a way to disable the portion of the ADP that wants/requires it to attempt to connect to the DB backend during launch????



Thanks

John Fuhrman

 

[PWise]

I dont know if you can start the ADP whit out a connection to a SQL database what i do is run an autoexec macro that runs code and in the code i use

Dim obj As Object
set obj = CurrentProject
With obj
.CloseConnection
'do checking 
'do setting
.OpenConnection MyConnectionString
end with

 

[sparkbyte]

Well, the command-line does not seem to have an aoption to over-ride it from connecting to the default BE unless it is an Access DB. Or at least I have not been able to find any example/documentation on how to use the database param to connect to a SQL BE.



Thanks

John Fuhrman