I am fairly new to access so maybe this is a simple
question.  I have my tables in one access database and my
queries and such in another.  both files are in the same
folder on my usb flash card.  I am creating the database

I have a database where I created a query-by-form form.  
Everything works fine with the form, except the field
StartDate.  It does not find any records, even though, I
know there are records it should retrieve

am about to do an access database that will store
information about projects, so far i can visualise a
client table(client id(p.k..), client name, address etc, a
project table(proj id(p.k.) client id(f.k.) proj name,

Can anyone guide me on how to add a photo into the access data file
I also need to be able to select a record then one particular photo is retrieved accordingly
One member's record for one member's photo
Please help.

Am running Access 2000 and when I try and increase the
number of characters allowed in a text field I am getting
a message which says:
'Too Many Fields Defined'

I have four tables that DO NOT share information, but DO
share the same field names.  I need to create a report
that draws information from all four tables during a
certain period of time.  I can not find the syntax in SQL

How can I programatically delete table relationships? Any
help would be greatly appreciated.

I need to create an access database which will catalog scientific documents saved as pdf files. Is there a way to link these files and also search them by keywords in access. The form would then display all the documents found that match the keyword.
Thanks, Ann

I'm new to Access and just learning so this may be a very
basic question.  In my table I have a field for location,
phone and fax number.  I have 15 locations.  I want a
specific phone number to prefill in the telephone and fax

What is the maxium size of a database can Access handle
before shutting down. I have a access database that's
growing quickly and need to know when I exceeded Access
limits.....

I'm a new access user and I am making a database that
will be a mailing address database as well as track
conference attendance (15 conferences total).  The
problem I'm having is how to do this second part.  I

I've read in several places that when an Access 2000 query
pulls data from a table, the field type/size is
inherited.  Does anyone know if this is true for Access
97?  My data is getting truncated when I run the query.

I am using Access 2000 on a company LAN, and I had
established links to two tables in another database.  The
source database for these two tables was moved to another
network share, and now I get the message "Share XXXXX is

Hi Group
Anybody know where I could find a Example of a simple stock control system?
Many Thanks
Merlin

We have four types of companies in our (to be implemented) database, which
are Title Companies, Real Estate Companies, Suppliers, and all others.  Some
of the drop down lists in some of the forms should be limited to one type of
company (e.g. Title Companies).  I see at least two ...