I'm not able to select some specific tables from sql server intoAccess- santosh

[santosh rangula]

it's regarding Acess and SQL link.. accessing sql tables from Microsoft Access..
I have permission for all tables.. but in sql i have huge number of tables so it is showing some of them only in ascending order while linking.. i'm not able to select a specific table which is not shown in the list.. how can i import a table which is not shown in the limited list for importing/linking..


regards,
santosh rangula.


EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx

 

[Jeff Boyce]

I'm not understanding...

If a SQL-Server table is not showing on the list of tables available to
link, my assumption is that you don't have permissions to see it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[santosh rangula]

It is more like a limited list than authorization, I think its a problem with list size for showing table list.. does anyone have any idea how to resolve it..



Jeff Boyce wrote:

Re: I'm not able to select some specific tables from sql server into Access- santosh
21-Sep-09

I'm not understanding..

If a SQL-Server table is not showing on the list of tables available to
link, my assumption is that you don't have permissions to see it

Regard

Jeff Boyc
Microsoft Office/Access MV

<santosh rangula> wrote in message

Previous Posts In This Thread:

I'm not able to select some specific tables from sql server into Access- santosh
it's regarding Acess and SQL link.. accessing sql tables from Microsoft Access..
I have permission for all tables.. but in sql i have huge number of tables so it is showing some of them only in ascending order while linking.. i'm not able to select a specific table which is not shown in the list.. how can i import a table which is not shown in the limited list for importing/linking..


regards,
santosh rangula.

Re: I'm not able to select some specific tables from sql server into Access- santosh
I'm not understanding..

If a SQL-Server table is not showing on the list of tables available to
link, my assumption is that you don't have permissions to see it

Regard

Jeff Boyc
Microsoft Office/Access MV

<santosh rangula> wrote in message

EggHeadCafe - Software Developer Portal of Choice
Use HTTP PUT Client to Upload Binary and Text Data
http://www.eggheadcafe.com/tutorial...8-4eb0d49d899c/use-http-put-client-to-up.aspx