missing / vanished mdb

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

Have you ever heard of this happening?

I have a rather large, complicated mdb file which is
accessed over a multiuser network. This file has linked
tables from another mdb file in the same folder. The
network is using the Citrix emulation program to access
the file as well as other applications.

For awhile (2-3weeks), 1-6 times a day, the file would
become corrupted and need to be repaired. We swapped out
a user's computer and moved some electronics from her
desk. The corruptions nearly disappeared.

But now, for the past week or so the file has just
disappeared 4-5 times. It would be there one minute
working fine, and before you know it, a user calls and
says a message comes up and says the file can't be found.
When I look, it's gone. We can't fine a pattern of when
or under what circumstances.

The users do not have access to the folder in which it
resides and we believe that no user is purposely deleting
the file.

A search for the file on the server it resides turns up
nothing - not even in the recycling bin.

What could be causing this? Network or Access? Is there a
way to find out? Any ideas would be greatly appreciated!

Of course, the IT guy says it can't possibly be the
network and the file programmer says there is nothing in
the file that would do this. We are at a loss. Please
help.

Thank you very much.

Penny
 
Penny said:
Have you ever heard of this happening?
Click to expand...

No, this problem should not be able to happen on its own
This file has linked
tables from another mdb file in the same folder. The
network is using the Citrix emulation program to access
the file as well as other applications.
Click to expand...

The above setup is all wrong. The correct setup is to give each user a mde
file, and NOT HAVE MULTIPLE users in the same mde file. This is standard
setup for ANY competent access developer. I do not know of any developer
worth their salt using a different setup. If you are allowing multiple users
into the same front end, then fix this immediately. You should also be using
a mde file.
For awhile (2-3weeks), 1-6 times a day, the file would
become corrupted and need to be repaired. We swapped out
a user's computer and moved some electronics from her
desk. The corruptions nearly disappeared.
Click to expand...

when using Citrix, a bad end user computer CAN NOT EFFECT the running of
ms-access. Citrix is remote control software. I mean, do you think that your
bad computer can damage the database when you order a book on Amazon.com?
When using Citirx, bad client computers do not effect the system. When you
use ms-access in a file share (non Citirx), then most certainly a bad pc can
effect things. Since you are not allow the client computers to open the file
directly, then bad pc's don't matter in your setup.
The users do not have access to the folder in which it
resides and we believe that no user is purposely deleting
the file.
Click to expand...

does the Citrix session automatically launch the ms-access application, or
are users allowed to click on, or browse to a folder and use the mde/mdb
file? Do you have the ms-access application hidden?

In word, you go file->new every time you need a new document
In Excel, you go file->new every time your need a new spreadsheet.

However, in ms-access, going file->new often means the user OVERWRITES the
existing file. You might want to check how the users are being trained. I
would also suggest you build a start-up menu, and thus hide the ms-access
interface (it takes less then 5 minutes to do this, and thus the users will
not be able to muck around with the application). You do not want users to
go file->new, and then answer yes to overwriting the existing file. Since
users do this so often in word/excel etc, often they try to do the same
thing in ms-access, and in place of going file->open, they go file->new, and
whack the "yes" to overwriting the existing file.

Also, you want to make sure you server does not have a op locks problem
either. (again, since you are using Citrix, then this ONLY refers to you
server setup NOT THE CLIENT COMPUTERS on the network).

Check out the following:

http://www.granite.ab.ca/access/corruptmdbcauses.htm
 
Back
Top