x

linking access to sql

I have imported all the tables I need from access to sql but I want to link access to sql so that when users enter data into the access form it will update the relevent sql table. I wondered if this is possible, I looked at the importing odbc under external data in access but im not sure if this is what I need to get the sql tables to update automatically? Thanks if anyone can advise the best approach on this.
more ▼

asked Oct 05 '12 at 09:14 AM in Default

n3w2sql gravatar image

n3w2sql
840 12 20 26

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
  • open the Access file that has all the user forms in it and go to Get External data.
  • you want to create Linked Tables (different Access version give the option in different places - select Linked Tables when you get prompted)
  • Choose ODBC and select the connection to your database or create a new one.
  • select the tables you want to have linked
  • you may be asked to identify which column is the PK in some tables
  • presto! you have items in the Tables collection in Access. They have a different icon from a 'local' table to indicate they are linked to an external source
more ▼

answered Oct 05 '12 at 10:37 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(comments are locked)
10|1200 characters needed characters left

I have not done this myself in so many years that I wouldn't know where to start with the newer versions of Access but to answer your question

Yes, this can be done. A quick search on Google will probably reveal step by step instructiosn on linking a form in access to a SQL database.

A quick search provided ~ Use File - Get External Data - Link Tables. On the way through, create a DSN to give you access to your sql database.

I think this is what you are looking for Create Data Access Page
more ▼

answered Oct 05 '12 at 10:29 AM

Tim gravatar image

Tim
35.5k 32 40 138

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816

asked: Oct 05 '12 at 09:14 AM

Seen: 383 times

Last Updated: Oct 05 '12 at 10:37 AM