I am very new to all this
I have a access databse wich uses a ODBC conection to mysql server. I
can open the and run the database find but if i leave the dadabase
loaded but do not use it when i go back to it is has lost the
conection and i need to close the databse and reopen it
If there a way to make sure i alwasy have a coenction
Thanks
(S.Dickson@shos.co.uk) writes:
> I am very new to all this
>
> I have a access databse wich uses a ODBC conection to mysql server. I
> can open the and run the database find but if i leave the dadabase
> loaded but do not use it when i go back to it is has lost the
> conection and i need to close the databse and reopen it
>
> If there a way to make sure i alwasy have a coenction
That seems like an Access problem to me. Maybe you should ask in an
Access newsgroup.
Do you use MySQL or is that just a typo? This news group is for
MS SQL Server, and not MySQL.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx