Is it possible to link to tables in another database that
are linked from a third database? Or, do I have to link
directly to the third database?
Hmmm, I think I just answered my question. lol

When I open one of the tables in my database in datasheet
view I receive message as follows:
"The number is too large" and "OK" button.
When I press OK, the table opens.

Twice today I have run into a situation where i could not
delete an ldb file of a database that was closed.  In
both cases I had to reboot the system to get rid of
them.  Is there another way?

I know how to add a field using code, I tried to insert a
hyperlink field into a table using the following but it
doesn't want to play, any ideas
dbs2.Execute "ALTER TABLE settings ADD COLUMN rc2ftp

I want to validate the entry into a column based upon the values in another column in another table. I can't get the syntax right. I have tried 'In ([sourcecode]![accptsource]) and In ([sourcecode].[accptsource]). It works just fine if I use 'In (sourcecode)' but that isn't ...

I'm using the following VB coding to create a new table in
Access 2000.  My problem is that the Required property is
set to true.  How can I set the required property to false?
Dim tblPointFlowCurr As New ADOX.Catalog

I have a table with two columns 'Engagement Manager'
and 'Project Manager'. I want to link both of these
columns to my Employee table.
I set up the first relationship but when I try to set up

In a database, can you have two entities that have the
same primary key and then link them together.
e.g
X = (r1,r2,r3 etc...)

Does anyone know how to create a flash screen where I can
display my copy rights

I'm getting a really strange error when viewing a record
on my database.
I have 3 memo fields, and two out of the three in one
record has '#Error' in its contents.  When I attempt to

in my table i enter the date on each reccord and i want
the table to automatically flag the data that is 4 days
old by making it red or something, anything will do please
help

I've got a music database with fields for Artist and
Title, amongst others.  They appear on a subform
frmMusicDetails placed on the main form frmMusicRecords.  
I've got the Artist, using DISTINCT, to only list each

What are the differences/advantages of using 2002/2003 file format for a new
Access database vs. Access 2000 format?  Is there anything I can't do if I
use 2000 format?
Thanks!

I get monthly information updates that I am able to import
into a DB. This information is in the same format all of
the time. I have gotten the information into a new table
in the DB and would like to know if I can "merge" the two

I have 4 tables linked together with the primary key of
client number.  This is a autonumber field when data is
entered into the form should create the same number
through out the other tables as client number 1.  When I