Re: VB6 Expert, DB (Access) Dumbshit (PAYBACK TIME FOLKS!!!)

On Thu, 09 Feb 2006 03:27:40 GMT, "G Doucet" <someone@xxxxxxxxxxxxxxx>
wrote:
figured that with VB5 I was stuck

with DAO 3.5 and thus my databases could not be used in Access 2003. I had also figured that anyone using VB6 would be limited to
mdb files that could only be used by Access 2001. Following that logic, I also assumed that you needed VB.Net to create databases
that could be recognized by Access 2003.

Is this true? Or is there a way for my VB5 apps to create the latest mdb files?

Hmng.. don't knwo about VB5, i use VB6 but let's see if this works on
that old dog too. ;-)

http://support.microsoft.com/kb/825796/

So, you have to grab the latest Jet and at least mdac 2.7 files from
MS.
You also need to have DAO3.6, which may have come with SP5(for VB6),
but im not sure, i may have had to download it.. check your project
references and see if you do have the "Microsoft Data Access Onjects
3.6" listed.

Here is the jet page : It has a link to the mdac page somewhere at the
bottom.
Look for MDAC_TYP.EXE and WindowsXP-KB829558-x86-ENU.exe (for XP of
course), or at least that is what i have.

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

--

Regards, Frank
.

Relevant Pages

  • Re: Fun and games instaling VB6 and MSDN!
    ... Would it make any sense to start up with a virgin machine, ... I can understand if you have codebase in VB5 that you wish to hang on to, ... Trying to download the MDAC 2.5 gave the message that I already had it! ... the box offering a choice of vb or vba. ...
    (microsoft.public.vb.general.discussion)
  • Re: How to create an Access 2002 or 2003 mdb file with VB6?
    ... 'Jet OLEDB:Engine Type Jet x.x Format MDB Files ... > Is it possible to create an access mdb file with a 2002 or 2003 file ...
    (microsoft.public.vb.database)
  • Re: "Access.LockFile.9" left behind after using the JDBC ODBC Brige
    ... Insufficient network permissions in the folders that ... contain the MDB files. ... The last user out of an Access (Jet) database ...
    (comp.lang.java.programmer)
  • Im not sure if Jet 4.0 is correctly installed
    ... I made a program with Visual C++ 6 and MFC that uses mdb files with Jet 4.0 ... fresh installs of Windows 2000 or XP where I never installed development ... I suppose that B lacks some part of DAO. ...
    (comp.databases.ms-access)