December 7, 2005 at 9:22 am
Hi all,
I wonder if anyone knows how I do this. At the moment we have an access database which has many linked tables. Some of the tables link to SQL Server and some link to other access databases. I am trying to move our access database into SQL Server, but I cannot move the tables that are in the other access databases. Is there a way in SQL server to link to an access table without actually importing the data in? I will also need to link to other SQL Server tables on other servers without actually importing that data into my database.
I've read up on linked servers but can't seem to get it working (I think because there is a back slash in the server name I'm trying to link to!). Is there another way?
Any ideas?
Many thanks,
Paula.
December 8, 2005 at 2:24 am
Please do not cross post, see my reply here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=242493#bm242763
Andy
December 8, 2005 at 4:51 am
I cross posted because as the day wore on I realised that the solution probably lay in a SQL Server programming type task, rather than Access. I was trying to get things in the right place, in order to avoid a telling off for posting in the wrong area.
Very sorry.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply