[olug] Networking issue

[Noel Leistad]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Craig Wolf wrote:
| Error messages:
| The constant error for a long time: runtime error 3260 "currently
locked out by user admin on machine XXX"
| New errors recently:
| "The following error occurred 12007, name not resolved. Please call
ProCare Technical support for assistance Login failed..."
| "Unable to have exclusive use of database files.  Make sure that this
application (and/or computer) is the only one using the ProCare database
files.  "
|
| The first one is the big concern since it is the constant one.
|
| At the point of the message, you click to close the error message and
the application closes.  You can then restart the application on the
workstation and continue working.  You may not get kicked out again for
quite a while or in just a few minutes after logging back in.
|

I was first wondering "how many users" the sw was written for, then
found the following:

RE: 3260
from
http://www.google.com/url?sa=t&ct=res&cd=3&url=http%3A%2F%2Fen.allexperts.com%2Fq%2FUsing-MS-Access-1440%2FDatabase-Locking.htm&ei=V3d_SK2FE46wgwKP3ZzbBw&usg=AFQjCNE72Bmc9K8jcvcz6Ed5u7Yo70KoTA&sig2=t_TeKfskj-SA9Amsaum5Wg
<quote>
MS Access will comfortably handle up to about 8 concurrent users without
significant locking problems.

As for records not being accessed - are you sure?

In most cases, forms are bound to tables or unconditional SELECT
statements in which case users are locking not just the page of records
but the whole data set.
</quote>

I found some other's search on runtime 3260, and I assume you've found
most of the same on your own. The customer's growth over a course of
years may FORCE them to consider upgrading.

Access is painful....

- --
#######################################################
#  Noel Leistad                                       #
#  noel at metc.net                                      #
#######################################################


A gift of a flower will soon be made to you.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFIf3nAOOK3iqPtSz8RAg0HAKDFv2r+I1wYVieH1kSkfRlr8HXTKQCbB5W+
bpZnq55obMoCBnqmay/izdQ=
=kibD
-----END PGP SIGNATURE-----