Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database conversion

Status
Not open for further replies.

jasilo

Technical User
Jun 24, 2003
4
US
Hello all,
I will clarify my question from the 24th.

I have a client that uses Access 97 and I use Access 2000. I have written some code to create a database, copy information, zip it and email it. I am aware that the "convert database to a lower version" option is available manually, but I would like to know if there is some VB or VBA that will automate the process.

Any help would be greatly appreciated.

Thanks,
Jasilo
 
You only need to set the macro recorder and record the File/Save As ... code that is produced.



Regards
BrianB
** Let us know if you get something that works !
================================
 
Sorry,. lost you there.
Should I use the help menu for Saving? Or would you happen to have a script I could fromat.

Thanks,
 
Bry - there is no macro recorder in Access

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244
 
<<Bry - there is no macro recorder in Access >>

Ooops. sorry.


Regards
BrianB
** Let us know if you get something that works !
================================
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top