Share via

Embed SQL Server Table in Access Form

Anonymous
2013-04-04T15:57:47+00:00

HI,

I love the functionality of MS Access tables embedded in Access forms via a sub-form.  I like being able to Add / Delete / Edit data directly into the tables from the forms\sub-forms.

My question is:

Can I get this same functionality using ODBC connections to SQL server tables (being able to Add / Delete / Edit data directly into the tables)?

What would the SQL server Login and user rights have to be to do this?

Many Thanks

Kody_Devl

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-04-16T13:17:58+00:00

    Albert,

    Thank you,

    I guess I didn't think of the primary key value as it is not an issue with present state Access but can and should add for SQL Server.

    Also:

    I know how to create a time stamp field in SQL server tables but am wondering why you consider it an "always"?

    One consideration is that in Access I love the Checkbox (Yes/No) and am not able to replicate this field type with SQL Server.  Must I use Boolean 0/1 or Yes/No n SQL Server?

    Thanks Again.

    Was this answer helpful?

    0 comments