Hello Wayne, Very much appreciated for providing the query to two methods, it all worked out for me, Well understood, Thanks for your valuable time.

Thanks Wayne for your help, Great help, My apologies for Not giving you the data in correct syntax, Sure to do it in the future, Thanks so much for your...

Thanks Alvin for the reply, appreciated

Thanks Jack, your article puts me in right direction, Thanks for your help, very much appreciated.

great DOS command, Perfect.. thanks a lot.

pl ingore this posting..thanks for you help.

lowell,

could you tell me your enviroment?

what is windows version? 32bit or 64bit?

what is sql version ? 32 bit or 64 bit?

what is MS access version ? 32bit or 64bit?

what is...

lowell,

where is aCe driver?

I understand what is ACE driver, I too installed it from

http://www.microsoft.com/en-us/download/details.aspx?id=23734

thanks

lowell,

I get err msg respectively:

-----------------------------------------------

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

Msg 7303, Level 16,...

MS office 2007 32 bit, is installed.

Could you give more detail; what SQL Express engine? do i have to use SQL express..I have deverloper 2008 R2 64bit

SYNONYM is perfectly suit my need, and already implemented in my project. Thanks for all your help.

Thanks, this is what I was looking for. But one issue I found. It needs all four parts. Is there a way I can create without using object, so that...

the server is same Local. My question is a kind of theory question.

when SP is called from same DB or the same DB calles the SP that is in another...

there are not network connections between DB servers.

we have 10 user databases (kind of 10 Products, each using a DB). But we do not install them all in a customer...

thanks for all the contributions you all provided. I learnt a lot of new information. thanks again.