Update Query on network drive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem.

I am writing an application that has the all of the forms, queries, and
reports in one database and the tables in another. They are linked together.
The good news, when the database with the tables is on the local drive,
everything works fine.

The bad news is when I put the table database on the network drive, the
update queries hang up. The delete and append queries work just fine.

Any ideas??
 
1. Is it a Novell network by chance? There are some old issues with Access
and Novell that are easy to fix.

2. Make sure that all users of the database have Read, Write, Create, and
Delete privileges to the network folder holding the database. Not just the
database, but the entire folder. If not you can't properly create and delete
the .LDB file as necessary.
 
Jerry,

Yes, it is a Novell network. What are the issues and how can they be fixed?

I DO have complete rights to the whole folder.

Karen
 
Have your network people check out the following:
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10019363.htm

It's for older versions of Novell so I'd be surprised if it is the problem.
They might search the Novell Knowledge Base for newer problems. Try searching
on 2935504 for example.

Also it talks about error messages. Access starts doing strange things way
before the error messages appear.

If this is the problem, many other programs will start working faster!
 
Back
Top