Tuesday, February 14, 2012

Can not write to a SQL table from Access 2003

I've read through many posts regarding this type of issue and all posts were
relevant but not exactly my problem.
I use Access 2003 and I have a simple linked table to a Sql2000 DB table, I
then have a form that I can use to view/amend data directly on the sql
table. However, I then have another table in the same DB that I have created
a form to view/amend the data but this table does not allow me to amend, I
can only view.
Both tables are in the same DB, and I am logged in as the same user. As far
as I can see both Tables have the same permissions. The only difference is
the table that I can not amend was created by performing a DTS Import. I
have ran the profiler and found that when accessing the table that fails to
amend it only passes a SELECT statement to the server, the table that does
amend passes a EXEC SP_PREPEXEC & SP_EXECUTESQL, so I'm confused if the
problem is in Access or on the Table in SQL. Any Help would be very much
appreciated.
RobSORRY, SORRY, SORRY. I've just realised what was happening, bit embarrassed
to say. I never had a primary key.
All sorted.
"Rob" <rbotterill@.hspg.com> wrote in message
news:uhZHI6lHFHA.3484@.TK2MSFTNGP12.phx.gbl...
> I've read through many posts regarding this type of issue and all posts
> were relevant but not exactly my problem.
> I use Access 2003 and I have a simple linked table to a Sql2000 DB table,
> I then have a form that I can use to view/amend data directly on the sql
> table. However, I then have another table in the same DB that I have
> created a form to view/amend the data but this table does not allow me to
> amend, I can only view.
> Both tables are in the same DB, and I am logged in as the same user. As
> far as I can see both Tables have the same permissions. The only
> difference is the table that I can not amend was created by performing a
> DTS Import. I have ran the profiler and found that when accessing the
> table that fails to amend it only passes a SELECT statement to the server,
> the table that does amend passes a EXEC SP_PREPEXEC & SP_EXECUTESQL, so
> I'm confused if the problem is in Access or on the Table in SQL. Any Help
> would be very much appreciated.
> Rob
>|||"Rob" <rbotterill@.hspg.com> wrote in message
news:OLe0EknHFHA.2552@.TK2MSFTNGP10.phx.gbl...
> SORRY, SORRY, SORRY. I've just realised what was happening, bit
embarrassed
> to say. I never had a primary key.
Don't be sorry, this is a common mistake... you may also want to add a
column of timestamp as well.
http://support.microsoft.com/defaul...kb;en-us;208842
Steve

No comments:

Post a Comment