[AccessD] Check connection to SQL Server silently

[Gustav Brock]

Hi all

When I run that code which uses late binding, and I check the version, it reports 6.3.
How is that? I see no such version listed? Is it native to Windows 8.1 which Access 2013 just knows about?

By the way, it takes less than 1/100 second to load that object. I've always had the impression, that late binding was a bit slow. Is it just ADO that loads this fast?

/gustav

________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Gustav Brock <gustav at cactus.dk>
Sendt: 15. marts 2015 18:15
Til: Access Developers discussion and problem solving
Emne: [AccessD] Check connection to SQL Server silently

Hi all

If you try to access an SQL Server table via ODBC and DAO when the server is offline, before any error is thrown two message boxes pop up from the driver, one large (Microsoft SQL Server Logon) with an extended message, one small (SQL Server Logon) with an option to login (which is of no use at all).

I found this which uses ADO to check the connection without these messages:

    http://bytes.com/topic/access/answers/201502-how-suppress-odbc-connection-dialog

but can it really not be done with DAO and Access 2013? You could with the OpenConnection method for a ODBCDirect workspace but this was removed in A2013.

If I have to use ADO, which version should I reference in A2013? I see 2.0, 2.5, 2.6, 2.7, 2.8, and 6.1.
The application will run with an A2013 runtime.

/gustav