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.