Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anybody tell me what this error means?

"You can't open the table 'tblTradelistingGroup1' for modification.

A query or firm bound to the table is open, you may have permission to open
this table in Design view, or another view, or another user has the table
open.
Do you want to open this table as read-only?

If you have opened a query or form bound to this table, close it, and then
try again to open the table in Design view.
____________________________________________________________________

No one else is in this table... My security settings must be screwed up.
 
Do you have a query open that is using that table?
Do you have a form open that is using that table?
Do you have a report open that is using that table?

That is normally the place I see this "Error" message.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Do you have a query open that is using that table? No.
Do you have a form open that is using that table? No.
Do you have a report open that is using that table? No.
Click to expand...
I have no idea what this error means because I do everything they tell me to
do and it still shows up.
 
So what you are saying is when you first open the database with no menu or
anything and you attempt to open this table in design mode you get this
message? As John says this USUALLY only happens when you have one of the
three items open. The ONLY other reason I can think of would be first sign
of corruption. Have you tried importing all your objects to new database
and seeing if the problem persists?
 
What about all of my queries and reports? I have 8 tables and this problem
only persists in 1 of them. The only change that I think I may have screwed
up is the Security. I set up the security so that users would only be able
to view the tables, not modify. The system may have me set up as a user. I
don't know how to access the Administrator account so that I can reassign my
user functions. Do you think that this may have been the problem?
 
Hmmm, you didn't mention that before. Yes, that may be the problem. I'm
going to assume you did not make a back-up before changing the security
settings. I don't know enough about Access security to tell you how to fix
it.
 
Back
Top