Hi,
we are running a pretty extensive DB, evolved out of 10 years of incremental development, today consisting of accdb frontend with MySQL backend (linked tables).
I am increasingly facing corruption while editing forms / reports, and am trying to find out why corruption occurs at all.
I suspect that the sheer size of the db is creating problems: ~190 tables, ~160 forms, ~30 reports, 9 modules.
Any idea, whether the number of items can cause corruption?
What's the number of maximum items accdb can handle?
And how can I tell, if this is the problem?
Any hints very much appreciated!
Marcus
-----------
frontend: accdb-file for Access 2010, running on Win7 64-bit
backend: MySQL 5.1.50 via OBBC-connector
both backend and frontend backed up regularly.
we are running a pretty extensive DB, evolved out of 10 years of incremental development, today consisting of accdb frontend with MySQL backend (linked tables).
I am increasingly facing corruption while editing forms / reports, and am trying to find out why corruption occurs at all.
I suspect that the sheer size of the db is creating problems: ~190 tables, ~160 forms, ~30 reports, 9 modules.
Any idea, whether the number of items can cause corruption?
What's the number of maximum items accdb can handle?
And how can I tell, if this is the problem?
Any hints very much appreciated!
Marcus
-----------
frontend: accdb-file for Access 2010, running on Win7 64-bit
backend: MySQL 5.1.50 via OBBC-connector
both backend and frontend backed up regularly.