Re: Error created linked tables from one .mdb to another .mdb


"Dale" <dale0610@xxxxxxxxxxx> wrote in message
news:OLM072CTFHA.3620@xxxxxxxxxxxxxxxxxxxxxxx

> Hi, this is sorta related to a thread I created earlier about using the
> Access.Application object to relink tables. Jeff suggested I use the
> DAO.Database object instead. I googled some example code that I modified
> a little and testing it right now. It works fine and creates the linked
> tables to SQL Server tables in my .mdb file. However, there are also
> linked tables to another Access .mdb as well. I thought if I just change
> the strConnect parameter to connect to the other .mdb file that it would
> link properly but it fails with this messagebox message popping up:
>
> "Error # 3170 was generated by DAO.TableDef
> Could not find installable ISAM."
>
> This is the value I am passing for strConnect:
>
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=\\Backoffice_demo\C\ServerDB\POSBdat.mdb;"

Sounds like you may need to install the Jet OLE DB provider on the target
machine. This is no longer part of MDAC and must be installed separately.
You can probably find it starting here: www.microsoft.com/data.


.

Relevant Pages

  • Re: VB.NET Deployment - Checking for user-modified files
    ... I think your MDB file would be an unversioned file and so: ... Create date for the file on the computer, do not install the file because ... > the installation problem with preferences by using a text file for ... properties and set to not overwrite. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Method ~ of object ~ failed error while opening ADODB connection in vb6
    ... the MDAC or Jet installation is "corrupt" (anything from incorrect ... if using Vista - you can't install the MDAC as it already comes ... ActiveX Data Objects 2.7 library", ... Perhaps the mdb file is corrupt. ...
    (microsoft.public.vb.database)
  • Re: MDE
    ... Well, if you need word, or excel...you install word or excel. ... the code and design parts of the application (the application part is the ... or mde file..you need some ... person a 2002 version of the mdb file. ...
    (microsoft.public.access.formscoding)
  • Re: How to get table names from ms access(mdb file) by using odbc library.
    ... engine installed by default (thus you don't need to install anything on a ... windows computer to read mdb files. ... Set dbeng = CreateObject ... So there is a table collection available after you open the mdb file as per ...
    (comp.databases.ms-access)
Loading