Hi guys I have two tables that I have a one to one relationship, both have identical primary keys. When I try to enforce referential integrity I get...

I have copied some Access 97 from work to update on my home PC, they install OK but if I try to export them to Excel or another Access database it says they...

I've read the help info several times but can't understand something basic: I want a field "tax category" that limits my choices to several tax categories...

Hi, I have a long email list (about 9900) which I'd like to convert into a table (now empty) having the following columns: EMAIL_ID...

When I create an index on a table, and then link it from another database, the link doesn't show the index. Am I missing something here? Shouldn't the fields...

How to..? I want a field in a form to available/not available contingent on data in other fields. For example, if Field 1 is a checked checkbox, then I want...

I have a relational data base with among other fields: LnameHusband and LnameSpouse and Occupation in the Main table. I have set a one to many relationship to...

I am doing a supporters club booking system for Leeds United, (for school A2) I have a field with every match, then on the left, the members are listed,...

I have two tables (Main and Detail) which have a one-to-many relationship. I need to tie into some company information and have been given links to two tables...

Are there any sample databases available within Access 2002?

We are putting together a Question and Answer database but need to put formatted text in the fields (super/subscript, italics, different fonts, etc)....

I would like to send an email to many people, but have them think they are the only ones... in other words... just have their name appear in the 'to' box, and...

Essentially what I want is simple. I have two different tables. Both store the same records, but each one stores different information about the records. ...

I have an Access 2003 database that I need to run on PCs without Office on them. Do you know is needed on these PCs to run a access2003.mde file?

I need help in Access if someone could help me write the formula: An employee starts accuring vacation from the Date of Hire (conditions: if he starts work...

I am working on an existing database that has over 500 forms in the front-end and is linked to various back-end databases (some Access, some SQL Server, some...

Hi. I have a flat table of all my cd and mp3 albums. Fields are Artist, Album, Size, Format, and CDR Number. Currently no primary key. I am thinking that I...

I have a query which includes a field - 'Risk'. This is rated on a scale of 1-10 and is calculated from 2 other fields 'Severity' and 'Likelihood' in another...

I have a db with linked tables. The relationships window shows multiple instances of the master table and it's links to the other tables. The db works fine...

Hi, I am trying to design a new db for a local museum where the items are placed in different houses, rooms, pieces of furniture and drawers. First I thought I...