Networks

Ask something
Discussion Locked

Not seeing MDB changes made

0 helpful
8 replies

by c1980

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Urgent help requested.
I have a VB6 app using DAO/Jet to access an MDB on a Novell server from two different NT 4.0 Work Stations.
The App does a loop through all database objects for the Jet workspace when it ends to make all database references are closed.

The problem:

Work station 1 is reviewing and making changes to data.
Work station 2 is reviewing the same data but does not see the changes, event after loading the form, or starting the application again, even 30 minutes later.
If WS 1 restarts the app, he sees the changes he made.
When the MDB is copied locally onto WS 2 and is opened with MS Access, he sees the changes in the table. If he starts the application again, he still sees the old data.

The User of WS 2 claimsto not see the new data even after a reboot of the WS.

One thing We noticed is that the change date of the MDB file on the server is still from yesterday. Normally when all users who opened an MDB, close out, the MDB file date is changed, and theLDB lock file is erased.

I have no experience with Novell, and very little with servers at all. I am trying to find out myself but time is running out here to get this to work.

Any help would be highly appreciated!

8 replies

by c1980

I just posted this first question and I see the author name came up with "User Deleted" ??!! What does that mean?

It should say CClint@gmx.net

by jimbb

You may be bothered by the server's caching. An *.MDS file is "just" a file for a server, and it tries to cache as much of those as possible, to server you faster. But if the server admins have tuned the server so that it waits relatively long with writing the "dirty cache buffers" (as they are called on a Novell server), you are trying to read cached old information, since the changed info from PC2 still has to be written to disk.

Try to get info on the version of the Novell server (5.something, most likely) and service pack level. They may have to type something like "set client side caching enabled=off" on the server for your problem to be fixed.

Jim

by c1980

The Novell server version is 5.1
The Novel client is 4.8

Q. Can one exclude a certain file to be cached? Or is it a global setting for the work station PC, or for all workstations?

by tjc

By the way the "user deleted" is normal for new people who start placeing messages immediatly after signing up. All that means is that your account has not gone all the way though all there databases yet.

by c1980

Thank you for answering my comment. I saw the following day that 'User Deleted' was changed to my alias.
The comment was more of a 'Just Wondering' question and I didn't expect it to be answered seperately.
I would like to give you a few points for responding anyways, but it is not possible here because I would need to award you half of the points and that wouldn't be fair to Jim who has given alot of help,also through e-mail, to the main question and problem.

This discussion is closed to new replies.