Cannot open any more database - Error 3048

[Claude]

Hi,

Since I have being invited to post our issue, I am not sure if I am posting
it at the right place.

We are using an MSACCESS 2K database on a W2K3 TS sessions, for from 2 to 25
TS users simultaneously.

WHen they are opening a form with a lot of controls (between 300 and 500),
from time to time (cannot recreate explicitly the error), the users are
kicked out and they receive an error 3048.


The pattern looks like it get a little bit slower before it happens.

- The problem occur after 2 or 3 hours of usage (many more record created
and/or edited), not before.
- Compact and Repair seems to postpone the issue by 24 hres



In the Application log (on the TS Server) we can see an Application error ID
1000 with MS-Access V9.0.0.6620. ******* 0x000c94c4 ******** ( * is it
possible to know the meanig of that code?)

Since we are experiencing this problem, we tried to add the Table.close, set
table=nothing and set recordset=nothing, in order to maximise the memory
release, without having a positive impact on our error 3048.

Is there any else we could do?



Many thanks!

 

[John W. Vinson/MVP]

Is there any else we could do?

Yes, and it's urgent:

SPLIT this database, using Tools... Database Utilities... Database Splitter
Wizard.

Each user should have their own copy of the "frontend", with the form (and
other forms, and reports, and queries, etc.), all linked to the shared
backend, containing only the tables.

The frontends can be in individual folders on the server; you should not try
to split with the frontend and backend on different LANs.

John W. Vinson//MVP

 

[Claude]

Hi John,

It was already done,

Thanks anyway

Yes, and it's urgent:

SPLIT this database, using Tools... Database Utilities... Database
Splitter Wizard.

Each user should have their own copy of the "frontend", with the form (and
other forms, and reports, and queries, etc.), all linked to the shared
backend, containing only the tables.

The frontends can be in individual folders on the server; you should not
try to split with the frontend and backend on different LANs.

John W. Vinson//MVP

 

[Claude]

In fact,

We have one Database that has the tables (from 380 to 400 tables),
And the one that has the front end, has some tables, but not much, let's say
around 20-30, and all of the code.

Everything is ran locally from a TS Session, so data through the network.
Every users has his own frontend database.

Do you have an idea for the 0x000c94c4 meaning?

Many thanks!

 

[PC Datasheet]

This problem is caused by having too many queries and aggregate functions
open at the same time. If the program worked previously without the error
and now you see the error, look at what was changed. Consider that it might
be more users.

How do you get 300 to 500 controls on a single form?

Upgrading to AccessXP or Access2003 won't help because they have the same
capacity to handle queries and aggregate functions as Access2000.