A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access disconnecting from server?



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2004, 01:11 AM
Arvin Meyer
external usenet poster
 
Posts: n/a
Default Access disconnecting from server?

Usually this means that there is a hardware disconnection. I don't remember
what the monitoring procedure is on Novell, as I haven't used it in 7 years,
but you can use perfmon on a Windows server. Maybe your admin will be able
to help set up a packet monitor.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Diane Yocom" wrote in message
...
sorry for the cross-post, decided to post somewhere with a little more
traffic.

I have an Access 97 database sitting on a Novell server. It currently has
about 5 regular users.

For the past two months, the database has been "disconnecting" at random
times. By disconnecting, I mean, we get the following error:

"L:\Path\DB.mdb isn't a valid path. Make sure that the path name is

spelled
correctly and that you are connected to the server on which the file
resides."

We know the path is correct because the users can access the database
initially, it just seems to kick them out (with this error message) at
random times. If they click on OK through the series of messages, it will
put them back to the database application, but they're unable to do

anything
until they close and reopen the database.

The database hasn't changed, so I don't think it's a code issue. We

updated
Jet 4.0 yesterday and it seemed to be working better, but today people are
having problems again. We're starting to wonder if there is a specific
user/machine that is screwing up all the others.

Does anyone have any thoughts on how to go about troubleshooting this?
Diane Y




  #2  
Old June 4th, 2004, 01:51 AM
david epsom dot com dot au
external usenet poster
 
Posts: n/a
Default Access disconnecting from server?

also check the version number of the Novell clients (see
if they are all the same), then check the Novell site to
see if any specific problems are listed.

(david)

"Diane Yocom" wrote in message
...
sorry for the cross-post, decided to post somewhere with a little more
traffic.

I have an Access 97 database sitting on a Novell server. It currently has
about 5 regular users.

For the past two months, the database has been "disconnecting" at random
times. By disconnecting, I mean, we get the following error:

"L:\Path\DB.mdb isn't a valid path. Make sure that the path name is

spelled
correctly and that you are connected to the server on which the file
resides."

We know the path is correct because the users can access the database
initially, it just seems to kick them out (with this error message) at
random times. If they click on OK through the series of messages, it will
put them back to the database application, but they're unable to do

anything
until they close and reopen the database.

The database hasn't changed, so I don't think it's a code issue. We

updated
Jet 4.0 yesterday and it seemed to be working better, but today people are
having problems again. We're starting to wonder if there is a specific
user/machine that is screwing up all the others.

Does anyone have any thoughts on how to go about troubleshooting this?
Diane Y




  #3  
Old June 5th, 2004, 11:29 PM
Tony Toews
external usenet poster
 
Posts: n/a
Default Access disconnecting from server?

"Diane Yocom" wrote:

I have an Access 97 database sitting on a Novell server. It currently has
about 5 regular users.

For the past two months, the database has been "disconnecting" at random
times. By disconnecting, I mean, we get the following error:

"L:\Path\DB.mdb isn't a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file
resides."

We know the path is correct because the users can access the database
initially, it just seems to kick them out (with this error message) at
random times. If they click on OK through the series of messages, it will
put them back to the database application, but they're unable to do anything
until they close and reopen the database.


I'm wondering if there was a Novell Server or client software update
about two months ago.

The database hasn't changed, so I don't think it's a code issue. We updated
Jet 4.0 yesterday and it seemed to be working better, but today people are
having problems again.


Access uses Jet 3.5 so updating Jet 4.0 won't make a difference.
Ensure you have Jet 3.5 SP3 installed on all the systems.

We're starting to wonder if there is a specific
user/machine that is screwing up all the others.


Determining the workstation which caused the Microsoft Access MDB
corruption
http://www.granite.ab.ca/access/corr...orkstation.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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.