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!

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

.DBF permission

Status
Not open for further replies.
jlschulte

jlschulte

Programmer
Nov 1, 2001
11
0
0
US
I have worked on a program that queries a .dbf. I have the program working well on my workstation, but when I try using it on other machines, I get an error that the user does not have permission to access the .dbf or the .dbf is not shareable. The .dbf is marked read only, but that is the only restriction accordingto the network.

This is the related code:

cnn1.Open ("Provider=MSDASQL.1;Driver={Microsoft dBase Driver (*.dbf)};FIL=dBase 5.0;FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\dBASE Files (not sharable).dsn;")

rs1.Open strQuery, cnn1, adOpenKeyset, adLockOptimistic, adCmdText

The error occurs on the rs1.Open line.

Any ideas?

Thanks

Jeff
 
Status
Not open for further replies.

Similar threads

Auguy
  • Locked
  • Question
Display Files In Folders the User Does Not Have Permission to View
Replies
2
Views
38
Auguy
Auguy
k. Ahnung
  • Locked
  • Question
Check if user has write permissions for a folder
Replies
1
Views
62
softhemc
softhemc
tmar
  • Locked
  • Question
Error trying to set directory permissions
Replies
1
Views
40
tmar
tmar
tmar
  • Locked
  • Question
Removing permissions to see a file list
Replies
0
Views
27
tmar
tmar
normalice
  • Locked
  • Question
msaccess error: could not create no modify design permission for table
Replies
1
Views
16
genomon
genomon

Part and Inventory Search

Sponsor

Back
Top