Rabu, 11 April 2012

[MS_AccessPros] Re: Access + SQL Server Express

 

Shel

I don't know about Express but the Standard edition of SQL automatically looks for updates when you install it.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@...> wrote:
>
> Thanks Bill. Just realized I should have been looking at an install package with more recent SPs.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Shel
> >
> > I installed express 2005 without any issues on Windows 7 and XP.
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@> wrote:
> > >
> > > Just want to add that I'm looking at SQL Express 2005 based on Bill's previous suggestion to Jim.
> > >
> > > Users' workstations are on Windows 7. I'm not sure if that means they need a more recent version based on the system requirements listed here:
> > >
> > > http://www.microsoft.com/download/en/details.aspx?id=21844#system-requirements
> > >
> > > Shel
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@> wrote:
> > > >
> > > > 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
> > > >
> > >
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar