Access 95 to Access 2000

Access 95 to Access 2000

Post by Michael Schnel » Thu, 01 Jul 1999 04:00:00



All,

    We are currently using Access 95 databases to store data with VB5
front-ends.  We connect using both ADO and DAO to the databases accross the
network.

    My question is:  Would the programs that currently hit the Access 95
databases need to be changed if we convert from A95 to A2K.

                            Thanks

 
 
 

Access 95 to Access 2000

Post by Andrew Grillag » Thu, 01 Jul 1999 04:00:00


Yes, but the change may be as simple as setting a reference to a new DAO 3.6
library and a new OLE DB provider (if you were using 3.51)

Hope this helps

Andrew Grillage, MCP
____________________


Quote:> All,

>     We are currently using Access 95 databases to store data with VB5
> front-ends.  We connect using both ADO and DAO to the databases accross
the
> network.

>     My question is:  Would the programs that currently hit the Access 95
> databases need to be changed if we convert from A95 to A2K.

>                             Thanks


 
 
 

1. Conversion Access 95 to Access 2000

Trying to fix "Type mismatch" error while conversion Access 95 to
Access 2000.  Performed suggested fixes:

- DAO library added in References
- ADO library removed
- "as Database" and "as Recordset" changed to include "DAO." reference
- initialization of strings changed from "= NULL" to "= VbNullString"

"Type mismatch" error still appears. What else to check or change?
Please, suggest!

Regards,
Krustpils

2. D3 WIN95

3. Access 95 - Access 2000

4. NEEDED: Paradox386 4.5 for DOS (32bit)

5. An access 95 program doesn't work on access 2000

6. PopUpMenu in script

7. How to convert a Access 95 program to Access 2000 program

8. Chicago Consulting -- Sample Projects

9. Delphi components for MS Access 95/97/2000

10. Problem with MS Access Runtime 95 AFter Upgrade to SQL Server 2000 (from SQL 7.0)

11. Big security problem in ACCESS 2.0/95/97/2000

12. Win 95 ODBC to Access 2000 Database

13. Windows 95 and Access 2000