OPening an MDE on a Win2K machine?

[BlueMan]

I created an Access database in Access2K on a Win2K machine. Compiled it
to an MDB which works fine on said Win2K machine and other Win2K
machines, whether or not Access is installed.

I go to open it on a WinXP machine, and it doesn't recognize the file
extention.

Isn't the point of compiling it so it will open on any machine, even one
without Access? Why am I not surprised that one Microsoft product
doesn't even recognize another Microsoft product?

Anyway, how do I get the XP machine to recognize it? And upgrading to
OfficeXP isn't even an option, so don't suggest it.

Any help would be most appreciated.

 

[Van T. Dinh]

Sorry, no. Compiling an MDB file to an MDE file does not create an
executable. Both MDB and MDE files _need_ Access to open & run.

The W2K that you thought doesn't have Access but could open the database
will have MSAccess.exe if you search the file structure. This could be
either a full-install of Access or an run-time install of Access that might
have been created by another database application.

 

[Van T. Dinh]

Sorry, no (as I wrote in the previous post).

 

[Douglas J. Steele]

Nope. There's no way to create an executable from an Access database.

I'm not sure that the refererence you cite is all that you need: I scanned
it briefly, and I don't believe it explicitly mentioned that you need to
purchase the Developer edition of Access (or Visual Studio Tools for
Microsoft Office if you're dealing with Access 2003) in order to be able to
distribute the royalty-free run-time version of Access.

You might take a look at what Tony Toews has at
http://www.granite.ab.ca/access/developereditionfaq.htm