Using MyODBC

[|PiP|]

Hi, I am using MS Access 2003, connecting it to a MySQL database using
MyODBC. Time to time however, I get ODBC errors saying "the MySQL
database has disappeared". I re-open the MS Access file and the
connection works. Is this a problem with the MyODBC driver or MS Access.
If it is a problem with the MyODBC driver, would using an MS SQL Server
(like the Express Edition) serve me better? Can Access connect to MS SQL
natively? Thanks.

 

[Jeff Boyce]

I don't know about issues with MySQL and MyODBC, but you could try searching
using MS search or Google.com with those keywords.

I've been using Access & MS SQL-Server for years without getting a "database
disappeared" error.

You'd link between the Access front-end and the SQL-Server database using a
SQL-Server-specific ODBC driver (if using DAO), or by using a Connection (if
using ADO). I've been using the former without incident.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/