Can't create .mde database

G

GK

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.
 
6

'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.
 
S

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top