SQL Server express with Access environment
Posted on 2014-02-19
I've inherited an app that is written in Access 2007 (?) and has linked tables to SQL Server Express .
I'm used to using ODBC drivers to link to Oracle tables on a Windows server running Oracle, but not SQL Server.
I would like to mimic the environment on my desktop that the client has on theirs. I've copied the data using export and that should work, but for my own gratification, I would like to get up to speed on SQL Server Express. This might be the perfect opportunity.
What steps to I need to take to load SQL Server Express?
Is there a way I can export or backup the clients data and import it to my Access mdb?
What's the best way to accomplish this?