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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Query permission error

Status
Not open for further replies.

paulcedarhill

Technical User
Mar 22, 2004
46
US
We share on the network an excel 2000 version 9.0 file that uses MS Query within the workbook.

We have protected write permissions using the tools/options/password to modify command.

When ever a user has the file open with the password to modify only the file creator can access the file. All others get a jet ODBC driver error that someone else has exclusive use of the file.

Is there a work around?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top