add records to a table in ADP

[spieters via AccessMonster.com]

L.S.

I've created a form using the SQL table I'm connected to. However, I cannot
add any records to the table. Is there a special way to do that in ADP?

Stella

 

[CyberDwarf]

Hi Stella
Have you used a view to grab the data - if so, make sure you can write back
to the view. If not, are you getting error messages?
HTH
Steve

 

[Sylvain Lafontaine]

The first thing to check would be to make sure that a primary key has been
defined for this table. If this doesn't work, add a timestamp to the table.

Don't forget to refresh (F5 or View | Refresh command) both the tables and
the SP/Views/Functions database windows when making change to a table.
Instead of using F5, you can also restart Access to make sure that
everything is up to date locally.

 

[spieters via AccessMonster.com]

The first thing to check would be to make sure that a primary key has been
defined for this table. If this doesn't work, add a timestamp to the table.

Don't forget to refresh (F5 or View | Refresh command) both the tables and
the SP/Views/Functions database windows when making change to a table.
Instead of using F5, you can also restart Access to make sure that
everything is up to date locally.

L.S.

[quoted text clipped - 3 lines]

Stella

Sylvain,

Thank you very much, it works!! You're Great!!