MDE problem

[Lilian]

Hi,

I tryied to create mde file for my Microsoft Access database 2003 but
compiling failed "error message the database is to large". I did compact and
repair didn't help. Do somebody knows what to do in such situation?

Best regards,
Lilian

 

[Gina Whipp]

Lilian,

What size is your database? You ight also have some coding issues, such as
variables not declared. Go to Design View of any Form or Report and then to
the Code/Module window. Once there if you do not see Option Explicit at the
top along with Option Compare Database you will want to add that to every
Form or Report that has code and then run Debug... Compile... and fix and
errors that surface and try again.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Lilian]

It-s not too large 5972 kB

"Gina Whipp" skrev:

Lilian,

What size is your database? You ight also have some coding issues, such as
variables not declared. Go to Design View of any Form or Report and then to
the Code/Module window. Once there if you do not see Option Explicit at the
top along with Option Compare Database you will want to add that to every
Form or Report that has code and then run Debug... Compile... and fix and
errors that surface and try again.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Lilian,

You're right not too large. Have you finished doing the other item I
suggested? If so what were the results?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dale Fye]

The other thing I would recommend is to create a new mdb file and import
everything from the old into the new.

This will get rid of all of the excess and deleted objects that are just
hanging around in your old database. Then, recompile your app and try to
convert to the mde.

Dale

 

[Lilian]

I tryed to make mde format in other version and efter when I was trying to
logga in to database via authentication with password ad username that I made
myself in VBA. It was blocked i couldn't logga in to the database. The
activation -enable database content disappeared i tryied in the trusted
center nothing help how to activate makro and vba?

"Gina Whipp" skrev:

 

[Gina Whipp]

Have you tried the suggestions I posted? If so what are/were the results?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm