Help with compacting db

[Guest]

I have access 2002, when I was compacting the back end I got the following
message: "Could not find field 'Description'". The help button states the
following:
"A column name that does not exist is being referenced". How can I find
where this reference is? or how can I resolve this issue so that I can
compact the database.
thanks
Al

 

[strive4peace]

Hi Al,

have you compiled the code in your database?

Whenever you write or paste code, your should ALWAYS compile
it before you attempt to run it.

from the menu: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

I do not believe this will check macros (I don't use them).
If you do have macros, you will need to open each one
yourself and check it. You can narrow the search by first
checking what runs when the database is opened.

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Guest]

Hi Crystal,
Thank you for responding. You are right the code would cause such a problem,
however, this is a backend I only have tables in it I removed even the
queries. I am still getting the same message. any idea?
thanks again
Al

 

[strive4peace]

Hi Al,

try decompiling the database

make an icon with this as its target:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\path\filename.mdb" /decompile

if your Access program is not located in the directory
specified, make the appropriate substitution

you said you removed objects ... is EVERYTHING showing? You
may have a hidden object or a user-system object that needs
to be removed...

Tools, Options, View tab
check Hidden
check System
(ignore anything that starts with Msys as these are
Microsoft system objects -- user-system objects start with Usys)

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Guest]

Hi Crystal,
thanks again. Decompiling worked. do you have any idea why? there was no
code nor user objects. thank you
Al

 

[strive4peace]

Hi Al,

you're welcome

As for info on decompiling, here are some links:

'~~~~~~~~~
Here's what I know about Decompiling:
http://www.rogersaccesslibrary.com/DecompilingDatabases.zip
The document is for Access 97, but it is still essentially
correct for Access 2000.

-- --Roger Carlson MS Access MVP www.rogersaccesslibrary.com
'~~~~~~~~~~

from (e-mail address removed)

* WORKING WITH LARGE PROGRAM DATABASES IN ACCESS 97
from the October 1998 issue of Access/Office/VB Advisor Magazine

http://web.archive.org/web/20030204023622/http://www.databasecreations.com/largedb.htm


'~~~~~~~~~~

Decompile or how to reduce Microsoft Access MDB/MDE size and
decrease start-up times
http://www.granite.ab.ca/access/decompile.htm

Unless there is a symptom I'd suggest no more than every
month or so for a front end under active development.

Tony
--
Tony Toews, Microsoft Access MVP
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

'~~~~~~~~~~

In addition to the other links you've been given, check out
what Michael Kaplan says at the following URL ...

http://www.trigeminal.com/usenet/usenet004.asp?1033

Always make a back up copy of your MDB or ADP before using
the decompile switch. It doesn't happen very often, but I
have personally seen the situation where a class module was
no longer recognised as a class module, but appeared to
Access and VBA be a standard module, after a decompile.

-- Brendan Reynolds

'~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*