2 things: 1. Under ODBC configuration, ensure that OTHER is set to: Read/Write (all SQL) 2. Within Access go to Tools, Options, Advanced, and set the record locking value. "McCready, Joan" <Joan.McCready@metalt To: "MAPICS-List (E-mail)" <firstname.lastname@example.org> ekint.com> cc: Sent by: Subject: SQL and MAPICS mapics-l-admin@midran ge.com 02/22/2002 02:14 PM Please respond to mapics-l Hi! I have just finished Intro to, Intermediate Applications of and Adv Appls of SQL through our local univeristy continuing ed program. I am now thoroughly dangerous! What tool do those of you who use SQL use with MAPICS / AS/400? We don't have (and really don't need) MS SQL Server. Any suggestions? I've played with Access today, and can query MAPICS files, but can't update - or at least I haven't found the magic button yet. Have a good weekend -- Joan Joan McCready, IS Manager phone: 636-479-4499 MetalTek International fax: 636-479-3399 The Carondelet Division www.metaltekint.com 8600 Commercial Blvd Pevely, MO 63070 _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l or email: MAPICS-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.