Linked server between sql server 2005 and access 2010 proplem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Linked server between sql server 2005 and...

Linked server between sql server 2005 and access 2010 proplem

Rate Topic

Display Mode

Topic Options

Author

Message

ahmed_elbarbary.2010

Posted Saturday, January 26, 2013 5:03 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, April 13, 2013 4:01 PM
Points: 14, Visits: 32

Hi guys i want to make linked server between sql server 2005 and office 2010. (I try to access The Microsoft Access database from SQL server)but sql server 2005 connected to domain but Microsoft access work as work group computer not connected to domain . is possible to connect between each others.
what i write in linked server ,provider,,datasource

thanks

Post #1412011

Bhuvnesh

Posted Saturday, January 26, 2013 10:04 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

why cant u use SSIS ? it provide great heterogenous environment

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1412045

ahmed_elbarbary.2010

Posted Saturday, January 26, 2013 11:25 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, April 13, 2013 4:01 PM
Points: 14, Visits: 32

how i can do this by ssis please tell me

Post #1412052

« Prev Topic | Next Topic »

Permissions