Linking Access 2007 to Linked SQL Server

G

Gregorys05

Board Regular
Joined
Sep 24, 2008
Messages
217
Hi All,
I have an access database that i have linked to an SQL backend but there is one table that i require that is a linked SQL server, i didnt know if anyone knows how to link to this server at all?


Access database - linked to - SQL Server, then within that server is a Linked Server.

I have linked the first SQL server via ODBC but cant get the list of tables for the linked server....:confused:

Any ideas?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

S
  • Question Question
ACCESS, VBA: Fetch data from sql server and paste it into local table.
Replies
3
Views
2K
Micron
M
CPGDeveloper
  • Question Question
Creating a Fillable PDF Directly From Access
Replies
5
Views
988
CPGDeveloper
CPGDeveloper
M
  • Question Question
Need a bigger database than Access thats local
Replies
1
Views
527
james_lankford
J
C
  • Question Question
Linked Excel table in Access - field values change as I navigate?
Replies
5
Views
588
welshgasman
welshgasman
J
  • Solved
Having a problem in the expression builder, very new to Access. It thinks I'm trying to use Automation objects?
2
Replies
15
Views
950
Micron
M

Forum statistics

Threads
1,224,574
Messages
6,179,634
Members
452,934
Latest member
Jdsonne31

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top