[AccessD] OT: Migration to SQL Server - sort of

Not exactly migration, but biggest issue I've had lately with Access
FE's to SQL 2k is that Access can't deal with GUID's.  You *must* make
all the queries that join on these types of fields  into views because
Access can't relaibly make these joins.




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, March 24, 2004 7:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT: Migration to SQL Server


Anything special you had to do in terms of SQL Server to assist in
managing the resulting databases? for example creating admin users etc


Martin



----- Original Message ----- 
From: "Mike & Doris Manning" <mikedorism at adelphia.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, March 24, 2004 12:27 PM
Subject: RE: [AccessD] OT: Migration to SQL Server


> Hi Martin,
>
> I migrated four different Access dbs to a single instance of SQL 
> Server about a year ago and didn't encounter any problems.
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
> Sent: Tuesday, March 23, 2004 4:58 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] OT: Migration to SQL Server
>
>
> Anyone done any work migrating SEVERAL Access dbs to a single instance

> of SQL Server??
>
> Particulary interested in any problems this caused etc etc
>
> Maybe a pointer to things to come. I have been asked to look at 
> several areas around this subject including building .NET Front Ends 
> to migrated dbs.
>
> Martin
>
> --
> _______________________________________________
> 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
>

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com