Tom,
Your advice has been wonderful and I greatly appreciate you sticking with me
on this. I will work on sending you an e-mail later with the database.
Thank you for that offer, you've gone above and beyond with your help. I
need to clean up the data a little bit because I work in a hospital and due
to HIPAA regulations, I'll need to get out the patient information before
sending it to you.

It's hard to tell if it's one PC that is causing the problem. When it goes
down, it goes down for all. I've reimage one potential problem PC and today
I'm cutting them off completely and am having them go back to paper for a few
days to see if it makes a difference.

Because I work in a large hospital, yes, the servers are on UPS. There are
no laptops on wireless right now. After I hardwired the laptop, I created a
new database and didn't import in any data (I am archiving all old and
starting a new one from this day on), so the wireless would not have
corrupted the database.

Since we were strictly working on the BE, I assumed that was the part that
you wanted compiled. I just ran it on the front end and it had one error,
but it was in code that wasn't being used, it was from the old program and I
eliminated those fields.

Got another corruption after I made all the changes this morning and wrote
the last e-mail. I have since cut off a main user and seeing if that
eliminates the corruption. Thanks Tom, I'll work on getting you the file
next.

Keeler

"Tom Wickerath" wrote:

> Hi Jeff,
>
> > I've tried about everything and it's still getting corrupted.
> Have you looked into possible hardware issues. The last part of the reply I
> wrote on 10/14 includes the following:
>
> "If corruption continues, especially from one individual, then it's time to
> start checking out their personal practices (ie. proper exiting of the DB),
> along with thier hardware. They may have a bad network interface card, or
> some other problem in the network (network cable, router, etc.)."
>
> Is the file server on a UPS (Uninterruptable Power Supply)? If you are in
> an industrial environment, with motors that draw a lot of current when they
> start, you could be getting voltage line sags that are enough to account for
> this type of corruption. This would apply to your users as well. I know of
> one case where a PC was plugged into the same circuit as a vending machine.
> The database would get corrupted every time break time came around. As
> employees were purchasing cans of pop from the vending machine, the voltage
> sagged just enough to cause corruption in the JET database.
>
> > I thought maybe a wireless laptop was disconnecting from the network
> > and causing the database to corrupt.
> You need to ask, beg, demand, etc. that people *never* open your database
> with a wireless connection. This is an inherantly unstable setup. JET
> databases are just not suitable in such an environment. If your users insist
> on using wireless connectivity, then you need to insist on migrating the BE
> database to SQL Server.
>
> > I hardwired the laptop and it still got corrupted.
> It might have already been corrupted from the wireless activity.
>
> > I couldn't compile the code, the selection seemed grayed out. I also
> > don't have any modules, so I think your suggestion on adding Option Explicit
> > doesn't fit for my situation.
> The selection will be greyed out if the code is already compiled. Are you
> sure that you have absolutely no code behind any forms and reports? If you,
> or someone previous, ever used the command button wizard to add a command
> button to a form, then you more than likely have some VBA code in your
> project. Create a new stand-alone module. While in the VBE (Visual Basic
> Editor) environment, click on View > Project Explorer. Do you see any forms
> or reports displayed? If so, these forms and reports have code modules
> associated with them. They may very well be empty modules, in which case they
> can be deleted.
>
> > As for the Uniform Naming Convention, I'm just pointing to the BE using
> > the linking in Access, I do not have drive letters hard coded.
> The linked table manager uses hard-coded drive letters unless you navigate
> through My Network Places. If you click on Tools > Database Utilities >
> Linked Table Manager, and you see a drive letter specified at the beginning
> of the path, then you are indeed using hard-coded drive letters.
>
> > Should I start messing with the record locking?
> Not at this time. I would solve the corruption problem first.
>
> If you can compact and zip a copy of your front-end and back-end files, and
> send them to me, I will take a look at them for you. A slightly obfuscated
> form of my e-mail address is shown below. It should have 18 characters total,
> after you remove the indicated characters. Whatever you do, please do not
> post your real e-mail address to any newsgroup message.
>
>
> Tom
> QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
> http://www.access.qbuilt.com/html/ex...tributors.html
> __________________________________________
>
> "Keeler" wrote:
>
> Hi Tom,
> I'm back, unfortunately without happy results. I'm about at my wits ends
> with this database and am very frustrated. I've tried about everything and
> it's still getting corrupted. My latest attemps have been that I've had one
> desktop reimaged back to original thinking it could be a corrupted OS file
> that was causing the mouse to corrupt the database. I thought maybe a
> wireless laptop was disconnecting from the network and causing the database
> to corrupt. I hardwired the laptop and it still got corrupted. This morning
> I created a new database from scratch AGAIN and imported in the files as you
> suggested earlier. This time I did not bring the main data back into it, I
> only imported the structure, thinking that old data may be causing a problem.
> I then did the best I could to follow your latest instructions. History on
> this database, this was not my original database in the beginning, but I took
> the original tables and created my own forms, queres, reports, macros, etc.
> so I'm not sure if it was created in Access 97 or not. Data goes back to
> 2003, that's all I know. Because of that, I did your instructions on adding
> the DAO 3.6 to the VBE. I got a little lost with your instructions from that
> point. I couldn't compile the code, the selection seemed grayed out. I also
> don't have any modules, so I think your suggestion on adding Option Explicit
> doesn't fit for my situation. As for the Uniform Naming Convention, I'm just
> pointing to the BE using the linking in Access, I do not have drive letters
> hard coded. I did not make the front end a .mde file. I don't feel real
> confident, after everything else I've done, that this will make the
> difference for me.
>
> Again, I'm very frustrated and am about to tell them to go back to paper and
> pencil because this database going down once a day is making me look real bad
> right about now and they're getting frustrated with the system and as a
> result, me. Any other suggestions to try would be greatly appreciated. I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6352-re-continuous-corruption-of-database.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6352
> really don't know where to go from here with the exception of punting.
> Should I start messing with the record locking? I currently have it set to
> the defaults. Thanks.
>