making an ADE

[David Batt]

Hello,
I have an access adp in Access 2002 in Access 2000
format. I have compiled all the code and it works. however
I wish to make an ade. The files are under sourcesafe
control but it is disconnected. When I go to Database
Utilities the Make ade menu option is greyed out. Why is
it greyed out, how do I enable it. Any help would be
greatly appreciated.

Regards
David

 

[Van T. Dinh]

You need to convert the MDB file to A2002 file format and then use the MDB
in A2002 file format to convert to an A2002 ADE.

If you need the ADE in A2000 file format, you need to use A2000 software to
convert your MDB (in A2000 file format) into A2000 ADE file.

 

[Lyle Fairfield]

You need to convert the MDB file to A2002 file format and then use the MDB
in A2002 file format to convert to an A2002 ADE.

If you need the ADE in A2000 file format, you need to use A2000 software to
convert your MDB (in A2000 file format) into A2000 ADE file.

You can make a 2K ADE or MDE in XP using code. You can run it in XP. But you
can't run it in 2K, because it will not, and as far as I know, cannot change
its references from XP to 2K.

 

[Van T. Dinh]

Lyle

Would you mind posting the code?

 

[Lyle Fairfield]

Lyle

Would you mind posting the code?

Public Sub CreateADE(ByVal ADPFullPath As String)
Dim a As Access.Application
Set a = New Access.Application
a.SysCmd 603, ADPFullPath, Replace(ADPFullPath, ".adp", ".ade")
Set a = Nothing
End Sub

Notes:

SysCmd 603 does not seem to run from the home or base application in
versions >=2K but it will run from a new instance of Access.

I use the full path; sometimes when the path is not included in full SysCmd
603 seems to do nothing.

As I said before, this ADE will run in XP in 2K file format, but it will
not run in 2K, as it has a reference to Office 10, and I have found no way
to change that reference.

 

[Van T. Dinh]

Thanks, Lyle

Cheers
Van