add records to a table in ADP

  • Thread starter Thread starter spieters via AccessMonster.com
  • Start date Start date
S

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
 
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
 
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.
 
Sylvain said:
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.
Click to expand...
[quoted text clipped - 3 lines]
Stella
Click to expand...
Click to expand...

Sylvain,

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