D
Duncan Dimech
Dear All,
I have coded a system which is in use by three companies. The system is a
real estate catalogue management tool. It is written entirely with
Ms-Access XP and it has been split as a front-end and as a backend and it
has been secured through the MDW security file. The system works well in
two companies but I have some problems with the third. All three companies
have the same installation - a mapped drive which we call Z: and a number of
folders including front-end and backend in the Z drive. The front-end
directory contains the front-end of the system while the backend contains
the backend. Apart from these I have a MDW, images and audit folders which
contain the relative files.
The problem is this - The third company and only the third has 23 employees
(the other have only 5 users) but only 12 log contemporary as there are only
12 machines available and all employees have the right to enter data. Data
is entered from unbound forms and when they press the SAVE and EXIT button,
the system saves the data through and an ADO connection. While editing and
browsing data is retrieved using bound forms.
This works fine but sometimes (even 5 times a day) the front-end at the
third company corrupts and a compact and repair is needed.
Any form of information will be appreciated
Thanks and Regards
Duncan Dimech
EXOR Group
I have coded a system which is in use by three companies. The system is a
real estate catalogue management tool. It is written entirely with
Ms-Access XP and it has been split as a front-end and as a backend and it
has been secured through the MDW security file. The system works well in
two companies but I have some problems with the third. All three companies
have the same installation - a mapped drive which we call Z: and a number of
folders including front-end and backend in the Z drive. The front-end
directory contains the front-end of the system while the backend contains
the backend. Apart from these I have a MDW, images and audit folders which
contain the relative files.
The problem is this - The third company and only the third has 23 employees
(the other have only 5 users) but only 12 log contemporary as there are only
12 machines available and all employees have the right to enter data. Data
is entered from unbound forms and when they press the SAVE and EXIT button,
the system saves the data through and an ADO connection. While editing and
browsing data is retrieved using bound forms.
This works fine but sometimes (even 5 times a day) the front-end at the
third company corrupts and a compact and repair is needed.
Any form of information will be appreciated
Thanks and Regards
Duncan Dimech
EXOR Group