I'm looking for advice on a good design for what amounts to a 2
dimensional sparsely populated table (or matrix), considering speed,
storage and ease of use with queries.
the intended use is to simplify and centralize the data of multiple

I tried to convert a back-end mdb file created a long time ago with Access 2
( the system is still working fine ! ) to Access 2003 and after it finishs
there are some errors related to indexes.
There is one table in the Access 2 file that has about 40 relationships

Hey Guys,
I am trying to create a schedule database for employee that do their jobs
based on a 30 minutes blocks. example
employeeA starts shift at 9:00 AM and Ends at 5:30 PM this employee would

I am sending a CD of a Power Point slide show to someone who does not have
Power Point on their system. Is there a way for them to view the slide show?
I already had them dowload the viewer from Microsoft, but they still can't
open a file with a pps extension. I have saved the my ...

As far as a Primary Key is concerned (for an Employee Table)
I have read numerous times on the boards NOT to use the Auto Number feature,
I'm not sure exactly why, although I could see  where the random number can
confuse some.

In a table, I need a field as a counter of each record, unique, sequential
and sorted by the sequence of data entry of each record; the field by
autonumber format is a good idea, BUT at the time of adding a new record if I
press ESC key (abounding of adding a new record), of ...

can i allow the user to do his own coloring and formating for the texts that
he writes in a text box ??
just like his typing in microsoft word.
thanks in advance

Currently doing this all on paper.  Here goes.
Presently the top part of the DAILY Sheet lists all available trucks to use
in order of union priority. there are some other columns that go with each
truck

I have a database of purchase order information and I would like the puchase
order # to automatically populate.  The first two numbers are the Fiscal Year
and the last 4 are the purchase order number (060001, 060002 and so on).  How
can I get that field to automatically populate ...

I've been reading lots of posts regarding not showing Primary Key autonumbers
to users. Could I ask, why is this a bad idea?
I've designed a DB for handling purchase orders. The primary key of the main
order table is an autonumber field. I use this autonumber field to generate

I'm maintaining a database (I did not design it) that has three MDB files.
One MDB is a front end, one is a back end and one functions as both back end
and front end. The purpose of this set up is security. One front end is in a
folder with different access permissions to the ...

I have a table where the uniqueness is based upon three fields. One
field is numeric (integer) and the other two are text.
I really don't want to make a 3 field compound key for various reasons,
however, I need to ensure that there are no duplicate records in the

I am designing a clocking card database & found the Microsoft article How to
Calculate Daily Hours Based on Clock In/Clock Out Times here
http://support.microsoft.com/?kbid=237958.  It suggests having 3 tables:
Employees (EmpID, Name, etc), EmpDates (EmpDateID, MyDate, EmpID) and ...

If I am trying to create a multipage form, after I make 3 pages on the 4rth
page it won't allow me to add any more controls and will show me a query that
" No more controls can be added to this form, if you have deleted any
controls close this form and reopen it"

I have a lot of data in one table with about 10 columns. Two columns
are not
independent. Column A stores the foreign key of table A1, column B
stores