B
Bart van Hees
Hello!
In our company we have an Access environment for doing CRM. It has...
30 tables
40 relations
and a maximum number of indexes (approx. 30)
(of course) multiple users are working in this database. Now the following
issue occurs:
- When maken an insert query via the form, a rotten record is added, with
chinese characters.
- Relations between tables are lost at some moment in time.
Has anybody an idea what couses this problem. My programmers keep telling me
that Access in not built for this purpose, but on the other hand, there
should be a way to prevent this problem.
We regulary execute the 'recover' option in menu Extra. But this isn't the
sollution..
who can help?
Bart
In our company we have an Access environment for doing CRM. It has...
30 tables
40 relations
and a maximum number of indexes (approx. 30)
(of course) multiple users are working in this database. Now the following
issue occurs:
- When maken an insert query via the form, a rotten record is added, with
chinese characters.
- Relations between tables are lost at some moment in time.
Has anybody an idea what couses this problem. My programmers keep telling me
that Access in not built for this purpose, but on the other hand, there
should be a way to prevent this problem.
We regulary execute the 'recover' option in menu Extra. But this isn't the
sollution..
who can help?
Bart