473,320 Members | 1,794 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Need help linking table to MS Access from SQL Server.

anoble1
245 128KB
Hi,

I am getting an error message when I try to use the Link Table Manager. When I click on it, it says: "There are no Linked Tables in the Current Database".
What the heck, I know. That's why I want to add them. Anyway, this is Access 2002. This is a blank database. I'm just trying to pull the tables from the server, and place them into my database. I am used to using Access 2003, and 2007. I don't think they did it like this. Won't even let me add the Data Source, but I did through Administrator Tools.
May 7 '12 #1

✓ answered by NeoPa

For SQL Server you need to ensure first, that the correct drivers are applied to your machine. Once done, this is managed via the ODBC applet in Control Panel. When linking new tables, one option is certainly to link to other Access databases, but various other options are also available natively, and one such available option is to use ODBC. This is what you need to connect to SQL Server. Once you select this, you will be taken to a further selection similar to the ODBC applet which lists the ODBC data sources available on your machine. One of these will be SQL Server if the driver's been properly installed. I suggest you use a machine level connection rather than a user level one, and ensure that any machines that require use of the database are configured in a similar way, as otherwise you will have portability issues.

I hope this gets you further. Good luck :-)

3 1422
NeoPa
32,556 Expert Mod 16PB
What you want is :
File | Get External Data | Link Tables.

I expect it will all become pretty straightforward from there :-)

PS. Linked Table Manager is for managing existing Linked Tables ;-)
May 7 '12 #2
anoble1
245 128KB
I thought that was for linking to another database. Ex. Access DB? I have a lot of tables on my SQL Server that requires a login of course to view. When I click on Get External Data, I can't seem to find the tables on the SQL Server. Be patient with me, haven't added "New tables to a New database" HA! Thanks
May 7 '12 #3
NeoPa
32,556 Expert Mod 16PB
For SQL Server you need to ensure first, that the correct drivers are applied to your machine. Once done, this is managed via the ODBC applet in Control Panel. When linking new tables, one option is certainly to link to other Access databases, but various other options are also available natively, and one such available option is to use ODBC. This is what you need to connect to SQL Server. Once you select this, you will be taken to a further selection similar to the ODBC applet which lists the ODBC data sources available on your machine. One of these will be SQL Server if the driver's been properly installed. I suggest you use a machine level connection rather than a user level one, and ensure that any machines that require use of the database are configured in a similar way, as otherwise you will have portability issues.

I hope this gets you further. Good luck :-)
May 7 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: jason | last post by:
A dilemma: If I am attempting to add multiple products to an existing Customer-Products linking table do I do this via an Insert or Update? The first time I enter a customer in the database I...
1
by: Guinness Mann | last post by:
Greetings, I'm working in VS2003.NET using C#. I need to download a few rows from an SQL Server database table and then be able to page back and forth through them. I don't need to make any...
5
by: Arvin Portlock | last post by:
I can't come up with a query that works. Can anyone help? Conceptually the relationships are easy to describe. I have a table for books (Entries), a table for authors (Authors), and a linking...
2
by: Olly | last post by:
Find an id number not present in a linking table I have a linking table (tblPayment) that monitors the subscriptions from members. However, I need a query that can compare the ID number fields...
2
by: TheTamdino | last post by:
One of the things that is common between most genealogy databases is that they will have one screen were you log all the information for a given person and then (maybe) have a link to a source...
2
by: keithgell | last post by:
I needed to import large CSV files into Access, when requested by a command in a .Net interface. Because Access does not have a bulk insert command, and I already have vba macros in Access that...
3
by: Robert McEuen | last post by:
Using A2K3, Windows XP I'm handling a many-to-many relationship with a linking table structure as follows (irrelevant fields omitted): tblIssue PK_IssueID (autonumber, primary key) IssueName...
1
by: tomlebold | last post by:
How do you prevent a user from linking an Access application to SQL Server tables?
3
by: Andrea Raimondi | last post by:
Hello peers! I'm working on this application and I'm in need for some thoughtful advice :-p I have an SQLDataSource with params, select, etc. One of my params is the table name, which can be...
0
NeoPa
by: NeoPa | last post by:
If anyone can help with a problem linking across to a table in a database on a SQL 2000 server, then please visit Linking from Access over in SQL Server. I'm locking this so that any and all...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.