something strange

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

Hi,
I have this - hard to explain - problem I never encountered before.

I have this report, based upon a query that runs nicely when I clik the
reports name in the window containing all the reports in the current
project.

When I create a form with a pushbutton than runs the report upon
clicking, whe I do so, directly after opening the form, I get an
errormessage saying thet the database engine isn't able to lock a table
the query is based upon. The table seems to be in use by another process

Anybody, any idea?
Thanks
JP
 
Is the form you just created bound to the same table?
If so make sure that 'Default Record Locking' is not set to 'All Records'
(options / advanced in database view).

TonyT..
 
On the main form there are 3 listboxen... one uses the same table...

Did what you suggested... same errormessage

JP


TonyT schreef:
 
Did you try it on 'No Locks' and still get the same result?

With no locks you should have limitless ability to open queries, forms etc
unhindered.

Compile your vba, then try a compact & repair, if still no joy can you post
the On_Click code for the offending command button and the SQL for the query
too.

TonyT..
 
Back
Top