February 8, 2013 at 9:22 am
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.
February 8, 2013 at 9:26 am
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.February 21, 2013 at 1:13 pm
Report Server?
February 21, 2013 at 3:34 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply