I have a small Access database used by a few of our users. It uses
Access 2003 as a front end with a few local tables and a MS SQL server
database as the backend for two tables. For some reason, the user
can't insert new records when using any parts of this database that use
the SQL Server tables. The ">*" record navigation button is grayed out
and if I go to the Insert menu, "New Record" is also grayed out. I
have checked the Access security settings (everything is allowed) and I
have relinked the SQL Server tables, but to no avail.

Does anyone have any suggestions?

thanks,

don

Don,
did you check the form properties?

Allow additions = True
or In VB, On Current,On Open etc.

Just a thought

Regards/JK

"newfie912" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a small Access database used by a few of our users. It uses
> Access 2003 as a front end with a few local tables and a MS SQL server
> database as the backend for two tables. For some reason, the user
> can't insert new records when using any parts of this database that use
> the SQL Server tables. The ">*" record navigation button is grayed out
> and if I go to the Insert menu, "New Record" is also grayed out. I
> have checked the Access security settings (everything is allowed) and I
> have relinked the SQL Server tables, but to no avail.
>
> Does anyone have any suggestions?
>
> thanks,
>
> don
>

You need to check your permissions on the SQL side. The Access permissions
only apply to the front end, but if the dba has not given you write
permissions on the SQL side there's nothing you can do on the Access side to
change it.
--
Kevin Backmann


"newfie912" wrote:

> I have a small Access database used by a few of our users. It uses
> Access 2003 as a front end with a few local tables and a MS SQL server
> database as the backend for two tables. For some reason, the user
> can't insert new records when using any parts of this database that use
> the SQL Server tables. The ">*" record navigation button is grayed out
> and if I go to the Insert menu, "New Record" is also grayed out. I
> have checked the Access security settings (everything is allowed) and I
> have relinked the SQL Server tables, but to no avail.
>
> Does anyone have any suggestions?
>
> thanks,
>
> don
>
>

We're all using the same username and password when we connect to the
SQL Server tables and it works for others, but not for this one
machine.

Also, if I bring a copy of the database to my computer, it works fine.

Any other thoughts?

thanks,

don
Kevin B wrote:
> You need to check your permissions on the SQL side. The Access permissions
> only apply to the front end, but if the dba has not given you write
> permissions on the SQL side there's nothing you can do on the Access side to
> change it.
> --
> Kevin Backmann
>
>
> "newfie912" wrote:
>
> > I have a small Access database used by a few of our users. It uses
> > Access 2003 as a front end with a few local tables and a MS SQL server
> > database as the backend for two tables. For some reason, the user
> > can't insert new records when using any parts of this database that use
> > the SQL Server tables. The ">*" record navigation button is grayed out
> > and if I go to the Insert menu, "New Record" is also grayed out. I
> > have checked the Access security settings (everything is allowed) and I
> > have relinked the SQL Server tables, but to no avail.
> >
> > Does anyone have any suggestions?
> >
> > thanks,
> >
> > don
> >
> >

Does everyone have local copy of the front-end? If multiple users are
opening the same front-end file off the server that could be the issue.
--
Kevin Backmann


"newfie912" wrote:

> We're all using the same username and password when we connect to the
> SQL Server tables and it works for others, but not for this one
> machine.
>
> Also, if I bring a copy of the database to my computer, it works fine.
>
> Any other thoughts?
>
> thanks,
>
> don
> Kevin B wrote:
> > You need to check your permissions on the SQL side. The Access permissions
> > only apply to the front end, but if the dba has not given you write
> > permissions on the SQL side there's nothing you can do on the Access side to
> > change it.
> > --
> > Kevin Backmann
> >
> >
> > "newfie912" wrote:
> >
> > > I have a small Access database used by a few of our users. It uses
> > > Access 2003 as a front end with a few local tables and a MS SQL server
> > > database as the backend for two tables. For some reason, the user
> > > can't insert new records when using any parts of this database that use
> > > the SQL Server tables. The ">*" record navigation button is grayed out
> > > and if I go to the Insert menu, "New Record" is also grayed out. I
> > > have checked the Access security settings (everything is allowed) and I
> > > have relinked the SQL Server tables, but to no avail.
> > >
> > > Does anyone have any suggestions?
> > >
> > > thanks,
> > >
> > > don
> > >
> > >
>
>

Kevin,

Yes, everyone has their own copy of the front end on their local
machine.

thanks,

don


Kevin B wrote:
> Does everyone have local copy of the front-end? If multiple users are
> opening the same front-end file off the server that could be the issue.
> --
> Kevin Backmann
>
>
> "newfie912" wrote:
>
> > We're all using the same username and password when we connect to the
> > SQL Server tables and it works for others, but not for this one
> > machine.
> >
> > Also, if I bring a copy of the database to my computer, it works fine.
> >
> > Any other thoughts?
> >
> > thanks,
> >
> > don
> > Kevin B wrote:
> > > You need to check your permissions on the SQL side. The Access permissions
> > > only apply to the front end, but if the dba has not given you write
> > > permissions on the SQL side there's nothing you can do on the Access side to
> > > change it.
> > > --
> > > Kevin Backmann
> > >
> > >
> > > "newfie912" wrote:
> > >
> > > > I have a small Access database used by a few of our users. It uses
> > > > Access 2003 as a front end with a few local tables and a MS SQL server
> > > > database as the backend for two tables. For some reason, the user
> > > > can't insert new records when using any parts of this database that use
> > > > the SQL Server tables. The ">*" record navigation button is grayed out
> > > > and if I go to the Insert menu, "New Record" is also grayed out. I
> > > > have checked the Access security settings (everything is allowed) and I
> > > > have relinked the SQL Server tables, but to no avail.
> > > >
> > > > Does anyone have any suggestions?
> > > >
> > > > thanks,
> > > >
> > > > don
> > > >
> > > >
> >
> >

