Can anyone give me some advice on designing a table structure that can
represent joint accounts in a donor/donation database for a small college?
The database currently has over 50-60 tables and is far more complex than
this, but essentially, there is currently one Account table ...

Just a thought. If 2GB is the "upper limit " for Access db, it would appear
that this is beacuse at this size , there would be millions of records that
may overwhelm  the Jet database engine. On the other hand, when images are
embedded in the record ( we will not dicuss the pros and ...

hey all,
does anyone have any links to look at some common data models for Employees
table?
thanks,

I've been given an Access front end to a postgres DB.  The initial developer
had told us that Access, in order to function properly with nested forms
requires compound PK's.  We'd like to normalize our Db since this compound
PK's is causing many issues with our other software.  ...

I am in the process of setting up a database to manage subscribers to a
newspaper.  I have a field for subscription start and another for
subscription expiration, the start date is easy, =date(). The
expiration date is a little more difficult.

I have a field in an purchase order database that I am trying to create in
which I would like to be able select multiple records from another table into
that field and then be able to find that information by looking up the
purchase order and have it list all of those choices I ...

I am getting a lot of useful information and I want to store that info in an
Access database - to create a kind of Oracle.
I am sure there must be an access template that someone has already designed
that will capture this information even if it needs a bit of tweaking.  

When you create a Command Button, is there any way the Background colour can
be changed from the disgusting Grey colour to something more eye pleasing?
Thanks for any advice

I would really like to create a "Reports List" on my custom menu bar.  It
would list all the reports that are in the database.  However, some of the
reports require some criteria (i.e. beginning and ending dates, specific
customer, etc.).  So if they click on a report off the ...

How do you copy/paste a pdf file in either a table or through a form? This
feature is greyed out when I try this.

I am having trouble designing the tables and establishing relationships
for a survey database for the purpose of evaluating speakers for a
variety of events.  After every event, the attendants are asked to fill
out an anonymous survey assessing the overall effectiveness of the

I need some help in designing tables so I wont have problems doing
finals reports
Background:
Compressor manager interface. An interface that will do surveys from

I have an Acces mdb with odbc links to about 100 tables to an oracle
production database.  Is it possible to change the links all at once to my
test db without having to relink each one?
Thanks in advance for any help that can be offerred.

I accidentally imported some data which had primary key field values (MSID)
starting in a much higher range than I want this field to go to. Essentially,
they were imported with 10000 range numbers, though I want to keep our
numbering within the hundreds range. (This is a ...

I have created an employee database with a column for professional degrees.  
Some employees do not have degrees - so for them I left it blank.  How do I
pull up a query that will show only those with blanks - what is the correct
argument for a blank cell.