Hi I have a problem with my access table - I am seeing the following error even though I am using this in a single user environment, don't have the dreaded .ldb file present and do not have anything else open!

'A query or form bound to the table is open, you do not have permission to open this table in design view, or another user has this table open'

Help! :eek:

do not have anything else open!

OK, what DO you have open?

I.e. are you looking at a table, a query, a form, or a report in order to see this error message?

I'll jump ahead. If you forgot that you have a startup form that stays open in the background (a not uncommon approach for some logging functions), that hidden form can have something open.

If you have a query that includes a subquery, depending on the type of query, the subquery can be the thing that is open.

If you have a form open, it might have a recordset open in a way that blocks itself.

BTW, you had BETTER have a .LDB if YOU are in the DB; it is not only there 'cause of sharing with users; it is there for YOU even in single-user environments, precisely to prevent cross-table locking. Did you by any chance DELETE a .LDB file just before you got this message?