on 04-19-2019 11:51 PM
I have a situation where I am using an adsdataadapter to select data from a VFP table, using two indexes
SELECT * from myTable order by [col1], [col2]
If I only use one or the other of the indexes, the adapter.fill command concludes successfully, however when I try to use both indexes at once, I get the following error:
Error 7039: File attempted to be opened for exclusive use, but it was already open by another user.
The connection string specifies shared access, the table is not open elsewhere, it is just the inclusion of two or more indexes in the select statement that triggers the error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.