Data disappearing - without apparent cause

Firstly, please accept my apologies if this problem has already been
answered in other posts / groups. I have searched as best I can, but I
can't find the exact same problem elsewhere.

I have an AC2003 database (split into FE/BE) that provides (amongst
other things) the ability for users to mail merge. In order to give the
user control over where mail merged documents are stored, I have
provided a couple of fields on a form where folder names can be
stored, e.g. C:\My Application\Letters,(the fields are part of the
table that is the form's control source). As different users may want
to store the merged documents in different places on their PC's (or
even on the network server where the BE is), the table containing the
fields is actually local to the FE part of the database, and NOT on the
BE, that's to say that each user writes to, and reads from, their own
table. Note that it is not envisaged that users will change the folder
paths frequently - they would normally be set once after the database
is put on their PC and then left alone.

Over the last few days, some users have complained that the mail merge
is failing, and on ivestigation, I have found that the fields have been
cleared of the data - apparently without the users doing anything more
serious than closing the system at night and then re-opening it the
following morning.

I do not beleive this is a "user error" problem, it has happened to too
many people - all of whom are experienced in running the application.

I also don't think that it's a network problem - this particular set of
data is always stored locally on the same PC as the FE, irrespective of
where the BE may be located.

The form is requeried ON OPEN to refresh a series of unbound text boxes
that are also on the form, but I can't see that this would cause the
problem either.

I would be grateful for any suggestions as to where I might start to
look for the cause of this problem.

Regards,

Huw.

.

Relevant Pages

  • Re: Is This Possible ... ? Yes - Upload images to an Access database
    ... It looks like your databases folder is outside the root of your web ... I created a database exactly as you said, the only change I made was to ... and underneath an 'upload' button and a 'view images' button. ... Dim con As New Data.OleDb.OleDbConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • RE: Sharepoint Backup & Restore
    ... even you have moved the Sharepoint database to another location. ... You can delete the $NtUninstallxxxxxx$ folder to free up space. ... Perform an online backup of the Exchange 2003 Information Store to purge ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • Re: How to Link a file instead of embeding in Access Table
    ... There will be multiple folder in time, but right now, I will ... visio drawing in the database. ... It's usually simpler just to store the names and locations ... Could I use that if I put a OLE ...
    (microsoft.public.access.externaldata)