Re: database gets placed in a State that prevents it from being opened

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You might need to issue a requery before accessing the data on the 2nd
machine.

"TADropik" <TADropik@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:316906FA-EAD4-41AB-876C-27703D738E53@xxxxxxxxxxxxxxxx
> i'm using the Timer Event in a Form to run a Query by setting
> TimerInterval
> property. The query fills a table with data that needs to be accessed
> through
> another Access database that links to that table. After the Query executes
> the other Access database gets the following error while trying to read
> the
> table:
>
> "The database has been placed in a state by user 'Admin' on machine
> '#######' that prevents it from being
> opened or locked."
>
> I hope I explained that clearly...
>
> Any suggestions????
>


.

Relevant Pages

  • Table.Clear() does not
    ... I have an Access Database that I'm connected to. ... I want to requery the database and ... display only the pertinent fields. ... Here is a portion of the code that does the query. ...
    (microsoft.public.data.oledb)
  • database gets placed in a State that prevents it from being opened
    ... i'm using the Timer Event in a Form to run a Query by setting TimerInterval ... another Access database that links to that table. ... "The database has been placed in a state by user 'Admin' on machine ...
    (microsoft.public.access.queries)
  • ~~~~~~~~~~~~~ MS ACCESS ~~~~~~~~~~~~~
    ... accdbman ms access database query table ... age bracket ms access report ... buy ms access download full version ...
    (comp.mail.pine)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Current Row or similar for query-based combo box
    ... The requery solution is working very well. ... You can use the form's current event to force the combobox to be requeried. ... form.in my combobox query I am able to get the intended result. ... rows that need other values to display will suddenly display blank. ...
    (microsoft.public.access.queries)