|
|
Are there any good documents or books that give an in-depth explanation of
using Access 2007 as a front-end to a SQL Server back-end?
|
|
Tom
Could you be a bit more specific about what you're trying to learn? These
newsgroups tend to provide specific suggestions in response to specific
questions/issues.
For example, if you want to get ideas about connecting Access (any version)
to a back-end data source (any source), you could look for information about
"linking".
If you are trying to customize a user-interface to work more efficiently
with a back-end data source (e.g., SQL-Server), are you focusing on forms,
reports, or ???
More info, please...
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Tom B." <TomB[ at ]discussions.microsoft.com> wrote in message
news:F086D2AB-17D5-4ACA-944A-E3652B7EEBA2[ at ]microsoft.com...
[Quoted Text] > Are there any good documents or books that give an in-depth explanation of
> using Access 2007 as a front-end to a SQL Server back-end?
|
|
Jeff,
Unfortunately, I am unable to be more specific in this question. I have
heard that there were issues with Access 2000 and Access 2003 being used as a
front-end for SQL Server 2000. I have a project coming up where
(specifically) Access 2007 could be used either as a standalone database or
as a front-end to SQL Server. My instinct is to use Access as a front-end,
but I'm not sure if there are known issues with Access 2007 when used in this
manner. I apologize for not having a specific question - it was more just
wondering if anyone could recommend a document or book that covered all or
most aspects of using Access 2007 as a front end to a SQL Server database.
"Jeff Boyce" wrote:
[Quoted Text] > Tom
>
> Could you be a bit more specific about what you're trying to learn? These
> newsgroups tend to provide specific suggestions in response to specific
> questions/issues.
>
> For example, if you want to get ideas about connecting Access (any version)
> to a back-end data source (any source), you could look for information about
> "linking".
>
> If you are trying to customize a user-interface to work more efficiently
> with a back-end data source (e.g., SQL-Server), are you focusing on forms,
> reports, or ???
>
> More info, please...
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Tom B." <TomB[ at ]discussions.microsoft.com> wrote in message
> news:F086D2AB-17D5-4ACA-944A-E3652B7EEBA2[ at ]microsoft.com...
> > Are there any good documents or books that give an in-depth explanation of
> > using Access 2007 as a front-end to a SQL Server back-end?
>
>
>
|
|
On Wed, 31 Dec 2008 10:31:00 -0800, Tom B.
<TomB[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > Unfortunately, I am unable to be more specific in this question. I have
>heard that there were issues with Access 2000 and Access 2003 being used as a
>front-end for SQL Server 2000. I have a project coming up where
>(specifically) Access 2007 could be used either as a standalone database or
>as a front-end to SQL Server. My instinct is to use Access as a front-end,
>but I'm not sure if there are known issues with Access 2007 when used in this
>manner. I apologize for not having a specific question - it was more just
>wondering if anyone could recommend a document or book that covered all or
>most aspects of using Access 2007 as a front end to a SQL Server database.
>
Hi Tom,
Access 2007 makes a great front-end to SQL Server, if you use some
optimization techniques. I have slide deck called "Best of Both
Worlds" at www.JStreetTech.com/downloads that covers the basics for
any version recent of Access.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com
|
|
Hi Rick,
Thanks for the info.
Tom
"Rick Brandt" wrote:
[Quoted Text] > On Wed, 31 Dec 2008 10:31:00 -0800, Tom B. wrote:
>
> > Jeff,
> > Unfortunately, I am unable to be more specific in this question. I
> > have
> > heard that there were issues with Access 2000 and Access 2003 being used
> > as a front-end for SQL Server 2000. I have a project coming up where
> > (specifically) Access 2007 could be used either as a standalone database
> > or as a front-end to SQL Server. My instinct is to use Access as a
> > front-end, but I'm not sure if there are known issues with Access 2007
> > when used in this manner. I apologize for not having a specific question
> > - it was more just wondering if anyone could recommend a document or
> > book that covered all or most aspects of using Access 2007 as a front
> > end to a SQL Server database.
>
> If there are issues it is likely only with ADPs and even then only if you
> want to be able to design SQL Server objects via the ADP front end.
>
> If you use an MDB with links/ODBC then just about any version of Access
> can front end any version of SQL Server.
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
|
|
Hi Armen,
Thanks so much for the lead. I'll check out the article right now. I
really appreciate it.
Best regards,
Tom
"Armen Stein" wrote:
[Quoted Text] > On Wed, 31 Dec 2008 10:31:00 -0800, Tom B.
> <TomB[ at ]discussions.microsoft.com> wrote:
>
> > Unfortunately, I am unable to be more specific in this question. I have
> >heard that there were issues with Access 2000 and Access 2003 being used as a
> >front-end for SQL Server 2000. I have a project coming up where
> >(specifically) Access 2007 could be used either as a standalone database or
> >as a front-end to SQL Server. My instinct is to use Access as a front-end,
> >but I'm not sure if there are known issues with Access 2007 when used in this
> >manner. I apologize for not having a specific question - it was more just
> >wondering if anyone could recommend a document or book that covered all or
> >most aspects of using Access 2007 as a front end to a SQL Server database.
> >
>
> Hi Tom,
>
> Access 2007 makes a great front-end to SQL Server, if you use some
> optimization techniques. I have slide deck called "Best of Both
> Worlds" at www.JStreetTech.com/downloads that covers the basics for
> any version recent of Access.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
>
|
|
Tom
JOPO (just one person's opinion) ...
I've been using Access front-end to SQL-Server for versions '97, 2000, ...,
2007 (against SQL-Server 6?, 2000, 2005) without incident/issue (other than
the learning curves).
Other folks may have had other experiences.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Tom B." <TomB[ at ]discussions.microsoft.com> wrote in message
news:691C6457-E28E-4893-A5C8-B33840D35D1C[ at ]microsoft.com...
[Quoted Text] > Jeff,
> Unfortunately, I am unable to be more specific in this question. I have
> heard that there were issues with Access 2000 and Access 2003 being used
> as a
> front-end for SQL Server 2000. I have a project coming up where
> (specifically) Access 2007 could be used either as a standalone database
> or
> as a front-end to SQL Server. My instinct is to use Access as a front-end,
> but I'm not sure if there are known issues with Access 2007 when used in
> this
> manner. I apologize for not having a specific question - it was more just
> wondering if anyone could recommend a document or book that covered all or
> most aspects of using Access 2007 as a front end to a SQL Server database.
>
> "Jeff Boyce" wrote:
>
>> Tom
>>
>> Could you be a bit more specific about what you're trying to learn?
>> These
>> newsgroups tend to provide specific suggestions in response to specific
>> questions/issues.
>>
>> For example, if you want to get ideas about connecting Access (any
>> version)
>> to a back-end data source (any source), you could look for information
>> about
>> "linking".
>>
>> If you are trying to customize a user-interface to work more efficiently
>> with a back-end data source (e.g., SQL-Server), are you focusing on
>> forms,
>> reports, or ???
>>
>> More info, please...
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "Tom B." <TomB[ at ]discussions.microsoft.com> wrote in message
>> news:F086D2AB-17D5-4ACA-944A-E3652B7EEBA2[ at ]microsoft.com...
>> > Are there any good documents or books that give an in-depth explanation
>> > of
>> > using Access 2007 as a front-end to a SQL Server back-end?
>>
>>
>>
|
|
On Dec 31, 6:01 pm, "Jeff Boyce" <nonse...[ at ]nonsense.com> wrote:
[Quoted Text] > Tom
>
> JOPO (just one person's opinion) ...
>
> I've been using Access front-end to SQL-Server for versions '97, 2000, ...,
> 2007 (against SQL-Server 6?, 2000, 2005) without incident/issue (other than
> the learning curves).
>
> Other folks may have had other experiences.
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Tom B." <T...[ at ]discussions.microsoft.com> wrote in message
>
> news:691C6457-E28E-4893-A5C8-B33840D35D1C[ at ]microsoft.com...
>
> > Jeff,
> > Unfortunately, I am unable to be more specific in this question. I have
> > heard that there were issues with Access 2000 and Access 2003 being used
> > as a
> > front-end for SQL Server 2000. I have a project coming up where
> > (specifically) Access 2007 could be used either as a standalone database
> > or
> > as a front-end to SQL Server. My instinct is to use Access as a front-end,
> > but I'm not sure if there are known issues with Access 2007 when used in
> > this
> > manner. I apologize for not having a specific question - it was more just
> > wondering if anyone could recommend a document or book that covered all or
> > most aspects of using Access 2007 as a front end to a SQL Server database.
>
> > "Jeff Boyce" wrote:
>
> >> Tom
>
> >> Could you be a bit more specific about what you're trying to learn?
> >> These
> >> newsgroups tend to provide specific suggestions in response to specific
> >> questions/issues.
>
> >> For example, if you want to get ideas about connecting Access (any
> >> version)
> >> to a back-end data source (any source), you could look for information
> >> about
> >> "linking".
>
> >> If you are trying to customize a user-interface to work more efficiently
> >> with a back-end data source (e.g., SQL-Server), are you focusing on
> >> forms,
> >> reports, or ???
>
> >> More info, please...
>
> >> Regards
>
> >> Jeff Boyce
> >> Microsoft Office/Access MVP
So is the Chipman/Baron book on using Access as a FE to SQL Server
still totally applicable? If not, where? (Sorry, didn't mean to ask
an essay question... was hoping for a shorter answer type!)
Thanks!
|
|
|