My current client has assigned an architect to design the data model for our application. Our app requires a list of resources (people assigned to projects)....

I'm working on a DB for statistics for a small Hockey League. We've been using Excel, but it's getting more and more unwieldy. I've read elsewhere in this...

Can't figure out how to do something. I have two tables: TblCrew cCrewID PK Auto#) cFName cLName cCrewTypeID Numberlinked to TblCrewType TblCrewType

I would like some experts-advice ... I have: Developed a database in lotus-approach (97), wich is alive and kicking. Unfortunaly, this application runs only...

For Access 2003, 1) What''s the difference betwwen the 3 options in the "join type" section? 2) What''s "cascade update related field"? Thanks

In Access2002, what is the maximum number of MEMO fields that I can have in a single table, before getting an error? Thanks!!

hello i have a very specific need to have only 3 records in my "block serial" table to be related to one record in my "product serial" table. the company i...

I have a dependant's table with the fields for spouse, children, and additional (if you care for your parent's or other). Should these three categories have...

Hey Group, I have a table with the following Feilds: MobilePhoneID, PrimaryUser, DepartmentID, CallOptions, MobileNumber, SDC, GPRSTarrif (Lookup to Another...

I dont know if I have phrased this correctly but there must be a more elegant solution than I am using now. I have a database for managing education courses,...

Hi folks, I have a continuous subform on a main data entry form. Each entry on the subform contains two controls - a combo-box and a textbox beside...

Hello, Hope I'm using my database design terms correctly, and that this make sense. In a secondary table, I'm using the Lookup Wizard to look up a values in...

Hi, I would like to use MS Access as database for my application. Program will be made in VS 2005. What MS Access version is best to use, 2003, 2002,...

I can't figure out what the rules are for foreign keys in tables. For example, M:M is easy -- the table includes the PKs of the two related tables. In a 1:M...

I have several many-to-many junction tables. I'll name three: PeopletoCountries, PeopletoTopics, PeopletoInfotypes. My ultimate goal is to show the mapping...

Hi I am trying to build a "front end" to an application and am having some difficulty. Here's my problem: I would basically like to be able to do via a form...

Hello, I have a 2003 database converted from Access 2000. Several tables are linked from an Excel file. None of the linked tables appear in the Linked Tables...

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...

I calculated downtime using a query and now I need to change negative numbers (not downtime) to zeros. Please let me know how I can do that. Thank you

In general are multivalue fields a bad idea to use? I am trying to ensure my small database is normalized as possible, but it seems that I every table I try...