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, 2012 at 09:14 AM in Default

avatar image

n3w2sql
870 22 32 39

(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, 2012 at 10:37 AM

avatar image

Fatherjack ♦♦
43.7k 79 98 117

(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, 2012 at 10:29 AM

avatar image

Tim
40.4k 39 84 166

(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.

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:

x2077

asked: Oct 05, 2012 at 09:14 AM

Seen: 496 times

Last Updated: Oct 05, 2012 at 10:37 AM

Copyright 2016 Redgate Software. Privacy Policy