I'm very new to Access databases and I'm trying to set up a system for a DVD
rental shop. At the moment I have my tables set up as below, but I've been
told that this is not normalised and won't work properly. Apparently I need
to add another table. I'm also not sure what type of ...

I am very inexperienced at database design and am saving huge problems.
I am trying to construct a Db in Access 2000. The data is based on
information from  client files and questions, as well as dates of the
questions. The time scale from an initial event is important and will ...

I am trying to create a linked table from Access to our AS/400 database.  I
am basing my macro on an Excel macro that uses a SQL call to download data
from the database.  My code to build a table using ADOX is below"
Private Sub CreateAS400LinkedTable()

I received this message after adding a "bit" value to a table.
The error message box reads:
This record has been changed by another user since you started editing
it.

I designed a huge database 10 years ago. I finally am going back and cleaning
things up. There are several tables that I used a text field as a primary
field. I would like to delete the relationships, create an autonumber field
for each table, and recreate the relationships. I ...

Is there a way to create lookup tables , as in the table analyser in Access
2007, for access 2003  mdb  database?
I used table analyser on my accdb file to create more tables with
relationships, but this method won't work on a mdb file, so Access 2007

I think this should be easy but cannot get my head round it.
I have a database that includes a table of clients and a table of contacts.  
Each contact is linked to one client.  
When I input a new contact (John Smith say), into the contact table and

I have designed a table with a hyperlink field containing links to files on
the PC. Is it possible to send these files as attachments on a email?

I am somewhat new in this so any help will be highly appreciated:
Problem:
I have a large number of objects that may be of type: A, B or C and subtypes
a1, a2, a3, b1, b2 where a1,a2,a3 can be associated only to object of type A

I have a question. Reading about lookup tables, (e.g. tax rates for
different states) should I connect these lookup tables to my Data tables
(e.g. Customer Line Item Invoice Table)  in my Relationship window or should
I just created a combobox with a record source being the tax ...

Hi Experts:  I'm trying to create a lookup table from the below text
file, here is some data:
ID   Field2    Field3    Field4
2122                     TOTAL SCH RC-26.B.

I'm trying to copy files from one folder to an archive folder on the same
drive. I'm using the code below which I thought may work, but I get an error
"Bad file name or number" on the "strFileName =  "*.*"" part. I sure it’s the
wild card bit that’s giving the error.

Question
Subject: Relationships - I am issing something   11/18/2008 5:01 PM PST
By:    dwilliamson  In:    microsoft.public.access.tablesdbdesign
Have a database with two tables - tblSite and tblInsp. tblSiteID is PK and

I am developing a database for sage grouse breeding areas, known as leks. I
am having trouble trying to delete a
table that has been populated with data using an update query. I have three
tables that I use in the following

I want to format a field in a table to take either dates or text.  Now if I
format it for "short date" it won't let me type in text ie:  N/A or not
needed.  Can this be done?