How to create a New Record

[ddtpmyra]

Im using MS SQL database and MS Access for the form and my tables are obviously link to the database. How can I make the Access or SQL to allow new record?

thanks!

[ck9663]

It depends on how you connected to your SQL Server from Access. It could be a built-in button or it might require a T-SQL execution.

Happy Coding!!!

~~ CK

[ddtpmyra]

Hi CK,

connection was from ODBC (linked tables) I tried also to put button and still cannot get thru. Do i have to set any on SQL server or table?

[ddtpmyra]

And the error message when I created the button for adding new record inside the access form is "You can't go to the specified record"

[ddtpmyra]

Problem solved!
It lets me to create new record when assigned a PK