Can't create .mde database

[Guest]

Hi,

I have a small database (about 25 tables, and 25 forms, 10 reports). when I
try to compile it to .mde database. it gives me error "Microsoftware office
access was unable to create an MDE database), and with detail explanation
regarding the retriction of 2048 TableIDs.

with a few tables and forms, It does not seem that the 2048 limits is
reached. can any one help me to find out what is the real issues that prevent
me from creating the .MDE file.

thanks.

 

['69 Camaro]

Hi.

can any one help me to find out what is the real issues that prevent
me from creating the .MDE file.

Check the "Can't make an MDE!" checklist on the following Web page to help
you determine what's wrong:

http://www.Access.QBuilt.com/html/conversion.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[sabisiah sabi]

Hi,

I have a small database (about 25 tables, and 25 forms, 10 reports). when I
try to compile it to .mde database. it gives me error "Microsoftware office
access was unable to create an MDE database), and with detail explanation
regarding the retriction of 2048 TableIDs.

with a few tables and forms, It does not seem that the 2048 limits is
reached. can any one help me to find out what is the real issues that prevent
me from creating the .MDE file.

thanks.

 

[John W. Vinson]

Hi,

I have a small database (about 25 tables, and 25 forms, 10 reports). when I
try to compile it to .mde database. it gives me error "Microsoftware office
access was unable to create an MDE database), and with detail explanation
regarding the retriction of 2048 TableIDs.

with a few tables and forms, It does not seem that the 2048 limits is
reached. can any one help me to find out what is the real issues that prevent
me from creating the .MDE file.

Try Compacting the database first; if that doesn't help, try creating a new
empty database and using File... Get External Data... Import to import all
objects from this one. There may be some rubbish sitting around in system
tables, especially if you've been doing a lot of design changes.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com