"Susan" <Su***@discussions.microsoft.com> wrote in message
news:7B0FA2D0-053C-4ABA-9B33-82DA3F7D1B4D@microsoft.com...
>I need to link to a table in an Access 2007 database on another machine in
> our network from the Access 2007 database I'm using.  This worked fine in
> 2003, but now when I try to edit data in the linked table I get the
> message:
> "this recordset is not updatable"
>
> I can link to the table and see the data, I just can't edit it.  I tried
> to
> add it to my trusted locations and I get the message:
> "the path you have entered cannot be used as a trusted location for
> security
> reasons"
>
> Please advise as to how to gain permission to update this data.
> Thanks!
> Susan

"Arvin Meyer MVP" wrote:

> You need to split your database and put the front-end on each PC in a
> Trusted Location on that PC. Put the back-end on a server or PC accessible
> by all.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "Susan" <Su***@discussions.microsoft.com> wrote in message
> news:7B0FA2D0-053C-4ABA-9B33-82DA3F7D1B4D@microsoft.com...
> >I need to link to a table in an Access 2007 database on another machine in
> > our network from the Access 2007 database I'm using.  This worked fine in
> > 2003, but now when I try to edit data in the linked table I get the
> > message:
> > "this recordset is not updatable"
> >
> > I can link to the table and see the data, I just can't edit it.  I tried
> > to
> > add it to my trusted locations and I get the message:
> > "the path you have entered cannot be used as a trusted location for
> > security
> > reasons"
> >
> > Please advise as to how to gain permission to update this data.
> > Thanks!
> > Susan
>
>
>

"Susan" wrote:

> That is how I have it set up.  There are two tables I need to link to...one
> is on the SQL server and the other is an Access2007 table on another PC that
> is shared to three specific users.  From any of these three users, I can link
> to the table and view the data, but cannot make edits!  I can edit data from
> the SQL tables and Access2007 tables linked from the main file server just
> fine.  I have added this PC with this particular table to the trusted
> locations on these three user's machines, but still can't edit the data!  I
> feel like I'm close, but maybe have a setting wrong somewhere.  Any
> suggestions?
>
> Thanks for the help!!
>
> "Arvin Meyer MVP" wrote:
>
> > You need to split your database and put the front-end on each PC in a
> > Trusted Location on that PC. Put the back-end on a server or PC accessible
> > by all.
> > --
> > Arvin Meyer, MCP, MVP
> > http://www.datastrat.com
> > http://www.mvps.org/access
> > http://www.accessmvp.com
> >
> >
> > "Susan" <Su***@discussions.microsoft.com> wrote in message
> > news:7B0FA2D0-053C-4ABA-9B33-82DA3F7D1B4D@microsoft.com...
> > >I need to link to a table in an Access 2007 database on another machine in
> > > our network from the Access 2007 database I'm using.  This worked fine in
> > > 2003, but now when I try to edit data in the linked table I get the
> > > message:
> > > "this recordset is not updatable"
> > >
> > > I can link to the table and see the data, I just can't edit it.  I tried
> > > to
> > > add it to my trusted locations and I get the message:
> > > "the path you have entered cannot be used as a trusted location for
> > > security
> > > reasons"
> > >
> > > Please advise as to how to gain permission to update this data.
> > > Thanks!
> > > Susan
> >
> >
> >