VBA equivalent for the Convert to 97 format (XP SP2)

Topic

New Reply

Can anyone tell me what the RunCommand equivalent of the menu “Convert Database To 97 Format” and “Convert Database To 2000 Format” is please

Reply | Quote

Replies

It takes a bit of fiddling, but if you search Access VBA Help for “ConvertAccessProject” it should give you the story. This is the example from it:

Application.ConvertAccessProject _
SourceFilename:=”C:My DocumentsSales-Access97.mdb”, _
DestinationFilename:=”C:My DocumentsSales-Access2000.mdb”, _
DestinationFileFormat:=acFileFormatAccess2000

Reply | Quote

You’re a star Wendell
I’d not thought that ConvertProject would work on databases, I’d assumed it was ADP’s

Can you help on my next question, how to convert to an MDE file
I’ve found the acCmdMakeMdeFile but can’t seem to pass in parameters
– by the way is there any way to do a word search on the Access XP Help, rather than use the index .

Many many thanks

Reply | Quote

Well, Help doesn’t help much with the DoCmd.RunCommand acCmdMakeMdeFile command. It appears you have to trick it to get it to work – a search of the MS knowledge base turned up article 202039 which uses SendKeys to generate the path and filename. A bit ugly – it looks like nobody has looked at this issue since Access 2000.

As to Access XP Help, it frequently isn’t. You can do searches using the assistant, or you can use the “Answer Wizard” but neither will find the acCmdMakeMdeFile. Help has deteriorated significantly from what was available in Access 97.

Reply | Quote

Wendell,

thanks for trying – glad it wasn’t just me finding the Help, a bit of a non-Help. I’m going to a Microsoft UK focus group on “Access” next month, so I’ll certainly try and bring it up the lack of Help issue

Poking around on the net found this on Google Groups

> But just to automate the process further I'd like to automatically 
> create the MDE when done.  But I haven't found any method of doing so.
Totally unsupported, undocumented, and prone to strange issues, but try:
    SysCmd 603,  , 
where  is the fully qualified path and name of the source database, 
and  is the fully qualified path and name of the mde you want created, 
such as:
    SysCmd 603, "c:myapp.mdb", "c:test.mde"
-- 
Dan Haught
FMS Inc. http://www.fmsinc.com

But while it works in Access 97, doesn’t seem to work in either Access 2000 or 2002
so I think it’ll have to be the SendKeys option, unless anyone knows the equivalent in 2000 and 2002

Reply | Quote

Check this page, http://home.clara.net/tkwickenden/codeex/7.htm%5B/url%5D out.

Reply | Quote

Wendell,

tried this with partially success.
The 2002 to 2000 conversion worked fine
The 2002 to 97 conversion didn’t
– something weird happended to the forms, I could see them in the Forms tab, but couldn’t open them in either Design or Normal mode !!

If it do the process manually, i.e. using the menu options, both 2000 and 97 versions are fine.

I’ve tried using VBScript, using SendKeys with some success, but better is a freeware application, called AutoIt. This has excellent control of “Windows”, so e.g. it can wait until a specific Window is available, like a Open dialog. This avoids problems I was finding with VBScript where an unexpected window messed up the sequence

Reply | Quote