dbase openrowset exclusive

[mterveen]

using the following text to open copies of .dbf files located on the server:

select distinct * from openrowset('Microsoft.Jet.OLEDB.4.0','DBASE III;database=" & serverdb3directory & "','select fld1, fld2 from db3table') "

however, now when i want to use the "live" versions of the .dbf files on the server the above statement bombs. i assume it is due to the statement wanting to open the dbase files exclusively.

anybody know the parameter to put in the openrowset to allow the statement to succeed, i.e. open dbase file as read only?

thanks for your time. (server is winnt4)

 

[mterveen]

tried a couple other options. set up a linked server in enterprise manager using microsoft.jet.oledb.4.0 as the provider and 'dbase III' as the provider string. using query analyzer this statement works:

select * from openquery(dbflink,'select * from dbtable')

however, if i open the dbf file up thru the application (and it is NOT opened exclusively) and run the above query again, QA tells me it "is already opened exclusively by another user, or you need permission to view its data."

however, i can go into ms access and open up a link to the table or even program an adodc control using the same provider and with a linked text box move through the table.

help anyone? pullleeaaassseee