>Hmm seems easy. I am not familiar with ODBC connections so how do you create the connection? Can you point me in the right direction?
- Go into Control Panel
- There will be an app with ODBC in the name - open it.
- There should be a System DSN tab - if so, go to it. If not, the first tab is fine.
- Click Add
- Find Microsoft Access driver and select that
- Give it a name - this will be used when connecting - e.g., MyAccess
- Give it a description - this is just text for you to know what it is
- Click Select... -- this lets you browse to an mdb file.
- If there is a login/password, you may add that on the Advanced Tab, but it's not necessary
Now that you have that, you should be able to run the code from my previous post.
Insanity: Doing the same thing over and over and expecting different results.