We use Access in our museum for our databases. Two severe handicaps are:

1) not being able to enter the same record in more than one category;
duplicate records have to be created if one item/person falls in more than
one category

2) searching is possible only on the first word in the field (so, for
example, if you search on Austen House Museum, instead of Jane Austen House
Museum, you will get a negative answer).

Has any one out there been able to overcome these problems? Is at least the
first problem due more to how the database was structured than to the
program, itself? We'd sure like to know, thanks!

best regards,

Star Meyer
Bagatti Valsecchi Museum
http://www.museobagattivalsecchi.org
home: [log in to unmask]
work: [log in to unmask]

=========================================================
Important Subscriber Information:

The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).

If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).