problem with MDE

[mazza]

I have a access database with a number of back ends. This database is distributed to various users around the world in a Access Runtime package and use running access runtime. Although tables are in a default folder it is possible to move the locations and automatically relink the front end to a new back end locations using VBA and the brower functions. It deletes existing linked tables and relinks.

Now if I create a MDE of the front end, I am unable to relink in using the run time, it also throws some issues with coding when I am using access runtime.

Is there a known issue here using MDE & Access Runtime?

 

[gemma-the-husky]

there should not be any problem with an mde

you may just be getting an unhandled error

eg - no such path
- or selected path not a readable database
- or not a database at all
- expected table not found in be database

etc etc

 

[mazza]

runs fine before the onversion to mde,

not sure if the combination of runtime & mde has something to do with it as the code does delete tables and recreates/relinks it..

will try it again