Re: VB app &mdb files without MS Access

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

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 08/05/04 

Date: Thu, 05 Aug 2004 11:43:34 -0500

On Thu, 5 Aug 2004 07:40:25 -0700, "Pete" <anonymous@discussions.microsoft.com> wrote:

¤ Hi,
¤ I wished to develop a vb6.0 app to connect to an access
¤ db (.mdb file).
¤ Could someone please give me an overview with the
¤ following in mind:-
¤ Can I install the Access driver onto a non-Access ready
¤ PC and still connect to the mdb file (therefore negating
¤ the need for an Access license)?
¤ If so, which is the driver file and how is it installed
¤ during installation (setup)?
¤ I wish to use ADO to make the connection, so what will be
¤ the additional files to install for this and the
¤ connection string etc (would MDAC need to be installed
¤ etc)?
¤
¤ Target systems may include Win 95.
¤
¤ If this query was previously answered, could you please
¤ supply details to locate it.

You would need Jet and MDAC:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
http://support.microsoft.com/default.aspx?scid=fh;en-us;mdac

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

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: 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)
  • 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: Error created linked tables from one .mdb to another .mdb
    ... > tables to SQL Server tables in my .mdb file. ... > the strConnect parameter to connect to the other .mdb file that it would ... > link properly but it fails with this messagebox message popping up: ... Sounds like you may need to install the Jet OLE DB provider on the target ...
    (microsoft.public.vb.general.discussion)