|
| 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
November 4th, 2009, 08:26 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
November 4th, 2009, 08:41 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
November 4th, 2009, 08:57 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
November 4th, 2009, 09:29 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
