Yeah, if even a direct RV is not working then something in the setup, or the source data, seems wrong. What happens if you create a new single-table mdb, put 1 record in and then try a RV to it, does that work?
Rick Quilhot wrote: > Same thing, I'm thinking that I have not set something up right. > > Rick Quilhot > IT Administrator > J.America Retail Products > ph: 517-333-2680 ext 102 > fx: 517-333-2596, e-mail: [EMAIL PROTECTED] > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Brian Abbott > Sent: Wednesday, May 16, 2007 11:36 AM > To: [email protected] > Subject: Re: Access ODBC - remote view > > What happens if rather than use a connection you create a remote view > directly? > > Rick Quilhot wrote: >> I have the dbc with a connetion setup to a mdb, but when I try to setup a >> Remote view the errors start. >> Warning: The query timeout cannot be set. >> Warning: The connection sync/async mode cannot be set. >> >> This error occurs when I try to add a table to the remote view >> Connectivty error: [Microsoft][ODBC Microsoft Access Driver] syntax >> error in FROM clause. >> >> Rick Quilhot >> IT Administrator >> J.America Retail Products >> ph: 517-333-2680 ext 102 >> fx: 517-333-2596, e-mail: [EMAIL PROTECTED] >> >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf >> Of Brian Abbott >> Sent: Wednesday, May 16, 2007 10:28 AM >> To: [email protected] >> Subject: Re: Access ODBC - remote view >> >> So, you have dbc with remote views set up to the tables in the mdb, yes? >> >> Can you, in the view designer, right-click on the access table and Run >> Query (1st option in shortcut menu)? >> >> >> Rick Quilhot wrote: >>> I've set up and system dsn. I can see the Table & queries with Access, >> but >>> cannot get any details form them. >>> >>> What am I doing wrong? >>> >>> >>> >>> >>> >>> Rick Quilhot >>> >>> IT Administrator >>> >>> J.America Retail Products >>> >>> ph: 517-333-2680 ext 102 >>> >>> fx: 517-333-2596, e-mail: [EMAIL PROTECTED] >>> >>> >>> >>> >>> >>> --- StripMime Report -- processed MIME parts --- >>> multipart/alternative >>> text/plain (text body -- kept) >>> text/html >>> --- >>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
