Help, Connection to Access Database

[Randy]

Hi,all
I met one problem of connecting Access database in asp.net web program.
I use ODBC link to Access, the connection string like
"PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS
Access;PageTimeout=5;UID=apiprogram"

while runing program, system prompt error: the workgoup file is missing
or open exculsive by anthor user.

My access database located in another server,if I copy the Access
database to my local place, the program run without problem, but now always
display above error.

Then what's the problem? Anyone could give me a hand? Thanks!

 

[Paul Clement]

¤ Hi,all
¤ I met one problem of connecting Access database in asp.net web program.
¤ I use ODBC link to Access, the connection string like
¤ "PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS
¤ Access;PageTimeout=5;UID=apiprogram"
¤
¤ while runing program, system prompt error: the workgoup file is missing
¤ or open exculsive by anthor user.
¤
¤ My access database located in another server,if I copy the Access
¤ database to my local place, the program run without problem, but now always
¤ display above error.
¤
¤ Then what's the problem? Anyone could give me a hand? Thanks!

Probably a security issue. The account under which your web app is running would require full
permissions to the folder where the Access database file is located.

I would also recommend using Jet OLEDB instead of the MS Access driver.

http://www.connectionstrings.com/?carrier=access


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Randy]

Paul,
My condition is:
my actual data stored in Progress database on server1, I use Access
database links to Progress database by linked table through ODBC manner,
Access database located on server2, then I run web application to read
data from Access database.

I tried to connect database using both Jet OLEDB and ODBC method.
For ODBC, it will not work while the databae located on another server,
and prompt "workgroup file is missing" error.
For Jet OLEDB, it works well when executing simple query, but failed
when doing complicated query, and prompt "ODBC call failed",

So, now neither of the above two link method do not works perfect.
I wonder, what shall I do?

 

[Paul Clement]

¤ Paul,
¤ My condition is:
¤ my actual data stored in Progress database on server1, I use Access
¤ database links to Progress database by linked table through ODBC manner,
¤ Access database located on server2, then I run web application to read
¤ data from Access database.
¤
¤ I tried to connect database using both Jet OLEDB and ODBC method.
¤ For ODBC, it will not work while the databae located on another server,
¤ and prompt "workgroup file is missing" error.
¤ For Jet OLEDB, it works well when executing simple query, but failed
¤ when doing complicated query, and prompt "ODBC call failed",
¤

Have you tried connecting to the Progress database directly instead of using an Access database?
It's possible that you are losing some capability by having Access act as the go-between.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Randy]

Paul,
No, I will not connect to Progress database directly, because besides
the actul data in Progress database, we will also use data stored in Access
database and built cross query from both linked Progress table and Access
table, so I have to link to Access database.
Then is it the problem of ODBC drive? If so, what shall I do?
If not, why the OleDB method does not work well?