Hello melkin,
I saw your post from a while back now and I think I see the problem, and I wanted to let you know just in case you were still having a problem. In your connection string you specify:
Code:
Data Source=C:\inetpub\wwwroot\myaccount\database;oddli st.mdb
Which contains a ";" character in the database file name, and that would be invalid, because the semi-colon is used to terminate parameters in the connection string. So, to fix your problem, you should just be able to fix that path and I think that will take care of the issue.
Anyway, I hope that helps, but if you have more questions, please let me know...
Good Luck,
Geoffrey L. Griffith
http://www.ImagineThought.com
Wrox Author of:
Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference