in reply to Building a catalog

If you only have one table in the Access database or you feel the maintainers are fairly savvy, you could give them instructions on how to dump the Access table(s) to CSV and then give them an upload script.

Beware that Access will silently truncate really big tables when outputting to CSV: 32k or 64k row limits on depending on your version of Access.

Replies are listed 'Best First'.
Re: Re: Building a catalog
by cdguitar01 (Monk) on Feb 05, 2003 at 15:37 UTC
    It's sounding more and more like a CSV Document is the way to go for this project.
    Basically, the end result is going to be a CGI script I could either send a model number to, or maybe a manufacterer and have it return all the equipment that matched it, I'm sure you get where I'm going with this.
    But is a CSV document with roughly 5,000 pieces of equipment, each with possibly 5 fields attached, going to cause a major Server bottle neck? And if it does, might there be a better way to get around it.

    Chris DeGrace