Hello again,
The people I'm working with don't have SQL Server Express installed and are looking for advice on how to install it. Does anyone have suggestions about where or how they should install it, or what version they should use? They will have some employees accessing this system by VPN, and the front end will be in Access 2010. Any advice would be great.
Thanks again,
Shel
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> You're welcome, Shel.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@> wrote:
> >
> > 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
Tidak ada komentar:
Posting Komentar