Home > Archive > Visual Basic Crystal Reports > June 2005 > Error with Access VBA - DAO Error Code 0xe96
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error with Access VBA - DAO Error Code 0xe96
|
|
|
| Hi,
I have a Crystal Report that access an Access database. I pass some criteria
to a query and then Access prints the Crystal report with the parameters
passed to some textboxes (to change headers) and with the information
summarized as expected.
The problem is that occasionally I get the following error:
Run-time error '-2147189176 (80047e48)':
Logon failed.
Details: DAO Error Code: 0xe96
Source: DAO.Workspace
Description: The database has been placed in a state by user 'Admin' on
machine 'xxx' that prevents it from being opened or locked.
I have tried connecting to the Access database through ODBC and OLE DB (that
seems to give me less errors). I understand that if I have a form or
something in design mode open, it doesn't allow access, but that is not the
case.
It seems to occur most after I make a change to some VBA code. I run the
code again and even thought I've closed the editing windows, I still get the
error.
Once I get the error, it does not allow me to open the report again. If I
close Access and reopen, I can then view or print the report from Access. It
appears that something is getting stuck, but I don't know what. I set all my
references to Nothing.
Also, I can connect to the database by using another database and that seems
to work OK, but it isn't how it should work and defeats the purpose of what
I am trying to achieve.
Thanks for the help.
| |
|
| Hello again,
I think I found the solution. After I make a change to the VBA code, I
compiled it and then saved the module.
So far, that seems to work and I haven't had any additional errors.
"Gummy" <gumbatman@hotmail.com> wrote in message
news:119uppfclh0va72@corp.supernews.com...
> Hi,
>
> I have a Crystal Report that access an Access database. I pass some
criteria
> to a query and then Access prints the Crystal report with the parameters
> passed to some textboxes (to change headers) and with the information
> summarized as expected.
>
> The problem is that occasionally I get the following error:
> Run-time error '-2147189176 (80047e48)':
> Logon failed.
> Details: DAO Error Code: 0xe96
> Source: DAO.Workspace
> Description: The database has been placed in a state by user 'Admin' on
> machine 'xxx' that prevents it from being opened or locked.
>
> I have tried connecting to the Access database through ODBC and OLE DB
(that
> seems to give me less errors). I understand that if I have a form or
> something in design mode open, it doesn't allow access, but that is not
the
> case.
>
> It seems to occur most after I make a change to some VBA code. I run the
> code again and even thought I've closed the editing windows, I still get
the
> error.
>
> Once I get the error, it does not allow me to open the report again. If I
> close Access and reopen, I can then view or print the report from Access.
It
> appears that something is getting stuck, but I don't know what. I set all
my
> references to Nothing.
>
> Also, I can connect to the database by using another database and that
seems
> to work OK, but it isn't how it should work and defeats the purpose of
what
> I am trying to achieve.
>
> Thanks for the help.
>
>
>
>
>
|
|
|
|
|