I am having a problem with 1 table in my AREV 3.12 application in that i cannot Verify, list, select, run reports that use this table.

All other tables in the system work fine ie i can list, verify etc. If i copy the table to another system (test environment) i can do all of the above with no problem.

Does any body have any ideas as to what might be the cause of this or any possible solutions?

You don't say which network you're operating on, or anything about your version of workstation client or Windows version. You don't report the exact error text when it fails. However, try the following:

Back up your system.

First, we'd rebuild any indexes for the file.

Then we'd check network user privileges include full access rights for the file in question.

Then we'd check that no-one had the file in use, or open in another application and that no virus scanner had stalled on scanning the file in question. Do this also from the monitor on your network server.

The fact that you can copy it suggests it may be marked read-only or have some other weird combination of attributes. If in doubt, back up your system, then assuming the file is named (in DOS) REV12345.lk (and REV12345.ov), rename these files as junk.lk and junk.ov and then xcopy junk.lk to rev12345.lk and xcopy junk.ov to rev12345.ov, then see if they then become accessible.

You really need someone with a working knowledge of your AREV system before you start moving things about too much - some applications are sensitive to volume placement and network vs. standalone processing.

Healthsolve have a reliable and trustworthy consultant for their AREV projects - "J.S." - whom we would recommend you contact for a definitive solution in this regard.

The Sprezzatura Group

World Leaders in all things RevSoft

Hi All

In the interests of completeness:

The problem seems to have gone away by itself.

I was thinking maybe the dictionary was corrupt because the table didn't work in the live environment but did work when you copied the dos files (not including index and dictionary files) to the test environment. The problem could have been caused by a corrupt index too.

Given that the problem went away by itself, I am inclined to think that the table somehow got locked up by a user or the network, and eventually the network or user let go of it. The usual cause of this is turning the pc off at the powerpoint without closing anything down (using the software) first. Some clients won't be trained.

There was no error message. The system merely froze up - not unlike black screen of death.

The network/client/op sys didn't seem relevant because of the fact that the table was ok when copied to another location in the same environment. We checked it wasn't read only, and we had no problems accessing other files/tables in the directory, so don't think it was a network security issue.

The problem could have been caused by a virus scanner. It is a bit difficult to check this especially when it takes about 3 days to get access to someone who can sit at the network server and tell you what is going on. This is one of the joys of outsourcing. The client users use the app, we support the app, someone else supports the client PCs and somebody else (sometimes two different companies) support the LAN and servers. I heartily recommend against this arrangement. Having all your users unproductive for this long negates any saving.

Scott, LMS

Scott .. Amen. It's like reading braille with a rubber hook.

Don

Hi Don

This is also like trying to stop someone from telling you their very personal health problem, to explain that you cannot help solve their health problem, even though you work for a company named HealthSolve. Unless they think a patient care management computer system (not to be confused with a diagnosis system or a human medical practitioner) would help.

Perhaps I should keep a roster of phone numbers for shrinks.

Scott, LMS (now known as HealthSolve, but I'm not changing my handle especially as I mostly work on the Real Estate system.)

View this thread on the forum...