In my database, I have Products table and Orders_Details table that contains Product_ID field and they have one to many relationship. On Orders_Details...

I am trying to create an operational database. We hire temporary staff through several different employment agencies to complete work on projects for various...

Hello: I want to tell you about a great site I found. They pay me to read e-mail, visit web sites and much more. It's free to join and easy to sign up! CLICK...

Good morning, I have a database which will be used by more than one user. I will have the Design Master copy in my network private drive and a replica copy...

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

Hello again, The boss has me working on another database. I guess they liked the first one I created. Anyways, I'm pretty sure this one is more complicated...

Here is what I have so far (on paper, not in practice): STUDENTS (table) StudID (PK autonumber) StudFName, StudLName, StudAdd ....& other details, also, I...

I'm sure that you've probably guessed why I'm here. I have three tables, a Person Table, an Item Table and a Sub Item Table. I want to create a fourth table...

Hi All, I am working on a scheduling program. We need to schedule shipments of orders and pull from stock. The orders would be in a FIFO method or First In...

While compacting a db from 46 to 9 megs over a network drive, I got ErrorCode ErrorDescription ErrorRecid ErrorTable -1611 Could...

What is the maximum size of a database with access 2002, permetting to avoid the error code 3036, "the database have rearch is maximum size" ?

I'm trying to establish a medical excel file for my mother. She has a complicated medical history and everytime I think I've created an effective excel chart...

I'm trying to set up referential integrity between two tables. Here's what I have: Table 1: Primary key is made up of two fields: Field 1: Month * Field 2:...

I have a customer table that lists all of our customers, and a contacts table that lists all of our contacts. Now it has been decided that rather than just...

I am using a textbox, but there is a limit of 255 for the field size. The question I have is there anything I can do to make the field size unlimited or at...

I need to set the Allow Zero Length property of a column to true programmatically. Is there a way to use an ALTER TABLE query to modify an existing...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

Hi, How can i query/get the following in an MS Access 2002 Database: - 1. List of Indexed Fields in the MDB 2. All the Primary Key Fields in the MDB 3. List...

I have a database that is used to tally quiz results. The DB has three tables, one is where user information is collected including their answers, the second...