Senin, 02 April 2012

[MS_AccessPros] Re: Access + SQL Server Express

 

Very helpful, thank you Bill.

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Shel
>
> Welcome to our group.
>
> SQL Server Express would work just fine. Most of my applications are Access front ends to SQL Server. You just link to the tables using an ODBC connection (the last selection in the File Type list on the target database dialog for getting external data). Then you can run queries on them just like linked Access tables. There are a few gotchas that I've listed on my site. See http://thatlldoit.com/howtosarticles.aspx#sqlbackend
>
> As to deployment, see http://thatlldoit.com/howtosarticles.aspx#fe_updater
>
> I've written a script for deployment that makes it painless. The article is very detailed, but it helps to know VBA to fully understand it.
>
> Post back here if you need more help.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@> wrote:
> >
> > Hello,
> >
> > I'm looking for information on building a system with an Access front end and a SQL Server Express back end -- or recommendations for other tools, if you think something else would be better.
> >
> > The people I'm making this for want some of the flexibility of Access, so they can make modifications and write queries, but they may have too much data for jet. They also don't have a lot of money to spend. On my end, most of my experience is with Access, so I'm hoping to find something that won't have too much of a learning curve.
> >
> > Regarding SQL Express, I'm wondering if the Access query builder can be used with SQL Express tables, and am also looking for pointers on deployment.
> >
> > Any thoughts would be greatly appreciated.
> >
> > Thank you,
> > Shel
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar