Can't create an MDE

[RICHARD BROMBERG]

I am using Access 2000 .

My program has about ten tables and about eighteen forms.
When I try to make an MDE I get a message saying "Microsoft Access was
unable to create an MDE database"

When I looked this up on Google I found a link to
http://support.microsoft.com/kb/202304/EN-US/ .

The article says The Microsoft Jet database engine version 4.0 allows a
maximum of 2048 open TableIDs at one time.

I have no idea why my modest program can't be saved as an MDE, but I don't
think the the above has anything to do with it.

Any suggestions would be welcome.

[Rick Brandt]

RICHARD BROMBERG wrote:

I am using Access 2000 .

My program has about ten tables and about eighteen forms.
When I try to make an MDE I get a message saying "Microsoft Access
was unable to create an MDE database"

When I looked this up on Google I found a link to
http://support.microsoft.com/kb/202304/EN-US/ .

The article says The Microsoft Jet database engine version 4.0 allows
a maximum of 2048 open TableIDs at one time.

I have no idea why my modest program can't be saved as an MDE, but I
don't think the the above has anything to do with it.

Any suggestions would be welcome.

Open the VBA code editor window and compile your project. Most likely you
have some bad code and that should show you where it is so you can fix it.
Once the project compiles without errors then you should be able to make an
MDE.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Keith Wilby]

"RICHARD BROMBERG" <no*****@att.netwrote in message
news:a%*********************@bgtnsc05-news.ops.worldnet.att.net...

>
I have no idea why my modest program can't be saved as an MDE, but I don't
think the the above has anything to do with it.

Any suggestions would be welcome.

Do you have any VBA code? If so, have you compiled it?

Keith.
www.keithwilby.com

[PBsoft]

Any suggestions would be welcome.

Check VBA references.

Is the version of your MDB the same of your Access?

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[David W. Fenton]

"RICHARD BROMBERG" <no*****@att.netwrote in
news:a%*********************@bgtnsc05-news.ops.worldnet.att.net:

I am using Access 2000 .

My program has about ten tables and about eighteen forms.
When I try to make an MDE I get a message saying "Microsoft
Access was unable to create an MDE database"

When I looked this up on Google I found a link to
http://support.microsoft.com/kb/202304/EN-US/ .

The article says The Microsoft Jet database engine version 4.0
allows a maximum of 2048 open TableIDs at one time.

I have no idea why my modest program can't be saved as an MDE, but
I don't think the the above has anything to do with it.

Any suggestions would be welcome.

Go to this page:

http://allenbrowne.com/tips.html

and search for the Corruption/Repair heading and read those
articles. The usual cause of an MDE conversion failure is that your
VBA project is corrupted in a minor way. Decompiling usually fixes
it or will flush out the reason why it can't be compiled to an MDE.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[RICHARD BROMBERG]

Once again, thanks .

There was an unused code fragment that had been used for testing/debugging
and it contained an error that couldn't compile.

The problem went away when I removed it.

"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...

"RICHARD BROMBERG" <no*****@att.netwrote in
news:a%*********************@bgtnsc05-news.ops.worldnet.att.net:

I am using Access 2000 .

My program has about ten tables and about eighteen forms.
When I try to make an MDE I get a message saying "Microsoft
Access was unable to create an MDE database"

When I looked this up on Google I found a link to
http://support.microsoft.com/kb/202304/EN-US/ .

The article says The Microsoft Jet database engine version 4.0
allows a maximum of 2048 open TableIDs at one time.

I have no idea why my modest program can't be saved as an MDE, but
I don't think the the above has anything to do with it.

Any suggestions would be welcome.

Go to this page:

http://allenbrowne.com/tips.html

and search for the Corruption/Repair heading and read those
articles. The usual cause of an MDE conversion failure is that your
VBA project is corrupted in a minor way. Decompiling usually fixes
it or will flush out the reason why it can't be compiled to an MDE.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/