Compatibility Layer+VB3+Access2 problems 
Author Message
 Compatibility Layer+VB3+Access2 problems

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?


Sat, 30 Aug 1997 08:30:56 GMT  
 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.



Sun, 31 Aug 1997 10:35:17 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Compatibility layer Access2 - VB3

2. Help! VB3.0 - MS-Access2.0 copatibility layer

3. Access 2- VB3 Compatibility Layer

4. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

5. VB3 to MS Access 2 - Where's the Compatibility Layer

6. VB3 Compatibility Layer

7. VB3 Access 2 - Compatibility Layer

8. VB3.0, Access 1.1, Compatibility Layer, Compact Statement

9. VB3 + Access2 problem

10. VB3/Access2 - copyDB problem

11. VB3 and Access2.0 Permission Problems

12. Problem with Access97/Access2 and VB3

 

 
Powered by phpBB® Forum Software