I like the solution of figuring out a way to upload the Access to the Server, upsize to SQL 2000 - how would I do this programmatically? (it's only a read only db on the server, no one writes to it) - He will not use the SQL 2000 on the server to update and manage the db (too slow) and inconvenient.
Thanks, Mark -----Original Message----- From: Dave Watts [mailto:dwatts@;figleaf.com] Sent: Sunday, October 20, 2002 2:30 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: CFIndex for Verity quit working > Any ideas on how to resolve? HELP!!! I'm really stuck. > Is there a file size limit that Verity won't work with > if it exceeds that limit? (such as it working with a > 9mb file size, but not an 11mb file size). I don't know about this. You might try indexing a portion of the data at a time, and see if that works. > BTW: You're probably wondering, the client insists on > working on the Access db on his client machine, then > uploading to the server - he refuses to go to SQL 2000 > if it means not being able to keep a copy at his office. > It's his life's work. I don't mean to be glib, but I wouldn't want to use Access for my life's work. It is possible for you to use SQL Server, and allow your client to store a copy of the data at his office, although it might make things a little more complicated for both of you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
