Is there any way you can restore a deleted table or object in an Access
Database if the database has not been compacted and repaired

I have an Access DB that grows as the users use it. It
starts out at 8000 kb and then grows to 111,000kb by the
afternoon. I compact and repair, but I do not understand
what is causing this. Please help!

2 questions
I have a field called flight number inwhich I place a
carrier code and a 4 digit number
Can I arrange the entry so that only a specific 2

I am writing a program with Access using VBA.  I have a
table and need to do the following:
- stop Access from automatically creating a new blank
record

I am trying to create a unique composite index. The index would use two
integer fields and two time fields. Access keeps complaining about creating
the index. I have stripped all but 4 records, so I *know* they aren't
identical. However, Access insists that I would have duplicate ...

I am unable to make any changes to my established
database design becaue every time I try to change I get a
too many fields design. I only had 13 line items in the
database, so I deleted them and I still get the error. I

I have 3 fields: Name, Date Sent, Recipient.
How do I require them to fill in the "Recipient" when they
fill out the "date sent"?
Also, is there a way to "auto -date stamp" a field based

I want to replicate my database and see from a posting in
the Replication newsgroup that it is advisable to create
a Front End and a Back End and only replicate the Back
End.  

I want to create a welcome screen to my database application. I've seen
people doing it, but don't know how to do it.
Let's say I've created a picture (.bmp) format, and i want whenever people
open my database, it will show first this picture for a few second then, only

Ok guys heres the deal.  I am working on designing an
inventory database.  What I would like to do is create a
database of all of the equipment that I am responsible
for.  These items are made up of a large number of

Dear Newsgroup member,
I am from India and I want to maintain my contacts in
address book and contact management database in MS-Acess.
But the setting of the Acess is as per American standard.

I have a table which displays current DATE.
Can anyone tell me i can append the corresponding DAY of
week to it or in a another field.
Example:  Tuesday, 14 September 2004.

I want to stop is false data being entered into my
database. One problem I have is that you can input a start
date, then you could enter an end date that would be in
the past.

Okay, here's my question.  How do you handle OO design
with inheritance?
For example, lets say we're developing a Real Estate
application, using .Net against an Access DB (Or SQL

I set the decimal places function to 2 in the Table Design Properties. MS
Access rounds the number to nearest integer. How do I overcome this
malfunction?
I have tried to delete the field and then reincorporate it and I keep