MDE dabase convert error

[Souris]

I got Microsoft was Access unable to create an MDE database error.

It mentioned that it is usaully associated with compiling a large database.
All tables are links tables. There is no local tables in the MDB file.
There are 27 links tables
25 queries
21 forms
4 reprots
1 macro
and 3 VBA modules

The size for 2003 format MDB is 2272K.

Is it too big to compile to MDE?
Are there any worklaround?
Any place I can check?
Your help is great appreciated,

 

[Gary Dolliver]

Hi there,
I have had a similar experience and found if I ran a compile in the mdb
file, it would find something in the vba, usually an if statement without a
closing, or something similar. Try going into a form in design mode, then go
into your vba editor and click on Debug > compile - it will then usually come
up with an error and show you the line of code that is causing the issue.
Also, I would back up before trying, just in case. hope that helps!
-gary

 

[Souris]

Thanks millions,
Yes, It missed a end if block.

Hi there,
I have had a similar experience and found if I ran a compile in the mdb
file, it would find something in the vba, usually an if statement without a
closing, or something similar. Try going into a form in design mode, then go
into your vba editor and click on Debug > compile - it will then usually come
up with an error and show you the line of code that is causing the issue.
Also, I would back up before trying, just in case. hope that helps!
-gary

 

[Gary Dolliver]

awesome! please make sure to mark this issue as resolved, thanks!
-gary