Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SqlServer 2012 and Windows XP Expand / Collapse
Author
Message
Posted Friday, February 8, 2013 9:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 8:41 AM
Points: 2, Visits: 21
Most of the machines in my office are still on Windows XP. I built a little database in Access so someone could whip out a report in three seconds instead of compiling by keyboard in Excel. She needs data out of two tables on our 2012 database. I know that XP is not compatible with Sql Server 2012 from documentation I have read. Is there a way to somehow still enable her to access (read only) those tables in spite of Windows XP? I have not yet tried oledb, but am suspecting I'll hit the same issue.
the company isn't keen on linked databases (we do have two other servers that are 2008) because of security headaches. I'm wanting this to be as-me free as possible. that is to say, I don't want her having to wait on me to get a report to her.
Post #1417777
Posted Friday, February 8, 2013 9:26 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
If for some reason or company policy you are not able to link SQL Server table to your Access database then the solutions are:
1- Ask SQL Server developer to export the data needed on your Access database then import into it.
2- Data entry.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1417780
Posted Thursday, February 21, 2013 1:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 9:10 AM
Points: 6, Visits: 18
Report Server?
Post #1422767
Posted Thursday, February 21, 2013 3:34 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:38 AM
Points: 1,154, Visits: 837
Would setting up an SSIS package to extract the data for her work? You could schedule it to run before your colleague came into work so that her data was there for her.

Andrew
Post #1422817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse