roblems with MDE file :(

Hello!

I'm trying to make MDE file for my program. It doesn't work
I tried everything!
I converted it to 2002, I debugged it, I restarted the computer, nothing
helps.
I don't even get an error message. It starts making the MDE file and then
after a few minutes the program doesn't respond.

How can I make the MDE file???


Thanks,
Yonina.

Hi Yonina,

Try the suggestions found he

Cannot make .MDE
http://www.access.qbuilt.com/html/co...#CannotMakeMDE


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"קובץ" wrote:

Hello!

I'm trying to make MDE file for my program. It doesn't work
I tried everything!
I converted it to 2002, I debugged it, I restarted the computer, nothing
helps.
I don't even get an error message. It starts making the MDE file and then
after a few minutes the program doesn't respond.

How can I make the MDE file???


Thanks,
Yonina.

Thank you, but I already went through the list and didn't find a reason why
it can't make MDE.




"Tom Wickerath" wrote:

Hi Yonina,

Try the suggestions found he

Cannot make .MDE
http://www.access.qbuilt.com/html/co...#CannotMakeMDE


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"קובץ" wrote:

Hello!

I'm trying to make MDE file for my program. It doesn't work
I tried everything!
I converted it to 2002, I debugged it, I restarted the computer, nothing
helps.
I don't even get an error message. It starts making the MDE file and then
after a few minutes the program doesn't respond.

How can I make the MDE file???


Thanks,
Yonina.

I assme that the instructions referenced by Tom, include the suggestion
to decompile the database? If not, google on "/decompile", for more
information.

One rare but possible cause of being unable to create an MDE fiel, is,
using methods of the dbengine object without including the dbengine
keyword explicitly. For example, OpenDatabase instead of
DbEngine.OpenDatabase. See if you have any of those.

HTH,
TC

I don't think I have any of those methods in my program.
I usually make MDE and it works. I only added a few lines, and it stopped
working. So I took out the lines I added, but it didn't help


"TC" wrote:

I assme that the instructions referenced by Tom, include the suggestion
to decompile the database? If not, google on "/decompile", for more
information.

One rare but possible cause of being unable to create an MDE fiel, is,
using methods of the dbengine object without including the dbengine
keyword explicitly. For example, OpenDatabase instead of
DbEngine.OpenDatabase. See if you have any of those.

HTH,
TC

קובץ wrote:

I don't think I have any of those methods in my program.

Do you /know/? Have you /checked/?

TC

I know I don't have. (I checked)

"TC" wrote:


קובץ wrote:

I don't think I have any of those methods in my program.

Do you /know/? Have you /checked/?

TC

Hi Yonina,

Your code compiles okay without any errors, right? To verify, open any code
module. Then click on Debug Compile ProjectName.

Create a brand new database and immediately disable the NameAutocorrupt
feature (see: http://allenbrowne.com/bug-03.html for reasons why you want to
do this). Then import all objects from the suspect database into the new
database, one group at a time, into your new database. In other words, import
all tables (but not linked tables), then import all queries, then all forms,
etc. While Access will allow you to import all objects in one operation, the
experts at FMS, Inc. (a Microsoft Partner), have stated that it is best to
import objects one group at a time (Reference:
http://www.fmsinc.com/ubb/Forum12/HTML/000285.html).

Recreate any linked tables from scratch. Access can cache a lot of
information about linked tables, which may no longer be valid, so it's always
best to recreate the linked tables from scratch. When importing local tables,
make sure to check the option to import relationships, menus and toolbars,
and import/export specs. If any of the local tables in the source DB are
hidden, you'll need to first unhide them. You will need to set the checked
references to match the source database, along with any startup options set
under Tools Startup. Going through this process often times solves
corruption problems, because you get a new set of the hidden system tables
(the tables whose names start with "MSYS"). These system tables are updated
appropriately as you import objects.

This may sound like a lot of work, but it really isn't. Creating a new
container DB, disabling NameAutocorrect, importing all objects one group at a
time, re-establishing any linked tables, setting startup options, and setting
references to match the source DB is usually a fairly quick procedure. When
you are in the Visual Basic Editor, in order to check that the references
match the source DB, you should do a Debug Compile ProjectName as well.

Good Luck,

Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"קובץ" wrote:

Thank you, but I already went through the list and didn't find a reason why
it can't make MDE.


__________________________________________

"Tom Wickerath" wrote:

Hi Yonina,

Try the suggestions found he

Cannot make .MDE
http://www.access.qbuilt.com/html/co...#CannotMakeMDE


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"קובץ" wrote:

Hello!

I'm trying to make MDE file for my program. It doesn't work
I tried everything!
I converted it to 2002, I debugged it, I restarted the computer, nothing
helps.
I don't even get an error message. It starts making the MDE file and then
after a few minutes the program doesn't respond.

How can I make the MDE file???


Thanks,
Yonina.

I tried, but it didnwt help.
Thank you everyone who tried to help me.
I took an older version of my program that works, made MDE, and now trying
to reconstruct the code I added...

:|

"Tom Wickerath" wrote:

Hi Yonina,

Your code compiles okay without any errors, right? To verify, open any code
module. Then click on Debug Compile ProjectName.

Create a brand new database and immediately disable the NameAutocorrupt
feature (see: http://allenbrowne.com/bug-03.html for reasons why you want to
do this). Then import all objects from the suspect database into the new
database, one group at a time, into your new database. In other words, import
all tables (but not linked tables), then import all queries, then all forms,
etc. While Access will allow you to import all objects in one operation, the
experts at FMS, Inc. (a Microsoft Partner), have stated that it is best to
import objects one group at a time (Reference:
http://www.fmsinc.com/ubb/Forum12/HTML/000285.html).

Recreate any linked tables from scratch. Access can cache a lot of
information about linked tables, which may no longer be valid, so it's always
best to recreate the linked tables from scratch. When importing local tables,
make sure to check the option to import relationships, menus and toolbars,
and import/export specs. If any of the local tables in the source DB are
hidden, you'll need to first unhide them. You will need to set the checked
references to match the source database, along with any startup options set
under Tools Startup. Going through this process often times solves
corruption problems, because you get a new set of the hidden system tables
(the tables whose names start with "MSYS"). These system tables are updated
appropriately as you import objects.

This may sound like a lot of work, but it really isn't. Creating a new
container DB, disabling NameAutocorrect, importing all objects one group at a
time, re-establishing any linked tables, setting startup options, and setting
references to match the source DB is usually a fairly quick procedure. When
you are in the Visual Basic Editor, in order to check that the references
match the source DB, you should do a Debug Compile ProjectName as well.

Good Luck,

Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"קובץ" wrote:

Thank you, but I already went through the list and didn't find a reason why
it can't make MDE.


__________________________________________

"Tom Wickerath" wrote:

Hi Yonina,

Try the suggestions found he

Cannot make .MDE
http://www.access.qbuilt.com/html/co...#CannotMakeMDE


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"קובץ" wrote:

Hello!

I'm trying to make MDE file for my program. It doesn't work
I tried everything!
I converted it to 2002, I debugged it, I restarted the computer, nothing
helps.
I don't even get an error message. It starts making the MDE file and then
after a few minutes the program doesn't respond.

How can I make the MDE file???


Thanks,
Yonina.