Access Database Connection Problems
My company just switched to a new host and I am having a real problem connecting to an Access Database. The site administrator says that Windows 2003 no longer allows DSN-less connections, so they created a DSN to the database. I now need to use DSN syntax instead. I have tried (and tried!) a lot of different codes from other web sites but nothing works.
Here is the old code:
connStr="Provider=Microsoft.Jet.OLEDB.4.0;" & _
Can someone give me a pointer on what the new code should be?