[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Preferred administration/maintainence tools.
****** message to minivend-users from Joe Hourcle <oneiros@dcr.net> ******
On Mon, 15 Feb 1999 cfm@maine.com wrote:
> ****** message to minivend-users from cfm@maine.com ******
> > ****** message to minivend-users from mediamob <mediamob@dnaco.net> ******
> >
> > I am working on my catalog and need to make some design choices for my
> > database mastering. My descriptions are very lengthy, so the import/export
> > from Microsoft Excel and/or Access make them inappropriate (they truncate
> > MEMO fields to 255 chars).
If you're using MSAccess's Jet database in a multi-user environment, avoid
MEMO fields like the plague. They're the most likely to go corrupt of any
field. (last week, I got to spend two fun filled days recovering a small
(2k records) database, that had 6 memo fields go out to lunch on 'em.)
Also, make sure that any people using MSAccess have the Jet database
update, I think it's 3.51
> We use SQL exclusively and run 100% linux. Below is our standard
> products table. We use both a short 255 char description and a longer
> (up to 64kb) text field. At least some DOS/Windows dbs support memo
> fields over 255. dbf is what, Foxpro?
dbf = DBase, I think.
-----
Joe Hourcle
Digital Crescent, Inc.
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
