I am developing a small Access97 database and attempted to
compact it.  The process failed and I checked out some
websites that recommended that one use the jetcomp utility
from Microsoft.  This seemed to be successful and when I

I have a database that has active & inactive names I
cannot separate them.  Is there a way to color the row
that is inactive.  I have tried but the whole database
changes to the color I choose.. Any other suggestions

I have a field of Autonumber in my table i would like to
start at 50000 so i use the method of appending a record
with the value that i want the auto number to start at.
it worked the 1st time and then i had to delete all the

I'll preface by saying I'm not sure where to best post this, queries or
tabledesign.  For a study that is being conducted, I have a test table that
holds 4 million records, patient demograpic information with "test result",
one record for each "test result" for each date and time ...

Is there any way to increase the Access Index Limitation?
Number of indexes in a table 32; how to increase this value

Is there any way to increase the Access Index Limitation?
Number of indexes in a table 32; how to increase this value

if i receive a string of data and AAABBBCCCDDD and after
every 3rd letter, i want to insert a dash, how would i go
about doing that?  sometimes the data will have just
AAABBBCCC, AAABBBAAACCCDDD, AAABBBCCCBBBDDDAAA, etc but is

I have a Products table containing the usual product fields such as
a product number, description, and so on w/ an AutoNumber set
as the primary key.  I'm attempting to find an efficient way to link
"related" products together for query purposes.

I am trying to write an if statement to open a form based
on a value in a table.  In other words if rates = 0 then
open form1 else open form2.  Is there a way to write that
in access.

I need to create a database that will store individual resident assessments.  One resident will have more than one assess over time.  The score decides what level of care a resident needs.
Now, would it be best to just have one table that has the resident names and then another ...

Using Access 2000.  I have applied a filter to a table
with good results.  If I apply another filter while in a
filterd view am I filtering on the results of the current
filter or is the filter applied to the original table?

How do you stop the program database from growing each
time it is opened.  I have created a switchboard to work
off of(using forms).  I understand that if any of the
forms (program database) are opended then they need to be

I sent a database to a customer that was divided into a
front and back end (so I could easily update, of
course).  Now, however, the customer wants to make a
change that affects the backend....we simply need to

I have Access 2000, and I imported an Excel spreadsheet as
a table in Access with no probs.
I tried to setup a field in my main table as a Lookup (no
problem), but when I attempt to bring the 2 columns across

I have been working on a database(new to access) so in the
process i have been deleteing and creating tables.When i
go into RELATIONSHIPS and show all....a maze of tables
with connecting lines appear even though i thought they