Linking Only Certail Feilds From Server

[TJVFree]

I’m trying to link a table into ms access that has over 255 fields. I’m wondering if someone knows of a macro or a way to go out to this table and request just the fields I want and put them into a table in my access database. So in plan English it would be asked like this

Go out to the server called server 1
Look for the table called table 1
Find field’s dog, cat, run, and people
Link back to access database just thoughts fields.

Thank you for taking the time and helping me with this issue

Corey

 

[PHV]

Create a VIEW in server 1 and link an access table to it.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TJVFree]

I'm sorry if this is a stupid question, but how do I create a view and then link it to the table?

 

[PHV]

how do I create a view
Well, ask your DBA.

 

[TJVFree]

I wish it was that easy

 

[PHV]

IMHO, a table that has over 255 fields is quite strange.
Have a look here:

http://www.r937.com/Relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

Creating a view in SQL Server is much like creating a query in Access. If you don't have the permissions or knowledge to do this, you can create a pass-through query in Access that pulls only specific fields (and records). The pass-through query will be read-only.

Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

Duane, that worked perfectly. many thanks for your help.