My database is 49MB.
Compact on close always lock up on closing. I often have
to end the task through task manager.
Is there something I can do to eliminate this problem?

I would like all my tables automatically refresh the link
to BE when the startup form open.
Can someone instruct me how to do this?
Ashley

In MS Access there are masks available to restrict input info. Are there
such masks available in MS Excel? I specifically am looking for something
similar to MS Access' InputMasks fo use in MS Excel. My purpose is to
restrict the nature of input into a column reserved for dates only ...

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 ...

I have a two field table, where the first fields allows a
user to choose from a drop down box a list of categories
(from a table).  
Based on their choice of category, the computer runs a

Does anybody know of a workable Input Mask for a Postal
Code.
Thanks
D

How would I go about limiting a record's existence in a
table by the following criteria.  Field A is not null and
field B is not null, or field A is not null and field B
is only null once.  

Every time I enter the number 1.10 in the field it changes
to 1.1
I need the field to be able to hold the following number
pattern

Newby Access-SQL Server Question:
I have an Access front end and a MS SQL Server back end.
I imported the Access tables into SQL Server.
I have an ODBC connection to the SQL database. I am able

I have 2 tables with the same fields.  How can I move the
records from one table to the other?

Hi there -
I have a relational database with 10 tables. They all have
the same primary key called, "Agency". (all unique names)
For example, one table holds the agency's mailing address,

This is an access question not a c# question. I am using c# to build a
knowledge base using an access database for my company. We have multi-apps
that we use, how do I build my database. Should I build a table for each one
like:

hi, everyone
i have a problem
table a
inv#    amount

I am trying to have a PO# field on a form enter an auto
number but only after the authorization field on the same
form is filled in on a form.  The authorization field is
part of the same table (PO # Table).  The PO# is related

I have developed a database for a small electronic shop. It works quite well
except that I need to address to some areas such as managing items with
serial number and maintaining warranty for some serialized products. I have
a barcode scanner that can facilitate in reading the ...