Can you give a bit more context on what you're trying to do?
Are you using SQL (ORDER BY), Query Designer (Sort Order) or
the toolbar ascending/descending button or recordsets or
directly viewing the table or whatever?
The possible answers depend upon how you're trying to do it.
Thanks for your reply, I am using the toolbar button, incidentally this is
the first time I have come across this error(?) msg in the 5 or so years I
have being using Access.
Using the button when a form is open? Have you got some
other process going on when you click the button?
Transactions are usually used as a means to commit and/or
rollback a query in code. The error message implies that
there's something else happening when you click the button.
Either that or your database is corrupt - have you tried
compact/repairing it?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
