[AccessD] Access + SQL Server 2005

Dan Waters dwaters at usinternet.com
Wed Dec 21 15:02:26 CST 2005


The SS 2005 Book On Line shows a few different methods.  Look under
'importing data'.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Moss
Sent: Wednesday, December 21, 2005 11:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access + SQL Server 2005

Are there any tools for importing data into SQL Express 2004?

> Well, SQL 2K5 is out, and I'm looking at the Express version.  It has 4Gb
> storage, no workload governor, uses essentially the same Manager as full
> SQL
> 2K5, and of course it's free of charge.  On the other hand, you can't use
> the Query Designer in an ADP.
>
> I have no experience using Access + SQL, but with the release of SQL 2K5 I
> figure it's time to move up.
>
> I have some general questions, especially for you folks who've been 'in
> the
> know' for quite some time now:
>
>     Is it possible to use an ADP with SQL 2K5?
>
>     If using an ADP is possible, what would be the pros/cons of using an
> MDB
> FE vs. an ADP FE with SQL 2K5?
>
>     Is using A03 better than using AXP as a FE for SQL 2K5?  If so, why?
>
>     Any other known issues for discussion?
>
>
> I hope this starts a discussion over the next few days, and that everyone
> has a great Holiday Season!
>
> Thanks,
> Dan Waters
>
>
>
> --
> 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




More information about the AccessD mailing list