multi-users problems

  • Thread starter Thread starter kianoush borhani
  • Start date Start date
K

kianoush borhani

Hy all,
My db has no problems in single user.
Now i am testing this database in a multiuser
configuration.
Before, I had lots of problems with "Object Invalid or no
longer set" and "Unrecognize database format"
Then the db had been corrupt lots of time.
So I installed win2000 pack 3, office pack 3 and Jet 4.
The problem of corruption seems to occur less often.
However, I am testing this db with 3 users. We are
entering severals records by the same time, close
programs, open it again .....
But after 20 or 30 minutes, an error occur "Run Time
error "2113" The value you enterd isn't valid for this
field" then the db is corrupt.
I have already created a new db and import all the things
(table format, query ...)
I don't know exactly what is the problems but it occurs in
a form.
I have a question concerning the query that i used.
WHen i enter in a form from a table, i have to select a
data from a combo box, which use a query from the same
table. Moreover, i use a function in a text box who
calculated an amount with the Dsum function, with a
criteria that is looking on the same table.
Maybe, when users enter lots of records, the query may be
not working well because access doesnt order the new
records.
I do not know exactly.
SO i am asking if access in a multiuser is sensible to
query from the same table.
I have asked to lots of people but nobody seems to
discover the problems.
SO please, if anyone know what is the problems, it would
be greatfull for me.
Thanks in advance.
 
There are a couple different ways to do "multi-user" -- and one of them is
good for headaches and corrupt databases.

If your multiple users are all trying to launch the same (single) copy of
the front-end that lives on your network, they will be "clobbering" each
other and causing severe network congestion. What? You DO have your
database split into front-end and back-end, right?!

If not, do that first.

Then, install a copy of the front-end on EACH user's PC, pointed at the
(single) back-end.

Good luck!

Jeff Boyce
<Access MVP>
 
Thanks for your answer concerning my problems with Ms
Access multi-user.
I didnt try yet to split databse. But i think this will
slow my databse.
However, my question is this : does query that is looking
on the same table and function which use Dsum with a
criteria on fields from the same table affects the
corruption?

Does the fact that severals users by the same time who
enter on the same forms affects corruption?
I have to had that my principal table is "attacked" by
lots of queryes from different forms.
Since I do not use dao, and especially microsoft jet 4,
the problems of corruption seems to not appears, or less
often. But i know that Ms Access is not appropriate in a
multi-user configuration.
So i doubt that this problems of corruption will appear
later.
What I have to do so is to compact each days this database
when all users have finished work.

But do u think i should convert this database into sql?
If so, do i have to create an web interface or does the ms
access client interface could attack the database from the
sql server?
Thanks a lots
 
Kianoush

Perhaps I wasn't emphatic enough.

If you don't split your database, you will continue to have corruption
problems.

If it seems I've avoided your question, I have -- the problems you are
seeing are most likely caused by the fact that you have multiple people all
trying to use the same single file at the same time.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top