error 3048

[Claude]

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 we have in Application log (on the TS Server) an Application
error ID
1000 with MS-Access V9.0.0.6620, 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

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 anything else we could do?

 

[Douglas J Steele]

Is your application split into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables),
with each user having his/her own copy of the front-end? If not, I'd
recommend switching to that approach. There are many problems that arise
when users share the same front-end.

 

[Claude]

Hi Doug,

I am sorry, I forgot to mention it,

Yes it is split Tables in one database, and one for each user for code,
forms ect...

Many thanks!