Hi,
I have just created an application in VBA using an MS access database (mdb) as it's base. The application is simple in that it has a form which loads at the beginning, imports data from an external MDB file and stores it within the applications database. It then manipulates the data in various ways for the user.
The problem i'm having is that MS Access will not let me convert it into an MDE file.
It either crashes and brings up the error msg or simply crashes and does nothing.
I have added several libraries into my app, namely the MS Office object library 10.0. This allows me to bring up dialog box with limited coding but even without this code the MDE conversion does not work.
The MDE conversion freezes and brings up the NOT RESPONDING error and then when i check the folder, it has created a new mdb file but when you run it, it brings up an error saying 'FILE NOT FOUND' and 'VISUAL BASIC FOR APPLICATIONS IS CORRUPT'. There isn't any file it should be looking for but it doesn't even create the right file type (MDE).
I really need to convert this MDB file with VBA programming into a stand-alone app. I have tried the MDE conversion on both Office XP(2002) and Office 2000 but both have the same result.
Can anyone shed any light on my problem?
Also, can anyone tell me if an MDE file is a completely stand-alone file which would work even without MS office being installed on a system?
Please let me know any thoughts or ideas you may have.
Thank you.
Shuja.
hardware
prices 
