ACCESS FEED: Re: [MS_AccessPros] SQL SERVER

Kamis, 10 Desember 2015

Re: [MS_AccessPros] SQL SERVER

Kevin-

Use either the OLE Object data type or a text field into which you store the path (on a shared drive) to the document. If you choose the latter, use the Image control and set the Control Source to the text field. That should load the document when you want to display it on a form or report.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 10, 2015, at 2:44 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-

Actually I only need one picture in the attachment. I only saw one choice to stall pictures,that's by attachment. May be there's othe way to store one picture? Thanks.

Best Regards,

Kevin

发自我的小米手机

在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月10日下午8:54写道：

Kevin-

Either you or someone else asked about this recently, and we answered that it is not possible to "upsize" an Access table containing the Attachment data type to SQL Server. SQL Server has no equivalent data type. The data type it chose may look like "Memo" in a linked table back to Access, but if you look at the actual data type in the SQL Server table, you'll find one of the "blob" (Large binary) data types.

You will need to redesign your table to use text links to externally stored documents. If a record can have multiple documents, you will also have to design additional tables to reflect the actual one-to-many or many-to-many relationship.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Dec 10, 2015, at 10:37 AM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

After importint table from MS Access 2010 to SQL SERVER 2008 R2, the field format in attachment containing pictures changes to Memo automatically. Please help.

Best Regards,

Kevin