Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error 2147467259 - vbscript queries on Access DB, client-side

Status
Not open for further replies.

ecompa

MIS
Jan 22, 2005
14
BE
HI,

I am working on a tool to share data in my department.
The tool is working fine for me and some colleagues, but for others it is not working. The error code is -2147467259, and the description mentions that the file is already opened exclusively by another user (which is not the case).
The interface is in HTML, using VBscript connecting to Access 2003, working in a terminal server environment.
All users have a change access to the folder where code and data are located. Users that cannot use the tool don't have MS Access in their profile.

Here is one of the connectionstring I used. I tried ODBC connection, with or without password, among others. I didn't try to use a worgroup file but really not sure it would help anyway.
Code:
Set conDB = CreateObject("ADODB.Connection")
dbStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strReadPath & "Data\LastMonth.mdb; Jet Oledb:Database Password=dashboard;" 
conDB.Open dbStr
Does someone have an idea on what could be the cause of the problem ? Any suggestion is welcome... I am a bit lost[mad]...
Regards
E.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top