By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.

Problem with disconnecting

P: n/a
Hello,

I have an application and BD.mdb (Access97) on the server (Windows2003 EE)
with fifteen workstations (Win2k & WinXP), which run the application by
mapping the share on the server. The problem is that after some user run
the application and after doing some job, they don't close the
application, but after some time another user can't run it, because of the
BD is in suspect mode (information from LDBview).

My question is: what is the reason of this? Corrupted NIC, LAN? Maybe bad
settings in ODBC, Registry etc.?

Please, help...

Thanks for all,

OliP

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sounds like you don't have a front-end/back-end set up. When more than
one user is using an Access db the data tables (back-end, aka BE) must
be separated from the front-end (aka FE: queries, forms, reports,
modules) and each user have a copy of the FE on their PC. This avoids
corruption of the db.

Read the Access Help articles on splitting the db. The Help Contents
hierarchy is:

Working with Data
Sharing Data
Split an Access database

There is a wizard (Access 2002) under

Tools > Database Utilities > Database Spliter

that will walk you thru the process.

Once the db is split & the FE is on each users PC you will have to re
link the tables to the BE. On each PC use

Tools > Database Utilities > Linked Table Manager

for this.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlrYCYechKqOuFEgEQLZOwCg9Xo8Ow1JMntb8CzmXfVmGJ EpBBIAniwE
itv6yxL301J303qcU2CyhDL/
=aiEz
-----END PGP SIGNATURE-----
OliP wrote:
Hello,

I have an application and BD.mdb (Access97) on the server (Windows2003
EE) with fifteen workstations (Win2k & WinXP), which run the application
by mapping the share on the server. The problem is that after some user
run the application and after doing some job, they don't close the
application, but after some time another user can't run it, because of
the BD is in suspect mode (information from LDBview).

My question is: what is the reason of this? Corrupted NIC, LAN? Maybe
bad settings in ODBC, Registry etc.?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.