Programming Question

M

Metalteck

I currently have a database with an mde extension. I'm trying make some
modifications to it, but it seems that the person who wrote the program
completely locked it up. I also tried creating a blank database and importing
the files, but I get many errors when I'm importing the forms and reports.
Something about missing vb10 temp files. Can someone point me in the right
direction as how to proceed.
 
R

Rick Brandt

Metalteck said:
I currently have a database with an mde extension. I'm trying make
some modifications to it, but it seems that the person who wrote the
program completely locked it up. I also tried creating a blank
database and importing the files, but I get many errors when I'm
importing the forms and reports. Something about missing vb10 temp
files. Can someone point me in the right direction as how to proceed.
Click to expand...

You cannot make design changes in an MDE except to tables, queries, and
macros. Locking the code-based objects is one of the reason to use an MDE
in the first place.

You need a copy of the MDB file that was used to create the MDE. You make
your design changes to that file and then use it to create a new MDE file
that you distribute for use.
 
W

Wayne Morgan

An mde file is a locked version of an mdb file. All of the text code has
been removed. You can copy the table and queries from the mde file, but
that's about it. To make changes you need to have the original mdb file.
After you make the changes, you would then create a new mde file, if
desired.
 
M

Metalteck

Regarding the copying of the MDB file.
The when you click on the MDB file to make the changes, it defaults to a
switchboard.
And if I create a blank database and try to import all the tables, queries,
forms and reports, I get the same vb temp errors.

Is there a way I can adjust a setting so that when I click on the mdb file,
it opens like a regular db and not a switchboard?
 
W

Wayne Morgan

First, I just want to make sure that this is the original MDB file, not just
the MDE file renamed with an MDB extension.

Now, to get to what I thing you're after. Try holding down the Shift key as
you open the database. This should bypass the startup options, however it is
possible to lock-out this bypass. Another option once you're in the
database, try pressing the F11 key to see if the database window will open.
It is more likely that this second option will be locked out than the first
option. If both are locked-out, then there should be a "back door" into it,
but you'll probably need to ask the person who created the file where it is.
Without that, you'll need to import the objects from the mdb file into a new
file and work with the new file.
 
Top