Tim
When you make a change to a SQL table structure you MUST relink the table or Access won't see the change.
Regards,
From: timdbui@gmail.com
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, February 24, 2014 9:03:58 AM
Subject: Re: [MS_AccessPros] Access Memo Field Became ntext in SQL Server
Bill Mosca
From: timdbui@gmail.com
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, February 24, 2014 9:03:58 AM
Subject: Re: [MS_AccessPros] Access Memo Field Became ntext in SQL Server
Thank you for your advice, Bill!
Yes, I did use the Upload function within Access, but now am using the SSMS as you suggested. SSMS does match the data type more accurately than the Upload in Access.
However, I still have error in doing Export. Maybe there is some problems within my Access.
Thanks again,
Tim
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar