I read a discussion thread yesterday and don't remember
which one it was and can't find it now, but it referred
the sender to an article about The Evils of Lookup Fields
in Tables.( I printed the artice but don't remember the

I'm building a database for a choir association. The main table called
Choirs includes a topic MusicPerformed. This field should be multichoiced,
e.g. Baroque, Classical, Popular (a choir can sing many type of music). I'm
perplexed about this. Since there are 20 choices, what is the ...

Hope someone can help....
I was asked to create a contract databse, however, there are over 100
contracts with a minimum of 5 pages, each page containing at least 10
sections.  Each section would have to be stored seperately in addition to

I tried to locate the "Compact on close" feature.  Opened
Tools, General tab, Options but I do not have a compact on
close feature.  Is this only available in a developer's
edition ?  Thanks for you help.

I recently added a field to an existing table, and shortly began receiving
"Field '(fieldName)' cannot be a zero-length string" error messages for
various fields in the table when appending the table in DAO.  I went back to
look at the table design, and discovered that *all* the ...

I recently set up a number of databases on a new server in
another country. The server (windows 2003 small business
server) with windows 2003 loaded, had two  drives c & d .
I linked all front ends to there respective backends on

I have a database that track customer network config information. I would
like to upload a netowrk diagram of each customers config. How can I do
that?

does anyone know how to create a table with a currency
field that automatically places the decimal 2 places to
the left
I would like to be able to enter a number without using

Before split my DB, I can open one of my tables. But after
splitted my DB,I couldn't open that table from my BE DB.
The warning message is "Property value is too large".
Does anyone know what happened?

I have down loaded an update.  When I try to execute the
file I get this message.  Jet35sp3.exe is not a valid
Win32 application.  Any ideas?? Thanks

I am trying to index 10 fields under one index, I have
read and followed the steps on the help files for
creating a multiple field index however it does not
appear to be working; the fields will allow duplicate

I have a table of employes set up with an autonumber field as the primary
key.  Someone deleted one of the members.  I'm would like to restore the
member with the same ID number.  Is this possible?
Thanks,

I inherited a perl CGI application that uses the integer primary key
in the
Microsoft Access database fabricate as the file name of  flat text
file to hold arbitrary amounts of text. It just dawned on me that this

We run a database across a network, with about 20 users.  
Our client table has an autonumber primary key that is
currently on about 4000.  Sometimes when we go to add a
new client this autonumber jumps back to about 2000 so we

I have a few simple questions:
1.  How can I know the actual size in KBs of each table in my database?
2.  Is there a way to force a database attached to a program I've written in
VB to regularly compact just certain tables rather than the whole database