using Access 2007 as front-end to 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:

> 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." wrote in message
>
> > 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?
>
>
>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

On Wed, 31 Dec 2008 10:31:00 -0800, Tom B.
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
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

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:

> On Wed, 31 Dec 2008 10:31:00 -0800, Tom B.
> 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
>
>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

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
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

Hi Rick,
Thanks for the info.
Tom

"Rick Brandt" wrote:

> 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
>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

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." wrote in message

> 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." wrote in message
>>
>> > 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?
>>
>>
>>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

On Dec 31, 6:01 pm, "Jeff Boyce" wrote:
> 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." wrote in message
>
>
>
> > 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!
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

Not sure what the "Chipman/Baron book" referred to below is. Any info on a
title/publisher?

" " wrote:

> On Dec 31, 6:01 pm, "Jeff Boyce" wrote:
> > 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." wrote in message
> >
> >
> >
> > > 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!
>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

Possibly
http://search.barnesandnoble.com/Microsoft-Access-Developers-Guide-to-...-Server

John... Visio MVP
"Tom B." wrote in message

> Not sure what the "Chipman/Baron book" referred to below is. Any info on a
> title/publisher?
>
> " " wrote:
>
>> On Dec 31, 6:01 pm, "Jeff Boyce" wrote:
>> > 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." wrote in message
>> >
>> >
>> >
>> > > 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!
>>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end 

That looks like it, John. Thanks very much.

"John... Visio MVP" wrote:

>
> Possibly
> http://search.barnesandnoble.com/Microsoft-Access-Developers-Guide-to-...-Server
>
> John... Visio MVP
> "Tom B." wrote in message
>
> > Not sure what the "Chipman/Baron book" referred to below is. Any info on a
> > title/publisher?
> >
> > " " wrote:
> >
> >> On Dec 31, 6:01 pm, "Jeff Boyce" wrote:
> >> > 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." wrote in message
> >> >
> >> >
> >> >
> >> > > 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!
> >>
>
>
>
 >> Stay informed about: using Access 2007 as front-end to SQL Server back-end