Missing English Driver

[Amy Blankenship]

I have a connection string in my application that looks something like:

"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & PathtoDB

I just spoke to a user who can't connect to the database. We went into his
control panel to see if he could create a DSN to it, and the Microsoft
Access Driver (*.mdb) was missing from the list of file types he could add,
though he had what looked like they might be German and maybe Portuguese
versions. We could create a German dsn, which worked for an application
based on DSN's, but I can't depend on being able to create DSN's on systems
that we deploy to, so a DSN is not an option.

He reinstalled MDAC and rebooted, but this did not install an English driver
to the system.

How did he manage to delete this, and how can I help him put it back? He
works for the client as well, but we could potentially have a paying user
see this error, and we need to be ready.

Thanks;

Amy

 

[Nick Coe \(UK\)]

Check that all appropriate references exist on that specific
users machine from within the Access vba editor.

I can vaguely remember this happening a few years back and I
think I ended up re-installing Access on the problem
machine.

Sorry I can't be more help.

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In Amy Blankenship typed:

 

[Douglas J Steele]

What version of MDAC did you install? MDAC 2.5 was the last version to
include Jet drivers, so if you picked a newer version of MDAC, it wouldn't
have had any impact on providers for Access.

Try going to http://msdn.microsoft.com/data/mdac/downloads/default.aspx and
installing whichever version of Jet 4.0 Service Pack 8 is appropriate for
your situation. (If you're using Access 97, you can get Jet 3.51 SP3 at
http://www.microsoft.com/downloads/...88-52ec-4a8f-8bb2-8b06d6cb668d&displaylang=en )