Linked Tables Across Network Are Read Only

[Tsango]

I have a main computer where my Access Application runs but I also want other computers with the application runnign on it but linked to the backend database on the main computer, however when linking to the tables they are only read only.

How do you link to tables accross the network so you can read and writ e to them?

 

[ghudson]

Sounds like the users to not have full file permissions [read/edit/delete] to the back end where the table are located.

 

[Tsango]

Sounds like the users to not have full file permissions [read/edit/delete] to the back end where the table are located.

That would seem logical.

I have not done anything on Security or Permissions within Access yet. It's unchartered territory so any suggestions on whet to look for?

 

[ghudson]

Your network [system] folks would be the ones who determine what file rights a user has on a network directory. You will need to partner with them.

 

[Tsango]

Your network [system] folks would be the ones who determine what file rights a user has on a network directory. You will need to partner with them.

Thanks for your reply. You must misunderstand my set up. I have 2 PC's on my desk networked together using a router. There is just me on the network...

 

[Tsango]

Your network [system] folks would be the ones who determine what file rights a user has on a network directory. You will need to partner with them.

Ignore me!!

I was looking for some permissions that needed to be set within Access.

A simple tick of the box labeld "Allow users to change my files" under the sharing and security properties of the sharded folder sorted it out....!!

How embarassing