Problem With Form/Subform

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Access 2003 desktop application .......

When I try to open a form/subform I get the message:
"Could not use <name of backend file>; file already in use."
What could be causing this message to appear?

If I click OK, the form opens with just a blank space for the subform. If I
remove the control source from the subform control, the main form opens
correctly. I can open the subform by itself with no problem.

I have rebuilt the form/subform and get the same message.

Thanks for any ideas!

Steve
 
I've seen this happen when the "locking" file wasn't deleted by the
application after shut down. It could happen if the application locked up
and you used the Task Manager to shut it down.

If you open Windows Explorer and navigate to the location of the database
file, if neither you nor any other user is using the app, you shouldn't have
a "locking" file (NOTE: earlier versions of Access did NOT clean up their
locking files ... and you haven't described which version you are using...).

If someone is using the app, and you try to delete the locking file, I don't
believe Access will allow that.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Arno

Are you convinced beyond reasonable doubt that this "Steve" is the "Steve"
you think s/he is?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Jeff Boyce said:
Are you convinced beyond reasonable doubt that
this "Steve" is the "Steve" you think s/he is?
Click to expand...

To be convinced, Jeff, compare the phony e-mail with others of "that
Steve's" postings.

Larry
 
Steve said:
Thanks for any ideas!
Click to expand...

A fairly easy problem to solve. My suggestion is to contact PC Datasheet,
*the* Access "resource". His fees are very reasonable and modest. None of
the dimwits here can help that's for sure.
 
StopThisAdvertising said:
he thinks he can ask free questions to solve the payed work he got here...
Click to expand...

If he gets any paid work from here I'll show my arse in Burton's window ;)
 
Back
Top