Board index » delphi » Function to determine if Access 97 or 2000 mdb file Format

Function to determine if Access 97 or 2000 mdb file Format

Has anyone got a function that will return which file access file type

Something like:
Function ReturnFileFormat(sMdbFile : string):String;//or maybe the
provider (OLE Jet 3.5 or 4.0)

Thanks,
Bill N
www.2rs.ca

 

Re:Function to determine if Access 97 or 2000 mdb file Format


Connect to .mdb file with Jet 4.0 provider - you will can connect to both
Access 2000 and Access 97 formats - and examine ADO connection properties -

Property                                    Sample value
DBMS Name                            MS Jet
DBMS Version                           04.00.0000
Provider Version                        04.00.5919
Jet OLEDB: Engine Type            5                    //Here 5 means Access
2000, 4 - Access 97, 3 - Jet 2, 2 - Jet 1.1, 1 - Jet 1

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Bill N" <ahappyfam...@sympatico.ca> ???????/???????? ? ???????? ?????????:
news:3EB3FAFF.9040409@sympatico.ca...

Quote
> Has anyone got a function that will return which file access file type

> Something like:
> Function ReturnFileFormat(sMdbFile : string):String;//or maybe the
> provider (OLE Jet 3.5 or 4.0)

> Thanks,
> Bill N
> www.2rs.ca

Other Threads