Several times I have attempted to create relationships between tables, and am studying index types, key fields, etc.  I just can't get it to work the way the books says it's supposed to, though.  Then, when I try to start all over and delete the relationships that aren't working, ...

How to determine number of objects in db for max size/complexity?
I'm doing a sorta large project, and am aware of the 700 (roughtly)
object limit in Access.  How do, or, CAN we find out where we are on
that count to see if I need to split my application into 2 db's, or what?

Hi. How do I allow the user to select a logo/picture on a report from a
form? I guess I have to use some OLE frame (unbound or bound?) on the
report. Would I want to use a picture on the users local computer and only
store the path so that the database wouldn't grow too large?

Ok here is the situation.  I have just started learning and using access in
conjunction Coldfusion.  I am learning about tables and things and have made
a pretty good data driven site using simple SQL queries.  I have a database
with product abbreviations, price and other things in ...

Is there a easy way to choose how many records to choose
randomly. I built a query to randomly pick how many
records that I want and know how to set the amount of
records that I want in the query design view. What I want

I have built a table that I am populating from a .dbf
file. I have 3 columns that are giving me a problem -
debits, credits & balance. After populating the table, I
have selected records that have a null value - there is

I've been trying to write a query that does the following (I'm failing miserably and haven't found any examples to do this although I suspect it's such a common task there should be heaps...and yes I have zero experience with sql
Say I have a number of columns and that one of ...

I'm having problems with my back-end Access 2K database. I have the latest service packs of Access and Jet
When I run 'compact and repair', I get an hourglass and it runs forever. In Task Manager it shows no activity for msaccess.ex
Anyone have a clue what is happening
I have never ...

I work for a wireless phone provider, and every now and
then other carriers will send us a document called TDS.
Right now I have a database that shows the name of the
carrier, and what date we last received a TDS from them.

This my sound silly but I just have not been able to figure it out. I built a query to run on my table and everything works great, My problem is the popup box. Is there a way to change the display name of the popup box?
at the present time it displays the expression " ...

This is a database designed to be used by a data entry person.  I plan
on eliminating the normal navigation buttons on the menu bar so that
the only button that appears to the data entry person is a "Close"
Button.

How can I override the 'Memo' field size 255 char default
to the 65,535 char that the MS Access Help says it can
contain?  I need enough space to contain long notes and
medical reports and 250 char is not enough. Help tells me

I've been reading how to work around inability to open attachments in Outlook 2003. Went to Tools/Options/Securit
and couldn't find any tab or other way to control attachments in Outlook. Can't even open .doc files. (Home office system,
no administrator or server, just frustrated ...

Does any one know if there is a record limit in a table in Access 2000
Also, is there a recomended limit
Thx in advanc
Billy

Windows XP and Office XP
I import data into a table from a text file. The two fields are "Idnum" and
"Idtype". When these fields are imported, they represent social security
numbers and entity numbers in the "Idnum" field and either an "E" or an "S"