Re: Cannot open Access table with ADO or BDE/ODBC

Doug Stephens wrote:



How do I determine version of Jet? or MDAC? or repair the MDAC?

JET is included in MDAC. For more information on MDAC and JET

http://msdn.microsoft.com/data/ref/mdac/

to check MDAC

http://msdn.microsoft.com/data/ref/mdac/downloads/default.aspx


to repair MDAC

http://www.macropool.com/en/download/mdac_xp_sp2.html


Connection String=Provider=MSDASQL.1;Persist Security Info=False;Data
Source=TMS_ACCESS

Where TMS_ACCESS is an ODBC dns mapped to a local .mdb file.

using ADO+ODBC is not a good idea since you are using an extra layer to
get to Access, i.e., it's slower.

The best option is to use MS JET 4.0, which is the native OLE DB
provider for Access. After (or before if you wish) checking the MDAC
installation try with one of these connection strings, the one that
fits your needs better.

Standard security:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"


Workgroup (system database):

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDB:System Database=system.mdw;"


With password:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDB:Database Password=MyDbPassword;"


Good luck
--
Best regards :)

Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: Microsoft and trust
    ... Jet was separated from MDAC because MDAC components were not required ... Jet has been in the MDAC packages for many versions. ... When the MDAC package first appeared it was part of Microsoft's ... If I had to decide to move part of a package into a separate package, ...
    (microsoft.public.vb.general.discussion)
  • Re: Microsoft and trust
    ... Jet was separated from MDAC because MDAC components were not required by ... Jet has been in the MDAC packages for many versions. ... The Jet parts were always minor in size compared to the total size of the package. ... I would have told the reasons, what the consequences were, that there is a separate package, describe it, put a link to it and so on. ...
    (microsoft.public.vb.general.discussion)
  • Re: Will Jet 4.0 connection strings work on XP?
    ... Yes Jet has been removed from the latest 'n greatest MDAC_TYP packages. ... I think there might be some confusion about what the MDAC is. ... You can install newer MDAC packages as they become available. ...
    (microsoft.public.vb.database.ado)
  • Re: VB6 / Microsoft Jet Database and 64-Bit Windows Vista
    ... I found out today that Microsoft does not support the Microsoft Jet ... Microsoft killing support for VB6 on Vista? ... You can't install MDAC on Vista. ...
    (microsoft.public.vb.general.discussion)
  • Re: Run time error 3706 Provider cannot be found. It may not be properly installed
    ... I have a few questions regarding reinstalling SP2: ... Jet is no longer released with MDAC since Version ... This error is similar to following KB which describes a situation that Jet ... install MDAC 2.5 SP2, and then upgrade to the latest Jet components. ...
    (microsoft.public.data.oledb)