Linked Data is Read Only

[gregorg]

Hi i posted about spliting a database, which i did, it was to alllow more than one user to use the database at the same time. I have 1 machine (#1) with the tables only, and on the same machine a front end for the data with linked tables.

On the other machine (#2) i have a front end with linked tables to the tables only database on machine #1.

The front end on machine #1 works fine. On machine #2 the front end can see the data, but the data is read only ? I have put the tables only program on machine #1 in the public directoy and shared it, but to the front end on machine 2 it is still a read only recordset().

Can anyone give advice on this ?

 

[DCrake]

Is this the case if the machine is the only one who has the front end open. Coulkd be that the users rights need reviewing. Or the back end is set to open exclusively.

David

 

[gregorg]

ok i can look into this, just have never done it before, will look at sharing options, will look at it if only 1 front end or 2 are open at the same time, thanks