Re: Cannot Open Access File

Tech-Archive recommends: Speed Up your PC by fixing your registry

"dancer" <dancer@xxxxxxxxxxxxx> wrote in message news:uO6ghuvwHHA.4572@xxxxxxxxxxxxxxxxxxxxxxx

I am using Access 2003.

Have you actually installed a copy of Microsoft Access on your webserver? Yes or no?

I created another Access file,

No you didn't! You created another Jet database! I know you *think* you're using Microsoft Access, but you really aren't...

DBConnection = New OledbConnection("Provider=Microsoft.Jet.Oledb.4.0;"

See, there's the thing right there. Look at the Provider part of your connection string - it's using Jet 4...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

.