MS ACCESS 2007 Linked to SQL Subform disallowing new data entry

For over a month I have been using a form/subform to enter new data into a data history table.
I then decided I wanted to have my tables reside in an SQL db, and link ACCESS to the SQL tables.  All the queries, forms, etc remained exactly the same.  Information typed into the linked tables does immediately show in the SQL tables.
My problem:
The subform only displays already entered info, it does not bring up a new fresh row for data entry.
Opening the table itself does show a row at the bottom for entering new data, and doing a simple select Query on the table likewise displays a new row for data entry.
The subform has its “Build” query which when run does not display a new data-entry row in my SQL linked ACCESS db, while the same “Build” query in the ACCESS db where the tables are not linked, does display a new row for data entry.
Assistance please.
willjxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Quick Q...
Does the subform table have a Primary key?

Not the linking field to the main table but, ...it's own unique Primary key in the Child (subform) table.
0
willjxAuthor Commented:
the data history table has a Primary key.
However, I do not detect the presence of a "unique Primary key in the Child (subform) table. ".  
Furthermore, I do not select the tables' primary key field as one of the fields in the subform.
0
Dale FyeCommented:
As Jeff mentioned, you are going to need a PK in the table you want to update (the one in the subform).

I also add a field with a TimeStamp datatype.  You will not need to use this field, but SQL Server will.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

willjxAuthor Commented:
Wow!
That is all that was needed.
Thank you.
0
Dale FyeCommented:
Glad to help.  

Personally, I would have split the points.  You still can by clicking the "Request Attention" at the bottom right of your original post.  Then just ask the moderators to reopen so you can reallocate points.
0
Jeffrey CoachmanMIS LiasonCommented:
Dale, you know how I roll,...

enjoy buddy...
;-)

Jeff
0
Dale FyeCommented:
Jeff,  you need to slow down.  You've been on a roll lately!

;-)

Dale
0
willjxAuthor Commented:
Please allocate 250 of 500 to:  fyed and
Please allocate 250 of 500 to: boag2000.
Thank you.
0
Dale FyeCommented:
wiljx,

The way you do that is find the solution that you want to be your primary answer.  Then click the "Accept Multiple Solutions" on that answer.  You will be taken to another window to assign points to that solution and any other solution in the thread.

When you check the box for those other Expert Comments that you want to accept, a textbox will become visible for you to assign points.

Then go to the bottom of the page to grade the response and add any comments.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.