Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Input Data in Forms (Access linked tables to SQL Server=

Status
Not open for further replies.
beechill4

beechill4

Technical User
May 10, 2005
207
IE
Hi,

I've an Access database which tables are linked to a SQL Server. I can enter data in SQL Server directly, in most of the tables in Access but nothing through the forms in access. Strange that I can enter data in some of the tables but not in all.

Any ideas why it is so?

Thanks!
 
Sort by date Sort by votes
Do all your tables have primary keys defined?

Do the queries for the forms include the table's primary key?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
258
Xavierparkash
Xavierparkash
kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
501
dhookom
dhookom
I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
438
hermanlaksko
hermanlaksko
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
528
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
652
Kennelbloke
Kennelbloke

Part and Inventory Search

Sponsor

Back
Top