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
(Paris, France)
On Dec 10, 2015, at 10:37 AM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar