(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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx