ms access linked table from mssql server

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi all,
I have a database in ms sql and i have linked tables in ms access.Currently i need to add some more fields to the linked table.How can i add new fields to the linked table
Help me,thanks in advance.
Regards,
Shefeek

Posted 10-Nov-11 23:11pm

shefeekcm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Heino Zunzer · Accepted Answer · 2011-11-10T23:18:00

Solution 1

You would have to add the fields in SQL Server and then refresh the link for the new columns to be available in ms access.

Posted 10-Nov-11 23:18pm

Heino Zunzer

Comments

shefeekcm 11-Nov-11 5:24am

from where i need to refresh?i have added new fields in sql server.

refresh the link for the new columns to be available in ms access.?
please give reply

shefeekcm 11-Nov-11 5:49am

how can i add fields from different tables in to the linked tables

Heino Zunzer 11-Nov-11 5:54am

What version of Access are you using?
In Access 2010, go to the External Data ribbon, second symbol from the left is 'Linked Table Manager'. There you can refresh the tables.

in Access 2007 go to the External Data ribbon, then right click on your table and choose Linked Table Manager from the Context menu.

http://www.techonthenet.com/access/tables/refresh_links2007.php

shefeekcm 11-Nov-11 5:58am

am using access 2002.

i have got the refresh link.

i need to use more than one tables fields in to the linked table.hoe it is possible

Heino Zunzer 11-Nov-11 6:05am

In Access 2002 go to Tools -> Database Utilities -> Linked Table Manager.
There you can refresh as many linked tables as you like.

Heino Zunzer 11-Nov-11 6:07am

Oh, and if you mean to have a table with fields from various different linked tables: that's not possible.
You will have to link all the tables you need and then create a view, that displays the fields you want.

shefeekcm 12-Nov-11 5:14am

Thanks Heino Zunzer...thank you very much.Sorry for the delay.