Your problem isn't the connection. It's the fact that you have characters
after the end of your string value. It's the same as if you had a line of
code like this:
x = "something"kjaslkjfao;9sduf8asijdf
The kjaslkjfao;9sduf8asijdf characters cannot appear outside of the quotes
like that.
A few other things:
1. Don't use an ODBC connection. Use an OLEDB connection string for your
Access database by modeling your string around this sample from
www.connectionstrings.com
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"
2. Get your database OUT OF THE WWW AREA OF YOUR SITE. I just downloaded
your database (and deleted it...). Anyone in the world can download it,
espeically now that you told the world where it is!
Ray at work