W
William
Hi, in my office, there is a backend database to store our data and a
frontend database contains queries, tables, forms, macros and VB scripts that
let the users use about 6 applications involving filter data, print
documents, create or edit record, etc.
However, in recently, the Access is down from one day to couple of days.
The error can be divide into two types, some users can partially use the
applications; some users cannot open the Access database template; and some
users can work normally.
There are about 30-40 users to use this Access Tempate (frontend)
application and this is placed on a server to share.
I am wondering the problem is cased by:
1. Office version difference (SP1, SP2....)
2. Server problem
3. Setup problem
4. VB script unclean
frontend database contains queries, tables, forms, macros and VB scripts that
let the users use about 6 applications involving filter data, print
documents, create or edit record, etc.
However, in recently, the Access is down from one day to couple of days.
The error can be divide into two types, some users can partially use the
applications; some users cannot open the Access database template; and some
users can work normally.
There are about 30-40 users to use this Access Tempate (frontend)
application and this is placed on a server to share.
I am wondering the problem is cased by:
1. Office version difference (SP1, SP2....)
2. Server problem
3. Setup problem
4. VB script unclean