Why do some programers use Front End/Back End (in other words two .mdb files linked) rather than using one .mdb
What is the whole point

Access 2002.  This error just started happening.  When I
try to open the database (HDH.mdb), and another user has
it open I get the following error message:
The table 'MSysAccessStorage' is already opened

Does anyone know if it's possible to audit entries made to MS Acces 97
tables?
I have an excel 97 solution which serves as a front end which writes to the
backend DB. Using Access' white paper, I've secured the database (users need

Hell
O.S.              Windows XP Professiona
ACCESS        ACCESS 200
EXCEL           EXCEL 200

I am using Access 2002 SP3 and I have a large table with
2.6 million records and some other tables totaling approx
125,000 records.  On the large table, it was imported as a
text file and now if I try to change the length of a text

I have a database built and I have a line of code to go
out and get the first two numbers typed in. I am useing
the code like this
Private Sub TxtEnter_AfterUpdate()

Can a memo field be reduced from the 65,000+ character
size but be more than the 255 text fiel limit

I have the following challenge ahead, can someone please
offer some advice?:
I have a database with several peoples' measurements. I
created  the following table structure:

I have a database which records service returns. I need to highlight a record in red if the field called "in progress" (the date a job is started) is null, and the current date is more than 10 days after the date entered in the field "Date R'ecd" (the date the unit was booked in. ...

After importing FoxPro databases, how do I figure out there relationships?  I don't see any unique keys

I attempted to import an Excel spreadsheet and create an
Access 97 table. When I get to the last step "Import to
table" and click on the "Finish" button, I get a "Disk or
network error" message. Does anyone know what is causing

I need to set the format property of a text field so that
it formats using Titlecase...I want the first letter of
every word to be capitalized.
I've already tried the syntax below and it doesn't work.

Hello Access Nation
If possible can someone help me with this problem.  I
have and option group with 6 buttons. The choices are
negative, positive, dillute, leaked, damaged in transit,

I currently have a table that has data in it.  I would
like to add an auto number field.  Every time I add the
field, make the datatype auto number the numbering will
not start at 1.  I have set the field properties New

I'd like to make tabular forms for each table seperately
in MS Access. Each table is different content. If I click
form to create one by one, it will waste a lof of time as
over 100 tables. It is better to onclick to create all in