linked table problem and need advice

[ap]

Hello,
I had a problem with a linked table. The program is access 97 sr-2 and
jet 3.51, on a dell pent4 with 1 gig ram, running on widows server 2000
sp4. I have a fe and be, and the be tables are on the same pc I was
working on, today. I was editing some forms, coding, running queries,
etc. for about two hours, and then clicked on one of the linked tables (I
had opened and closed this linked table several times prior to the
problem happening), the table opened for a second, then I got booted out
of access. Other linked tables opened fine, and when I went to the be,
the table that booted me out (on the fe), opened fine. I did a compact
and repair, and opened the problematic table ok, now. Also, received no
error message.
..
My question is if anyone can let me know if this is foreshadowing larger
issues, by this I mean is this just a glitch, or could it be a symptom of
a larger problem to crop up worse, later on.
Should I do a decompile?
Should I transfer my fe into a blank db?
I have been working on the db, both front and back end for another 2
hours and everything seems ok, but wanted to get some advice on the
problem.
Any similar experiences, advice, etc. greatly appreciated.
Al

 

[Arvin Meyer [MVP]]

It probably was a corruption problem that you probably fixed with the
Compact and Repair. I'd run the Compact and Repair a few more times to be
sure. ALWAYS WORK ON A BACKUP COPY.

If you do decompile, make sure to have a backup copy. Run a Compact and
Repair after the decompile.

If the database hasn't been secured with user-level security, copying all
the objects into a new empty database works as well as decompiling. If it is
secured, you'll lose the permissions settings on the objects.

You can also use SaveAsText and LoadFromText to clear corruption. See my
code at:

http://www.datastrat.com/Code/DocDatabase.txt
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Al]

It probably was a corruption problem that you probably fixed with the
Compact and Repair. I'd run the Compact and Repair a few more times to
be sure. ALWAYS WORK ON A BACKUP COPY.

Thank you for the info, advice, and the code - I really appreciate your
opinion!

I always save a copy every few hours, with the date and a,b,c... (not
only because of corruption, but in case I do something stupid - I have
only lost x hours of work)

By the way, how does one find "undocumented" functions?
Al

 

[Arvin Meyer [MVP]]

The easiest way to find undocumented goodies is to turn on the Object
Browser from a code window (View ... Object Browser), then right-click in
the right pane and choose Show Hidden Members. The undocumented stuff shows
up in light grey. Click on them and read and experiment.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[ap]

Click on them and read and experiment.

I shouldn't have asked; I'll never get my "real" work done, now!!
Just kidding - Thanks for the lead!
Al