My db has a csv linked file how can I share with others (1 Viewer)

[Sonya810]

My Access db has a csv linked file for updating the csv file in my documents folder. When others try to open it they get an error that the file is located in my documents folder. I split the db and changed the tables back to csv linked file. It works for me, but not so much for others.

 

[arnelgp]

i am not sure if it is possible for multi-user Editing same csv file.
you can import this csv into a Table (if it has less than 255 columns).
then everyone can edit this table and ultimately Export as csv.

on sharing you need to Create a Shared folder and add User Everyone to it.
Everyone should have all Rights on the shared folder.
Split your db and put the BE to the Shared folder.
Relink all your tables (in FE) again, this time use UNC path, ei,

\\yourComputerName\SharedFolder\BEName.accdb

make a copy of the FE and give to your users.

 

[Sonya810]

i am not sure if it is possible for multi-user Editing same csv file.
you can import this csv into a Table (if it has less than 255 columns).
then everyone can edit this table and ultimately Export as csv.

on sharing you need to Create a Shared folder and add User Everyone to it.
Everyone should have all Rights on the shared folder.
Split your db and put the BE to the Shared folder.
Relink all your tables (in FE) again, this time use UNC path, ei,

\\yourComputerName\SharedFolder\BEName.accdb

make a copy of the FE and give to your users.

Thank you. Let me try this

 

[The_Doc_Man]

You have to remember that straight-up Excel doesn't like to share files for modification. Having said that, consider this:

Edit Linked Excel Data in Access

One of the main advantages of Access is its ability to read and edit linked data files from a wide variety of sources. Many developers are therefore surprised that linked Excel, CSV and other text files are READ ONLY. In fact that wasn't always the case. Until 2002, all it was possible to edit...

www.access-programmers.co.uk