HELP! MS Access Sharing

[webappguru]

What is the best way to share an MS Access Database. I keep getting "Operation Must be an Updateable Query"

In my vb.net code in the connection string I have specified the location on the network where the access database is located. //POS1/C/DB/myFile.mdb
I can read the data via the network, but it any pc tries to update it, it throws the error.

Is there something I need to do with record locking to prevent this? Should I just upgrade him to MSDE (it would involve changing every oledb connection to sql connection)

 

[levyuk]

If it is on a network share there might be permission problems. Check them first.

 

[webappguru]

Does access normally allow network sharing???

 

[jmcilhinney]

It sounds like you have read permission on the location but not write permission. Connecting to an Access database via a network is just like any other file operation to that same location. Can you edit a text file in the same folder?