If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cant add new records to a form
Hi
Please forgive me as I am a access newbie. I just moved an access 2003 database onto a SQL server. I am now using the database as a access project with access 2007 with a sql backend. I exported a form with use to imput cases (Intake Form) onto our sql database. I remapped the fields to the tables in the database. I can not add new records to the databse via the form. Any advice you can provide will be greatly appreciated. |
#2
|
|||
|
|||
cant add new records to a form
Can you add rows to the table via a SQL Server query in Management Studio?
-- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Jose A. Selaya" wrote: Hi Please forgive me as I am a access newbie. I just moved an access 2003 database onto a SQL server. I am now using the database as a access project with access 2007 with a sql backend. I exported a form with use to imput cases (Intake Form) onto our sql database. I remapped the fields to the tables in the database. I can not add new records to the databse via the form. Any advice you can provide will be greatly appreciated. |
#3
|
|||
|
|||
cant add new records to a form
Do you have a unique key on the table? Tables linked via ODBC aren't
updatable unless you do. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jose A. Selaya" Jose A. wrote in message ... Hi Please forgive me as I am a access newbie. I just moved an access 2003 database onto a SQL server. I am now using the database as a access project with access 2007 with a sql backend. I exported a form with use to imput cases (Intake Form) onto our sql database. I remapped the fields to the tables in the database. I can not add new records to the databse via the form. Any advice you can provide will be greatly appreciated. |
#4
|
|||
|
|||
cant add new records to a form
I exported a form with use to imput cases (Intake Form) onto our sql
database If you put the form on the SQL Server then you question needs to be to a SQL Server neewsgroup. -- Build a little, test a little. "Jose A. Selaya" wrote: Hi Please forgive me as I am a access newbie. I just moved an access 2003 database onto a SQL server. I am now using the database as a access project with access 2007 with a sql backend. I exported a form with use to imput cases (Intake Form) onto our sql database. I remapped the fields to the tables in the database. I can not add new records to the databse via the form. Any advice you can provide will be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|