Dave,
In addition to Bill's comment, it might be the AS400 has a datatype or other attribute that Access doesn't support.
I generally try a pass-through query to see if it works.
Duane Hookom MVP
MS Access
________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: wrmosca@comcast.net
> Date: Wed, 11 Dec 2013 09:26:56 -0800
> Subject: [MS_AccessPros] RE: AS400 connection - MSAccess 2010
>
> Dave
>
> I don't have any experience with AS400 data but I'll try to help. Does
> the error happen with all tables or just some? If it only happens with
> some do those tables have primary keys. I know SQL Server ODBC doesn't
> play nice with tables that don't have primary keys.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar