Cannot create MDE in Access2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Hammond - 09 Dec 2004 16:41 GMT

hello all

this is my first post to this great newsgroup in a long long time...

I have an application originally created in Access97, then updated to Access
XP (but still using DAO). I use the .mde file instead the .mdb for
security/performance reasons. Now we have new computers using Office 2003
but when I try to create the mde in Access2003, it says it cannot create,
apparently because there are too many tables (the app runs on linked
tables, and the database has aprox 30 tables). I have another smaller
application that has fewer linked tables and it creates the mde without
problem, so I guess that the number of tables is the problem. Do I have to
split the large database into 2 or 3 with fewer tables in them? or is there
a way I can expand the capacity of number of linked tables in the
application? Sort of the FILES= xx in the config.sys file in CA Clipper

any help will be greatly appreciated
Peter

Reply to this Message

Alex Dybenko - 09 Dec 2004 16:52 GMT

Hi Peter,
30 tables is not a problem, i think it gives yuo wrong err message. try to
import everything in new mdb and try to make mde from it

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> hello all
>
[quoted text clipped - 17 lines]
> any help will be greatly appreciated
> Peter

Reply to this Message

Andrew Brill - 10 Dec 2004 12:44 GMT

We just did the same conversion - it shows that error for any compile error.
Go the VBA editor and choose compile from the debug Window. We found a
couple of errors in the code that upset Access 2003 that 97 didn't care
about.

> hello all
>
[quoted text clipped - 17 lines]
> any help will be greatly appreciated
> Peter

Reply to this Message