Microsoft Jet Error

[T Khoury]

Unable to make an .mde file. Microjet dtabase engine version 4.0 max of 2048 OpenTable IDs at one time. How do I fix this?

[mshmyob]

Try compiling your database/code before trying to make an mde file.

cheers,

[T Khoury]

Yes I did and it still has the error. Thanks.

[mshmyob]

So you are saying you had no errors in the compile?

If that is the case how many table defs do you think you have. How many tables, forms, queries, etc.

cheers,

[T Khoury]

I have 18 linked tables, 28 queries, 35 forms, 14 rpts, 1 macro and 3 mods

[mshmyob]

I can't think of anything else. When it has happened to me it has been because of a slight error shown up only when the compile is done. But since you say you had no errors when compiling I can't think of anything else.

cheers,