3051 Error on linked csv table for multiple users

[emzipoo4u]

I have an Access database which has a linked table to a CSV file.

Only one user can use this part of the database that links to the CSV - for other users we get the error 3051 - opened exclusively by another user. How can the csv file be a linked table with multiple users ? The query itself is set to no locks. :banghead:

 

[gemma-the-husky]

it can't, I think. why not import the csv to a table in your database. then it becomes multi user.

 

[emzipoo4u]

The csv updates each evening and is a file written from out POS software.

 

[spikepl]

So? Answer Dave's question.

 

[emzipoo4u]

As I said the csv file updates daily so importing directly isn't ideal as it creates another step in the process. No other option by the looks of things though so have to create an SSIS package that will run daily to update the data ?

 

[namliam]

Depends on where you want to store the CSV's data
You can just use Docmd.Transfertext in access VBA, or use SSIS (I wish I could) and store it in SQL server or somesort.