
Compatibility Layer+VB3+Access2 problems
Quote:
>I am a novice VB user trying to use VB to control an Access 2.0
>database. I own both VB3 and Access2 and I recently downloaded
>COMLYR.EXE from ftp.microsoft.com/softlib/mslfiles. It seems
>that all the necessary DLL's have been replaced or added
>(including MSAJT200.DLL); however, I am still getting an "incompatible
>database version" message upon trying connect to an Access 2.0
>database (the error occurs when I try selecting a recordsource
>for a data control in VB.) Am I leaving something out? Am I
>missing something important? Will I graduate?
Access
Visual Basic Advisor Dec./Jan. issue has a great article on
using VB3 and Access2. You must update VB.INI and the .INI that you
send with your VB app. In the both .INI files modify the [Installable
ISAM] and [Paradox ISAM] sections like this:
[Installable ISAM]
Paradox 3.X=C:\VB\PDX200.DLL ;Path of the Paradox 3.x driver
Paradox 4.X=C:\VB\PDX200.DLL ;Path of the Paradox 4.x driver
FoxPro 2.0=C:\VB\XBS200.DLL ;Path of the Microsoft FoxPro 2.0 driver
FoxPro 2.5=C:\VB\XBS200.DLL ;Path of the Microsoft FoxPro 2.5 driver
dBase III=C:\VB\XBS200.DLL ;Path of the dBase III driver
dBase IV=C:\VB\XBS200.DLL ;Path of the dBase IV driver
Btrieve=C:\VB\BTRV200.DLL ;Path of the Btrieve driver
If you use attached Paradox tables, add this to your .INI files:
[Paradox ISAM]
ParadoxNetStyle=3.x ;Required to open Paradox databases
In the SETUPWIZ.INI file, make these changes:
[ACCESS] ; Key used by Setup Wizard
; Jet database engine files
file1=MSABC110.DLL
file2=MSAJT200.DLL
file3=VBDB300.DLL
file4=SHARE.EXE:1 ; Jet database engine DLLs require 'SHARE.EXE /L:500
; in autoexec.bat
file5=MSAJT112.DLL
If using Crystal Reports, read ACC2COMP.TXT file for instructions to
upgrade Crystal Reports to run with Access 2.0 .mdb files.
Hope this helps. More info in the article.