can't insert new records

  • Thread starter Thread starter newfie912
  • Start date Start date
N

newfie912

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
 
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.
 
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
 
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,

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

thanks,

don
 
JK,

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

thanks,

don
 
Did you try setting the RECORDSET TYPE in each of the forms to Dynaset
(Inconsistent Updates)?
 
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
 
Back
Top