[AccessD] Odd Attachment field types in query

Jim, et al.

Not using BLOBS in Access, would I be correct in thinking that the association
is held within Access, so accessing the BLOB using a client PC may encounter
problems if the client PC does not have the same software available as the base
environment that was used to put the BLOB into the Access environment?

And - if the software is updated to a new version would that also cause
problems?

JimB 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Friday, October 31, 2014 6:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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