We help IT Professionals succeed at work.

3262 or 3211 in a docmd.runsql

Peborgh
Peborgh asked
on
286 Views
Last Modified: 2012-06-21
Access 2002 (XP).

I am trying to sort out someone else's Access system and one of these errors occurs - not sure which but they both mean it could not lock the target table - I assume it would not need to lock the tables it is select-ing from... There is no-one else using the target table at the time. IS there a quick way to unlock a table when it has been left lying around locked and you don't know why?

Many thanks.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Hi Peborgh,
No. You cannot unlock a table - you have to remove the condition that is causing it to be locked.
In a single user situation this could be because the user has more than one form/query/table/report open at the same time.

Pete
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
The ACcess process may still be running from a previous corrupt instance and locking your file.

To delete any previous instances:

Close MS Access.
Use CTRL+ALT+DEL and select TASK MANAGER
Select PROCESS Tab.
RIGHT click and END PROCESS TREE for any instances of MSACCESS.EXE


Author

Commented:
I sorted it by creating an empty db and importing everything from the original problem db to it. That solved the problem but all sorts of other things stopped working that were ok in the orginal. Any guesses as to why this might be? I would think that if everything was copied over, it should work like the original...

peter
CERTIFIED EXPERT

Commented:
'all sorts of other things stopped working '

You have to be specific.
There is no general problem in importing from another db

Pete

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.