JK,

no forms or VB code involved. they just work from a few prepared
queries.

thanks,

don


JK wrote:
> Don,
> did you check the form properties?
>
> Allow additions = True
> or In VB, On Current,On Open etc.
>
> Just a thought
>
> Regards/JK
>
> "newfie912" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have a small Access database used by a few of our users. It uses
> > Access 2003 as a front end with a few local tables and a MS SQL server
> > database as the backend for two tables. For some reason, the user
> > can't insert new records when using any parts of this database that use
> > the SQL Server tables. The ">*" record navigation button is grayed out
> > and if I go to the Insert menu, "New Record" is also grayed out. I
> > have checked the Access security settings (everything is allowed) and I
> > have relinked the SQL Server tables, but to no avail.
> >
> > Does anyone have any suggestions?
> >
> > thanks,
> >
> > don
> >

Did you try setting the RECORDSET TYPE in each of the forms to Dynaset
(Inconsistent Updates)?
--
Kevin Backmann


"newfie912" wrote:

> Kevin,
>
> Yes, everyone has their own copy of the front end on their local
> machine.
>
> thanks,
>
> don
>
>
> Kevin B wrote:
> > Does everyone have local copy of the front-end? If multiple users are
> > opening the same front-end file off the server that could be the issue.
> > --
> > Kevin Backmann
> >
> >
> > "newfie912" wrote:
> >
> > > We're all using the same username and password when we connect to the
> > > SQL Server tables and it works for others, but not for this one
> > > machine.
> > >
> > > Also, if I bring a copy of the database to my computer, it works fine.
> > >
> > > Any other thoughts?
> > >
> > > thanks,
> > >
> > > don
> > > Kevin B wrote:
> > > > You need to check your permissions on the SQL side. The Access permissions
> > > > only apply to the front end, but if the dba has not given you write
> > > > permissions on the SQL side there's nothing you can do on the Access side to
> > > > change it.
> > > > --
> > > > Kevin Backmann
> > > >
> > > >
> > > > "newfie912" wrote:
> > > >
> > > > > I have a small Access database used by a few of our users. It uses
> > > > > Access 2003 as a front end with a few local tables and a MS SQL server
> > > > > database as the backend for two tables. For some reason, the user
> > > > > can't insert new records when using any parts of this database that use
> > > > > the SQL Server tables. The ">*" record navigation button is grayed out
> > > > > and if I go to the Insert menu, "New Record" is also grayed out. I
> > > > > have checked the Access security settings (everything is allowed) and I
> > > > > have relinked the SQL Server tables, but to no avail.
> > > > >
> > > > > Does anyone have any suggestions?
> > > > >
> > > > > thanks,
> > > > >
> > > > > don
> > > > >
> > > > >
> > >
> > >
>
>

this database is not using any forms.

Mostly they use some prepared queries. The one query that was the
problem would open and display the selected data, but would not allow
the entry of new records. I checked the query and it was just
selecting certain fields from a single back-end SQL Server table. I
tested opening that specific table on the SQL Server and I could add
new records that way. I went back to the query, added the primary key
field from the SQL Server table, and now it let's me add new records.
Not sure if that is the best fix, but it works for me and we're happy.
thanks to everyone for your input and assistance. I'm gonna call this
one complete.

don


Kevin B wrote:
> Did you try setting the RECORDSET TYPE in each of the forms to Dynaset
> (Inconsistent Updates)?
> --
> Kevin Backmann
>
>
> "newfie912" wrote:
>
> > Kevin,
> >
> > Yes, everyone has their own copy of the front end on their local
> > machine.
> >
> > thanks,
> >
> > don
> >
> >
> > Kevin B wrote:
> > > Does everyone have local copy of the front-end? If multiple users are
> > > opening the same front-end file off the server that could be the issue.
> > > --
> > > Kevin Backmann
> > >
> > >
> > > "newfie912" wrote:
> > >
> > > > We're all using the same username and password when we connect to the
> > > > SQL Server tables and it works for others, but not for this one
> > > > machine.
> > > >
> > > > Also, if I bring a copy of the database to my computer, it works fine.
> > > >
> > > > Any other thoughts?
> > > >
> > > > thanks,
> > > >
> > > > don
> > > > Kevin B wrote:
> > > > > You need to check your permissions on the SQL side. The Access permissions
> > > > > only apply to the front end, but if the dba has not given you write
> > > > > permissions on the SQL side there's nothing you can do on the Access side to
> > > > > change it.
> > > > > --
> > > > > Kevin Backmann
> > > > >
> > > > >
> > > > > "newfie912" wrote:
> > > > >
> > > > > > I have a small Access database used by a few of our users. It uses
> > > > > > Access 2003 as a front end with a few local tables and a MS SQL server
> > > > > > database as the backend for two tables. For some reason, the user
> > > > > > can't insert new records when using any parts of this database that use
> > > > > > the SQL Server tables. The ">*" record navigation button is grayed out
> > > > > > and if I go to the Insert menu, "New Record" is also grayed out. I
> > > > > > have checked the Access security settings (everything is allowed) and I
> > > > > > have relinked the SQL Server tables, but to no avail.
> > > > > >
> > > > > > Does anyone have any suggestions?
> > > > > >
> > > > > > thanks,
> > > > > >
> > > > > > don
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >