Can we convert .accdb to .mdb with only tables exported to .mdb

[PKJ]

Hi Everybody!

I am puzzling over to convert my Access-2007 database-tables (but not other objects) into Access-2000/Access-2003 database. Can somebody guide me!

regards,

P K Joshi

 

[vbaInet]

Hi Everybody!

I am puzzling over to convert my Access-2007 database-tables (but not other objects) into Access-2000/Access-2003 database. Can somebody guide me!

regards,

P K Joshi

You can SAVE AS an an older version, not convert.

 

[PKJ]

Thanks vbaInet,

I did save as MS Access-2000/2003 format but it saves all other objects like queries, forms etc. So what I have been doing is to delete all those undesired objects and then save in old format. Isn't there any direct method thru vba code.

regards,
-PK Joshi

 

[vbaInet]

No there isn't Joshi.

 

[PKJ]

Ok Fine friend!
I thought there must be some Access Object which we can use in code.
Anyway, Thanks for bailing out from the drudgery of futile search for this solution.
regards - PKJ

 

[gemma-the-husky]

split the database

then convert the database with the tables in it!

 

[vbaInet]

1. The code will call the SAVE AS operation
2. Delete all the OBJECTS except TABLES.

So you see it isn't really a prevailent issue. It is one to meet your specific needs which is why your search was futile. The normal process is to SAVE AS, then SPLIT.

 

[PKJ]

Yes! It was time saving.

vbaInet and gemma-the-husky,

I am glad and grateful for your prompt help. Your advice worked fine and saved time. Thanks a lot for your generousness.
regards to both. - PKJ

 

[vbaInet]

Glad you got that sorted.

 

[gemma-the-husky]

i supose if you have some users on A2003, and others on A2007, you need to keep the tables as A2003.