Multiuser problem

[Guest]

hi
i have got this databases located in the server
every one uses them, but very rarely, the error "you Can;t open this file,
because the file was place in "another computer name".

how can i make sure that this error msg doesn't pop up again.

thank u

 

[Joseph Meehan]

hi
i have got this databases located in the server
every one uses them, but very rarely, the error "you Can;t open this
file, because the file was place in "another computer name".

how can i make sure that this error msg doesn't pop up again.

thank u

I don't recognize that error message. Are you sure you have it exactly
was it shows?

I might suggest that if you don't have your applications split (or if
you don't understand what I mean by split) you should split them as that
eliminates a lot of problems with shared databases.

Splitting means keeping only the dynamic data (the stuff that changes)
on the server and everything else on a "front end" located on the user's
machine with all the forms queries static data and reports for each user.

 

[Guest]

the problem is if u use link tables the databases are to slow trought the
server.
is it any way of open the file always in a way that no one opens in "by
exclusive".

 

[Joseph Meehan]

the problem is if u use link tables the databases are to slow trought
the server.

Then you are not doing it right or there are other problems. Properly
split multi-user databases will always run faster split than sharing the one
on the server. That is just one feature.

In a split environment there is less LAN traffic.

is it any way of open the file always in a way that no one opens in
"by exclusive".

Only by assuring that no one opens it exclusively.

 

[Tony Toews]

the problem is if u use link tables the databases are to slow trought the
server.

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm