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


"Doug Stephens" <dougstephens@xxxxxxxxxx> ???????/???????? ? ????????
?????????: news:446c7eb9@xxxxxxxxxxxxxxxxxxxxxxxxx
could you show us your connection string? What version of JET are you
using to connect via ADO? Have you checked the MDAC version or
repaired it?


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

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.
Switch to Microsoft Jet 4.0 Ole DB provider (native for Access).


.

Relevant Pages

  • Re: Distributing MDAC with VB Application
    ... using both DAO and ADO in your project is to be SURE to qualify object names ... > Is there something else I need to include if using MDAC 2.5 or higher? ... include the Jet components ADO requires. ... you might have to distribute the Jet Components installer. ...
    (microsoft.public.vb.winapi)
  • Re: ADO and Jet creates error on XP Home Edition SP2
    ... For the JET error you mentioned, please take a look at the KB article at ... it appears to me the issues you are having is not really with ADO ... > database file with ADO: ... >> MDAC 28 RTM won't install. ...
    (microsoft.public.data.ado)
  • Re: How to repair MDAC in XP SP2?
    ... how to repair a copy of MDAC 2.8 on WinXP with SP2 installed ... > ADO is involved. ... > since my primary app is Access, ...
    (microsoft.public.data.ado)
  • Re: DAO360.DLL - can I redistribute it?
    ... Older versions of MDAC include Jet 4.0...the newer ones do not. ... PC...whether or not you use ADO. ... schema used is common among the various database you might connect to. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: ADO and Jet creates error on XP Home Edition SP2
    ... call Jet to compact access 97 files. ... database file with ADO: ... > MDAC 28 RTM won't install. ...
    (microsoft.public.data.ado)