I have a split Access 2000 DB with linked tables. I want to create a
standalone copy of this DB on another PC without having to manually link the
tables again because I won't be there installing it on-site. Is there a way
of linking the tables to the front-end by a relative path ...

In a table using access 2000 I can make a column's date format
as  mm/dd/yy.
I am not able to do this in 2002.  I get mm/dd/yyyy
Is there another way for a format date for mm/dd/yy?

John, thanks for the reply.  The column name is "PAT RELATION TO INSD" The
fields are populated with a "   X" or a "        X" or a ""   what I need to
do is replace the first with "Self" the second with "Spouse" and the third
with "Child".  Will an update query work for this? ...

I am setting up a form that has the user enter a NON-Duplicate part number, but I would like them to have to RE-ENTER the part number in a pop-up form field over the existing form to make sure their ORIGIONAL entry was correct.  
Then the box will close and they will be able to ...

The counter underneath the inbox icon in outlook does not accurately reflect
the number of unopened emails waiting to be opened - how can I reset it to
zero please

how do i set intel graphics

Is there a limit on the number of rows that access will find and replace.  I
am trying to replace a single character in a very large database for a single
column.  Access will only find the first 9494 lines and then stop.  Is this
the limit or is there away to replace all?  ...

I've been asked to design a database for up to 60 concurrent users.  The
awkward side of it is that the company in question use a mixture of Macs
(OSX) and PCs (XP) attached to an OSX Mac network.  There will be around
50,000 records altogether.

Your assistance is greatly appreciated :)... USDA new employee working with
an existing database in Excell that is not functional.  Would like to convert
the below database to an Acces database system.  
Vehicle License #    Year,    Make,    Model,     Color,    Date of Annual Inspection,       

I currently have part numbers that have DASHES in various locations throughout the alpha numeric number.  I have convinced the company that for sorting and Database reasons it would be better if users do NOT enter the dashes in the database.  
I would like to set up something that ...

I have a database with Ins Company info.  I have set up a combo box but would
like to have all other fields auto fill once I lookup the Insurance Company
name.
My fields are named as follows.   InsIntCP for Insurance Company,  

How can I link two tables within Access so that records entered into one are
automatically entered into the other?

I noticed that in a FE/BE scenario, you can set relationships in both the FE
and the BE and they are maintained independently.
Which end is the proper end to create the relationships between tables? If I
set them in the BE, does the FE know about them?

One table or two?
My main table has the following fields:
Enquiry_ID (autonumber)
Enquiry_Date

I have a problem, I am helping out a non profit group.  They are using
Access ver 2002.  They have a membership table with address info in it.  We
are in Canada so the Postal Code is in the form of K8N 3H2.  All other
fields sort fine.  With Postal Code when it is sorted there ...