I probably should have been more specific . . . in my
example, [Field2] is a HYPERLINK.  I am using the [ID]
field as the filename of the file that will be launched
by clicking on the hyperlink.  The "ABC" is actually the

Is it possible to set the default value of a field to
include the data from a different field in the same
table/record?  Example:
Record 1

hello, I´m a new user of microsoft access. I´ve working on
a database creating the tables and one table has 112
entries and when i try to save it the program told me that
there are too many fields defined. I reduce to the half

I'm using ACCESS 2000 and have set up a form which is now
in use. I'd now like to update my form with some extra new
fields which I have added to the table. However they do
not appear in the field list and there is no option to

does anyone know what is the maximum number of fields that can be updated at
once in access 2000
i am updating approx. 150 at once and keep getting this error:
Microsoft JET Database Engine error '80004005'

Hi, I would like to know what is the maximium size for
the Msaccess database.
Rgds
Henry

I am pulling information from a linked table SQL Database
into access 97.  This table will be continually
changing.  How do I select a record and add it to another
table?

I have a problem with cascade delete deleting all of the records on th
many side when a record in the main table (one side) is deleted.
The database has 6 tables, but these are the 3 tables I'm havin
problems with cascade delete:

I am creating a time card database but i have a question in how to designate primary keys.I only have two tables, one for employee and another for timecards.It will track  the hours of twenty three employees that have a employee number and i thought i could use that as a primary ...

I am writing a database for a friend of mine who is a realtor.  One of the
tabs on her client form is going to contain pictures of the properties.
Since a property can sell and go from one owner to another, I have the
property in a table separate from the client.  I still need to ...

can i read and store barcode
in my database

I am having troubles with the Linked Table Manager. When I
invoke it with the check box to prompt for a new location
I get a message indicating I do not have access to a
specific directory which under the database options

I have a customer table that lists all of our customers, and a contacts table that lists all of our contacts.  Now it has been decided that rather than just knowing the *title* of our contacts, we should also associate each contact into one of 30 predefined "roles". (this because ...

Need to change where Access looks for linked tables to a
different port rather then the typical port 21 for ftp.  
is there a setting within access to change this?
ryan

I have an old database which they want to add some complex
relationships to now:
They want to put in: up-to ten Fee Codes (Fee Code Charged-
1 to 10) by Vendor Contract Num by City - then lookup by