I have database that is stored on a shared network drive, its size is 685mb,
to Compact and Repair I copy the database to my desktop, Compact and Repair
and get it down to 73mb, I then copy it back to the network drive. The
problem is that in 5 to 10 mins. it goes back to 685mb. ...

Goodmorning,
I have a database of student ID Numbers(8 digits) and a CD with student
photos.  I need to add the .jpg extension to all 2,510 of them, so I can use
a BLOB utility to embed the photos into the database.  I have used the

I am trying to make a small database that has 8 areas/colums ....Job# | Date

Comments|
One of the problems that i am having is getting the subtraction from Time

I have many forms in my database that have the same buttons like save,
destroy, go to next.
Do every form does to have it's 'own code'?
I mean if instead of using commandbutton names with numbers I could create

I have a membership database with a form that includes member information and
a place for a picture. All I've been able to do is link the picture to the
form but when I click on the picture window I end up with a full screen
picture, not in the form'sw object box. Go easy, I'm a ...

I'm still cutting my teeth when it comes to Access. I have been given
an existing Access DB to modify. The problem I have should be simple.
There is a form with a Purple border on the left side and I need to
change the color of the border but I can't figure out how to do that.

I'm extremely new to Access, so I'm sorry for the stupid questions.
First off, I need to know how to add a second table to a form once the
form has already been created... I've searched high and low to do this
and cannot seem to do it. I really dont want to recreate the form

I wish to set up a membership database that will keep details about my
members and the equipment we install for them. I also wish to keep
track of all items we have in stock and out in the field. When we
create a new member, I wish to be able to dedicate pieces of hardware

I have an Access database containing two tables.  The first table
(tblSource) contains an OLE field in which Word documents are embedded.
The second table (tblDestination) is similar to the first one, as it
contains also an OLE field for Word documents.  I created a form based

What's the simplest way to move data from one table to another? I tried with
compination with make table query and delete query so that I made a new
table from data (marked with boolean) and then delete query to move the
objects from tha main table. Works all right, but it clears ...

I don't know if the template is a prober word for this... if so, I'm sorry.
I started  to work with my database and ever since used the same 'layout' to
do my forms that the wizard suggested. No I'm kind of bored to the looks of
my forms and reports.

I'm having trouble locating control panel , message  control panel disabled,
how to get it back

What's the best way to design a form to populate a table (tblPhase2), which
is related on a one-to-one basis with another table (tblPhase1) which has
already been populated.  I would like the user to enter the data from three
fields (which will be unique to only onerecord) from ...

I have a simple question: I have two tables, a student table and an
assignment table. The tables have been related through a one-to-many
relationship using the primary key called "student code". In addition, I have
created a form to enter student data and one to enter assignment ...

I am TRYING to find the table, form, and report objects.  Anyone know how to
get the Database Window to come up initially so I can name it and begin
entering my information, etc.?  I'm very new to Access and have been trying
to learn, but can't find this window!