Need help identifying an Error message my work computer keeps gett

K

Kim@work

My company has recently started using Mas90 with Microsoft Access 2003. We
keep getting the following error message whenever we leave Mas90 to go into
Access....

VBScript Error Number.... -2147467259
Description.............. [Microsoft][ODBC Microsoft Access Driver] Cannot
open database '(unknown)'. It may not be a database that your application
recognizes, or the file may be corrupt.
Line 58.............. (objconn.Open "DRIVER={Microsoft Access Driver
(*.mdb)};"&
strConnString
column............... 0

After the error occurs everybody has to get out of the Access program so
that the Admin. can compact & repair. After this has been done everybody can
get back into the program but in a matter of mins. to a couple of hrs. we
will get the message again. Can anyone tell me what is causing this and how
can we fix it. Thank You.
 
K

Kim@work

Joseph Meehan said:
Kim@work said:
My company has recently started using Mas90 with Microsoft Access
2003. We keep getting the following error message whenever we leave
Mas90 to go into Access....

VBScript Error Number.... -2147467259
Description.............. [Microsoft][ODBC Microsoft Access Driver]
Cannot open database '(unknown)'. It may not be a database that your
application recognizes, or the file may be corrupt.
Line 58.............. (objconn.Open "DRIVER={Microsoft Access Driver
(*.mdb)};"&
strConnString
column............... 0

After the error occurs everybody has to get out of the Access program
so that the Admin. can compact & repair. After this has been done
everybody can get back into the program but in a matter of mins. to a
couple of hrs. we will get the message again. Can anyone tell me
what is causing this and how can we fix it. Thank You.
Click to expand...

That seems like a lot of errors to me. I suspect the network first.
What kind of network are you using.

In addition you may want to review the database design. First is it set
up as a split with a back end on the server and all users having their own
front end on their own machine? Are all the queries and static tables,
forms and reports needed by the users located on their machines or are they
on the server?
Click to expand...
Everything is on our server. We have tables/reports were more than one
person needs to work from at the same time.
 
Top