InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:35:54 GMT20http://www.sqlservercentral.com/Forums/Topic1417777-1292-1.aspxWould 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.AndrewThu, 21 Feb 2013 15:34:53 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1417777-1292-1.aspxReport Server?Thu, 21 Feb 2013 13:13:10 GMTbdloving 4446http://www.sqlservercentral.com/Forums/Topic1417777-1292-1.aspxIf 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.Fri, 08 Feb 2013 09:26:22 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1417777-1292-1.aspxMost 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.Fri, 08 Feb 2013 09:22:24 GMTmechelle