By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

comp.databases.ms-access: 2002 file format problem

P: n/a
Hi Experts,

Could you please help me on how to get access 2002 file format exactly
while doing conversion from Access 97 file format by
DBEngine.CompactDatabase() function?

Code:

Private Sub Command1_Click()
DBEngine.CompactDatabase "c:\ss97.mdb", "c:\ss2002.mdb",
dbLangGeneral, dbVersion40, dbLangGeneral
End Sub

This is my conversion code. What's my problem means?
The database has created succesfully but not an exact file format
(2002) of access . By default its generating access 2000 file format
mdb file.

Constants for file format:
dbVersion10 for Engine version 1.0 file format while compacting.
dbVersion11 for Engine version 1.1 file format...
dbVersion20 for Engine version 2.0 file format...
dbVersion30 for Engine version 3.0 file format (compatible with
version 3.5)...
dbVersion40 for Engine version 4.0 file format...

Is there any other constant for geting access 2002 file format
exactly?

Advance Thanks!

Regards,
-Karthik.
Email: ka*******@gmail.com

Mar 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You could use the ConvertAccessProject method

Here is a link to the code example on Microsoft site
http://support.microsoft.com/default...;en-us;Q304318
<ka*******@gmail.comwrote in message
news:11**********************@p15g2000hsd.googlegr oups.com...
Hi Experts,

Could you please help me on how to get access 2002 file format exactly
while doing conversion from Access 97 file format by
DBEngine.CompactDatabase() function?

Code:

Private Sub Command1_Click()
DBEngine.CompactDatabase "c:\ss97.mdb", "c:\ss2002.mdb",
dbLangGeneral, dbVersion40, dbLangGeneral
End Sub

This is my conversion code. What's my problem means?
The database has created succesfully but not an exact file format
(2002) of access . By default its generating access 2000 file format
mdb file.

Constants for file format:
dbVersion10 for Engine version 1.0 file format while compacting.
dbVersion11 for Engine version 1.1 file format...
dbVersion20 for Engine version 2.0 file format...
dbVersion30 for Engine version 3.0 file format (compatible with
version 3.5)...
dbVersion40 for Engine version 4.0 file format...

Is there any other constant for geting access 2002 file format
exactly?

Advance Thanks!

Regards,
-Karthik.
Email: ka*******@gmail.com

Mar 16 '07 #2

P: n/a
Hi tombsy,

Great! Thank you so much for your help!

Regards,
-Karthik.

Mar 22 '07 #3

P: n/a
Hi Tombsy,

I used ur ConvertAccessProject method. This is working fine but it
requires "Microsoft Access 10.0 Object Library" reference in VB 6.0.
If office XP is not installed i mean access is not installed then the
vb 6.0 shows error like "ActiveX object cann't be created".

Without access how can we use this method to convert? or any dll
reference is needed?

Please help me.............................

Any help would be appriciated....

Thanks in Advance!!!!!!!!!!!!!!!!!!!!!

Regards,
-Karthik.

Mar 23 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.