I am creating a drawing/document database to maintain a listing of drawings. I also wish to store file paths and file types. Each drawing or document will...

Some one created Access program in 2002, there are a few linked ODBC tables. Now we need to change the Server Name and Database Name. How can I do that? ...

This is my first try and am trying to teach myself from a book. Can anyone tell me the answer to my question?

Hello, I am creating a new database and would like some help/ sugguestion on how to best design it. I want to track where the carts are located on a daily...

I have Group of 3 tables Schedual, Maintence and MainEvents. For each day there are 2(day and night) records in schedual and for each one of thse there can...

I'm searching for a "simple" example of Reading in an external file (.tiff or jpeg etc.) Then saving it to a table so I can link it to a record. Suggestions?

I thought I could build two tables, each including identical fields of Group and Office_Sym, and create two simple joins in a query, but when I build the...

Seriously... if I have, for example, employee numbers in an Employees table, should I use the employee number (will never change) or should I add an...

Hi, there, I am building an invoice form which needs tax exemption case. The first step I took was adding yes/no data type field to customer table. Then, I...

Access 2003 - how can i create a date field containing a future date such that on that date, an email with a standard, fixed subject line & no body text will...

Hello, just looking for a templete that trackes medical providers and updates etc. Instead of having to create from scratch. Thank you anyone out there who...

I started building a db for laboratory Blood testing. Main Purpose is to make labels for all tubes drawn for the patient and also to track when certain tests...

I'm looking for some direction on creating attachments. We receive letters from our members, the letters need to be scanned, then attached to their record in...

Let me simply explain what I'm trying to do and maybe it will make sense. I think it's a fairly easy thing, but I've been looking at the DB too long. Any...

I am well aware that I am in need of some training/learning. I have a basic understanding of databases and hope that it doesn't make me more dangerous than I...

Hi, I am creating a field the states the relationship of a survey respondent in relation to the head of the household. These are coded - 1 = spouse, 2=son,...

Is there a prevailing wisdom on whether or not tables with many fields should be split into 2 or more separate tables? I have a situation with one table,...

Hi, I have a form, and on that form I would like a control that tells me if the record I'm looking at has a related record in a related table. I would like...

I've checked out AYS, but it's a lot more complicated than I need. I need 2 people to rank 69 employees on 4 questions, each having a possible 3 answers,...

I'm trying to think through the best way to normalize this data. It will be my first database. I'm working with Access 2003. I want to create a database with...