(S.*******@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,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx