Runtime Switch for MDE on network drive

[BukHix]

I am looking for a way to load a MDE from a Visual Basic .Net application. The MDE is an Access 2000 version and all the clients on my network are using Access 97.

From this thread I found out that you can use a run time switch to overcome the version problem, however I am not sure how to set it for a MDE on a networked drive.

My .Net code looks like this:

       Dim strMdeName As String = "\\Server\RTEA\database.mde"
        Process.Start(strMdeName)

As is, when a client tries to open the MDE their version of Access 97 tries to open it but ends with the wrong version error.

Is it possible to use the switch for a MDE on a network drive?

 

[ghudson]

You are confusing two different issues. You need the Office Developers Edition for your version of Access to install a [royalty free] RunTime version of Access on another PC. Using the /runtime switch will produce an error if the runtime files are not installed on that PC. Your db should be error free and all of your subs and functions should have proper error handling or else the db will shut down if an unexpected runtime error occurs.

Converting an Access application to a MDE only compiles the code and prevents any design changes to the forms, modules and tables. Users can still open the tables and modify queries & macros of a MDE db.

It might be easier for you if you convert your db to Access 97 for your users.

 

[BukHix]

ghudson thank you for the clarification.