How to create an Access 2002 or 2003 mdb file with VB6?

[WayneM]

Is it possible to create an access mdb file with a 2002 or 2003 file format?
I use DAo 3.6, but it creates an Access 97 file type?

Thanks in advance,

WayneM

[Veign]

You can use ADOX.

http://www.veign.com/vrc_codeview.asp?type=app&id=108
-- or --
http://www.veign.com/vrc_codeview.asp?type=app&id=22

Then use the Jet OLEDB:Engine Type property in the connection string to
control the version created.

Jet OLEDB:Engine Type=5 == Access 2000 format

Others:

'Jet OLEDB:Engine Type Jet x.x Format MDB Files
'********************* ************************
' 1 JET10
' 2 JET11
' 3 JET2X
' 4 JET3X
' 5 JET4X

From MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrcreatingmodifyingaccesstables.asp
--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog
--

Post by WayneM
Is it possible to create an access mdb file with a 2002 or 2003 file format?
I use DAo 3.6, but it creates an Access 97 file type?
Thanks in advance,
WayneM