RE: [AccessDevelopers] Access front end/SQL Express back end?

 

Shel,
There aren't too many differences between SQL Express and other SQL Server versions. I generally recommend linking to the tables. You can then create queries as if the tables were Access tables.

There are a number of ways to optimize your application with SQL Server tables. Pass-through queries are much better where the data can be read-only.

I use DSN-less connections with code from Doug Steele's page http://www.accessmvp.com/DJSteele/DSNLessLinks.html.

Duane Hookom
MS Access MVP

---

From: sarmbraugh@yahoo.com

 

Hello,

I am wondering if anyone has experience with building something with an Access front end + SQL Server Express back end?

I used to do a lot of development work with Access, but don't have much experience working outside of an Access/Jet environment.

Some things I'm wondering about are if the Access query builder can be used with SQL Express tables, what's involved in deploying Access with SQL Server Express, and just general things to watch out for.

Any suggestions or pointers would be greatly appreciated.

Thank you,
Shel

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 3

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___