[AccessD] Odd Attachment field types in query

 There is no comparable data type in SQL server (or anywhere else).  Same is
true for MVF (Multi-Value Fields).   Hyperlinks can be converted over, but
the loose all their "magic" as well.

 In the case of the attachment type, you need unpack everything out of the
DB into external files.  If you did that setup in the first place, there
would be no changes to upsize.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, October 31, 2014 11:03 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Odd Attachment field types in query

How so?

 Becomes a real chore when you want to move the data anywhere
> else (like SQL Server).
>
> Jim.
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com