Messages and desing view

[Senior Sage]

I have been asked to modify a database designed by someone else who is no
longer contactable. I have two main problems:

1. Every time a query is opened an informational message appears "The
setting for the ListRows property must be 1 through 255" umpteen times,
approximating to the number of columns in the query. How do I supress this?

2. Many objects cannot be opened in design view. When selected in the
navigation pane the design view icons remain grayed out. Right clicking any
object fails to open any context menu. Tables, select queries and some forms
can be opened in datasheet view and then design view but not directly.

This is a an mdb database which I am looking at in Access 2007. I have been
combing permissions, trusted areas and all the settings ( front end and back
end) for something that might free things up without success.

Ideas please

 

[Jerry Whittle]

For a second there I thought that it might be an MDE file but you say that
you can open some forms in design view.

Sounds to me like the database is either (1) locked down with something like
User Level Security, or (2) corrupt. If you need to log on as a particular
user, it MIGHT be security causing problems. However, I'm betting on
corruption.

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[KARL DEWEY]

1. Every time a query is opened...
Are you opening the query direct or opening a form that uses the query? If
form does it have any combo boxes? If so, what is the List Rows set at?

 

[Senior Sage]

Thanks for your ideas. No logon seems to be involved in the copy of the
database I have been sent. I will enquire about the availability of old back
up files before embarking on a trawl through your recommended reading on
corruption.

 

[Senior Sage]

I will investigate any combo boxes. However, the situation also applies to
any new queries I design. You just can't get back in to modify any action
query.

 

[Jeanette Cunningham]

Is this database in a trusted location?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Senior Sage]

Yes and all the subfolders. I have been caught on that one before.

I'm still working on it but it is very early am so I will sleep on it for a
while.

Thanks for replying.