Search Again: Re: ODBC From: Yap Seng Hooi Date: Wednesday, July 30, 2003 Time: 8:23:21 pm When Purchase Request is run. File->Sharing is selectable, it is already turned on. Therefore I'm able to see the five files from Access, namely: Activity_ Invoices_ Payments_ Services_ Usage_ However, when I run Mainmenu.fp5, File->Sharing is not selectable for sharing. How can I make it selectable so that I can proceed to test whether linking is possible? Thanks. Best regards, Seng Hooi -----Original Message----- From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf Of Shawn Hogan Sent: Thursday, July 31, 2003 11:05 AM To: Optigold ISP List Subject: Re: [Optigold ISP] ODBC Yap Seng Hooi wrote: > Another problem I encounter when trying to connect to OG via ODBC from > MS Access is that MainMenu.fp5 is not displayed as linkable. Only 5 of > the files from OG are displayed; available for linking. Which file(s) are they? > The error occurs when I tried to link to one of the tables. I think the > reason the operation fails is because Access thinks the table > (Activity_) has too many indexes, it is referring to the table in OG. > (here is the actual error message: The operation failed. There are too > many Indexes on the table 'Activity_'. Delete some of the indexes on > the table and try the operation again.) How should I fix this problem? > Thanks for helping. If Access cannot handle that number of indexed fields, then you will not be able to use Access. - Shawn ---------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html --------------------------------------------------- --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: ODBC by Paul Daniel on Nov 2, 1999 at 10:11:46 pm Re: ODBC by Shawn Hogan on Nov 2, 1999 at 10:39:10 pm ODBC by Thomas Browner on Nov 17, 1999 at 10:48:01 pm Re: ODBC by Shawn Hogan on Nov 17, 1999 at 11:49:47 pm Re: ODBC by Christian Lawrence on Nov 18, 1999 at 8:03:59 am Re: ODBC by Shawn Hogan on Nov 18, 1999 at 8:54:10 am ODBC by Erich Oliphant on Mar 1, 2000 at 7:59:04 pm Re: ODBC by Shawn Hogan on Mar 1, 2000 at 8:26:06 pm Re: ODBC by Erich Oliphant on Mar 1, 2000 at 11:25:52 pm Re: ODBC by Shawn Hogan on Mar 1, 2000 at 11:31:33 pm ODBC by Jason Ambrose on Mar 7, 2000 at 2:03:44 pm Re: ODBC by Shawn Hogan on Mar 7, 2000 at 2:11:13 pm ODBC by =?iso-8859-1?Q?Eduardo_P=E9rez?= on Jan 18, 2001 at 7:26:34 am ODBC by Fredrik Larsson on Apr 10, 2001 at 3:30:09 am Re: ODBC by Shawn Hogan on Apr 10, 2001 at 5:12:29 am Re: ODBC by Tony D. Koehn on Jul 18, 2001 at 11:42:40 am Re: Re: ODBC by mbailey@journey.net on Jul 18, 2001 at 11:54:30 am Re: Re: ODBC by Roger Starnes on Jul 18, 2001 at 12:37:37 pm Re: Re: ODBC by Tony D. Koehn on Jul 18, 2001 at 1:54:05 pm Re: Re: ODBC by Michael Baird on Jul 18, 2001 at 2:00:47 pm Re: Re: ODBC by Shawn Hogan on Jul 18, 2001 at 9:39:19 pm Re: Re: ODBC by Neil Ulrich on Jul 18, 2001 at 9:45:36 pm Re: Re: ODBC by Shawn Hogan on Jul 18, 2001 at 9:54:51 pm Re: Re: ODBC by Neil Ulrich on Jul 18, 2001 at 10:01:04 pm Re: Re: ODBC by Tony D. Koehn on Jul 19, 2001 at 8:57:16 am Re: Re: ODBC by Shawn Hogan on Jul 19, 2001 at 5:23:37 pm Re: Re: ODBC by Sheron Lowe on Jul 23, 2001 at 6:35:56 pm ODBC by Sharon Tan on Aug 7, 2001 at 3:48:35 am Re: ODBC by Shawn Hogan on Aug 7, 2001 at 6:38:25 am ODBC by Tony D. Koehn on Sep 3, 2001 at 1:47:55 pm ODBC by Livermore, John on Nov 6, 2001 at 2:50:24 pm Re: ODBC by Shawn Hogan on Nov 6, 2001 at 3:00:08 pm Re: ODBC by Livermore, John on Nov 6, 2001 at 3:12:29 pm Re: ODBC by Shawn Hogan on Nov 6, 2001 at 3:21:39 pm Re: ODBC by John Livermore on Nov 6, 2001 at 7:30:27 pm Re: ODBC by Shawn Hogan on Nov 6, 2001 at 7:48:10 pm Re: ODBC by support on Nov 6, 2001 at 7:58:47 pm Re: ODBC by Roger Starnes on Nov 8, 2001 at 4:54:47 am odbc by Darren Simpson on Nov 9, 2001 at 1:23:32 am Re: odbc by Shawn Hogan on Nov 9, 2001 at 1:27:56 am Re: odbc by Darren Simpson on Nov 9, 2001 at 1:33:50 am ODBC by VIP Internet, Inc. on Dec 5, 2001 at 9:04:41 pm Re: ODBC by Shawn Hogan on Dec 5, 2001 at 10:19:23 pm Re: ODBC by Mike Bacher on Dec 5, 2001 at 11:06:09 pm Re: ODBC by VIP Internet, Inc. on Dec 6, 2001 at 4:01:35 am ODBC by Chris Collins on Jun 26, 2002 at 8:01:34 am Re: ODBC by Chris Collins on Jun 26, 2002 at 8:27:53 am odbc by wintel on Jan 30, 2003 at 8:37:34 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 9:15:49 am Re: odbc by wintel on Jan 30, 2003 at 9:47:24 am Re: odbc by wintel on Jan 30, 2003 at 9:48:34 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 9:51:30 am Re: odbc by wintel on Jan 30, 2003 at 10:01:13 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 10:02:59 am Re: odbc by wintel on Jan 30, 2003 at 10:10:19 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 10:12:34 am Re: odbc by wintel on Jan 30, 2003 at 10:17:15 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 10:19:27 am Re: odbc by wintel on Jan 30, 2003 at 10:24:15 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 10:44:47 am Re: odbc by wintel on Jan 30, 2003 at 10:55:08 am Re: odbc by Shawn Hogan on Jan 30, 2003 at 10:58:27 am Re: odbc by wintel on Jan 30, 2003 at 11:12:29 am ODBC by Sharon Tan on Jul 30, 2003 at 2:20:04 am Re: ODBC by Shawn Hogan on Jul 30, 2003 at 9:52:29 am Re: ODBC by Sharon Tan on Jul 30, 2003 at 6:50:14 pm Re: ODBC by Shawn Hogan on Jul 30, 2003 at 6:54:23 pm Re: ODBC by Yap Seng Hooi on Jul 30, 2003 at 7:59:29 pm Re: ODBC by Shawn Hogan on Jul 30, 2003 at 8:05:25 pm Re: ODBC by Yap Seng Hooi on Jul 30, 2003 at 8:23:21 pm Re: ODBC by Shawn Hogan on Jul 30, 2003 at 8:34:33 pm Re: ODBC by Yap Seng Hooi on Jul 30, 2003 at 8:56:57 pm Re: ODBC by Shawn Hogan on Jul 30, 2003 at 8:59:39 pm Re: ODBC by Yap Seng Hooi on Jul 30, 2003 at 10:07:57 pm Re: ODBC by Shawn Hogan on Jul 30, 2003 at 10:17:30 pm Re: ODBC by Yap Seng Hooi on Jul 30, 2003 at 10:26:33 pm Re: ODBC by Shawn Hogan on Jul 30, 2003 at 10:28:47 pm