I played around with the Table Analyzer Wizard. Is there a way to not use the wizard to split the database? I would like to have a few different...

Hi all, I posted earlier on a query that was doubling up the values and it was suggested that the query was somehow linked. So I'm going back to basics and...

i am using asp and an access database and here's what i'm TRYING to do i have 3 fields in the table (hrs_taken), (date), and (hrs_needed). i also have an...

Is it still 1Gb for the latest version of Access?

I am currently in the process of trying to create an Access Database Application. The database will be located on a local network and multiple laptops. In...

Working on a mailing list table with 10K plus records without any primary keys. Most of the time, have to import from Excel spreadsheets more reocrds. Is...

Please help me get started. I need two forms. Do I need one or two tables? Form one will include the primary key - ComplaintNo, which is an auto number, and...

What i would like to be able to do is to customise the error messages that appear in Access. For example when you create a Table and you specify that Required...

I have the following table:- tblPatients PatientID PK Forename Surname NextofKin NextofKinDetails

This question is about changing the indexed property of a linked table field from code. I'm using Access 2000 with SP1. What ultimately needs to happen is...

Access 2000 - I always include the autonumber ID field when I create tables, and they always start with the value of 22 instead of 1. This occurs in...

Hi, MS Access 2002 automatically creates an index when a foreign key (ie the primary key of another table) is added. Is this necessary or (at least) in ones...

I can get "no duplicates" to wotk fine on an indexed field but if I then create and input mask for that field then it is possible to put in duplicates. Thanks...

Hey all, I think I'm on the right track but I'm missing something.. I've got 1 table called receive with a receiver number (not unique) this table links to...

What is maxium # of records per table Access 2000?

I have a table that I have moved from Works. It is linked to another table so I can't modify it. Any Help would be wonderful. Riley Walker

I am developing a comprehensive database for my company. I need to have our employees start using a database to record time card activities ASAP....

Hi I have an Access database where I store my client data. I would like to keep my tasks in Access as well. Unfortunately, I have recurring tasks and I don't...

Good afternoon, I am currently working on an Access DB that tracks several Client Survey Questionnaire's. I recently attended a DB Development training...

I have a database made that will display tides for given locations on my website, but haven't been able to get it to select the current day and the next 6...