[AccessD] A2000/3:Connecting to SQL Server

Darren

..AccessD members Harkins and Martin have a book out "SQL: Access to SQL 
Server" that walks you right through this while holding your hand, and 
squeezing when necessary ...and if that isn't enough, they're both right 
here to dumb it down to where even I could understand it :)

http://www.amazon.com/gp/product/customer-reviews/1893115305/ref=cm_cr_dp_pt/102-6279525-3247338?%5Fencoding=UTF8&n=507846&s=books

William

----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, August 18, 2005 10:00 AM
Subject: RE: [AccessD] A2000/3:Connecting to SQL Server


> Darren,
>
> If the BE is in Access and needs to be upgraded to SQL Server, try the
> upgrade wizard.  I have run this on some fairly major Access Bes and it
> works pretty well.  The only issue I had was dates which have different
> ranges between Access and SQL.
>
>
> The idea is to get the BE upgrading without any issues (data all moves
> without errors), then put the FE back in the BE and run it one more time.
> The wizard will place the data in SQL Server and create ODBC connections
> between the FE (no data anymore) and SQL Server.  The ODBC connections 
> look
> for all the world like normal links and at that point your FE should 
> operate
> normally.  At least the FE will work now.  You can then start doing other
> things to make it faster, more robust etc.
>
> That's the "nutshell" version of the process.
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren Dick
> Sent: Thursday, August 18, 2005 8:46 AM
> To: Access Developers discussion and problem solving; Database Advisors
> Subject: [AccessD] A2000/3:Connecting to SQL Server
>
>
> Hello all
>
> New Job - Have to Learn SQL Server ASAP and MS Reporting Services.
>
> (Anyone know any good resources on MS Reporting Services?)
>
> Also I would like someone to hold my hand getting an ACCESS front end to
> talk with a SQL Server Backend.
>
> never done it - never had to - and I have no clue on how to do it. :-))
>
> Anyone wanna hold my hand  (No sweaty palms - I promise) or failing that
> some simple
>
> (and it really does have to be simple for me) tutorials?
>
> Many thanks
>
> Darren
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>