I have this message when I try to update information in forms based on
queries that have been created from two or three tables.
I have checked Help and searched this forum but can't really find the
answer.  I hav checked all the relationships in my database, adjusted a few

Okay i'm looking to create a database for deliveries. I want the deliveies to
go by projects. I am learning and i was hoping for some feed back.
I created a table for customers, projects, shipping comapnies. Now I created
a table for the deliveries which will pull information ...

When sharing databases on a network with multiple table links to other
databases on the network, I frequently get "read-only" when I open my primary
working database.  It seems to happen when the first person opens the other
db with links to mine and Access seems to think this is ...

I'm looking for a (preferably) free download or other option to try and go
through and do an S&R throughout an entire database.  What I'm doing is
carrying over one database to five different regions, and need to go through
and rename tables/criteria in queries/reports etc. with ...

I was wondering if there is a maximum number of rows in Access 97?
I'm currently parsing a text file and adding the values into a table.  The
files are a month summary and could have anywhere from 2,000-25,000 records
(rows) once all the parsing is complete.

I need to know if I create two fields in a table how I can have them filled
out automatically if possible. I want to create an insert date and an update
field for a table. Is there a way to have these populated automatically?

I have several many-to-many junction tables. I'll name three:
PeopletoCountries, PeopletoTopics, PeopletoInfotypes.
My ultimate goal is to show the mapping between people, countries, topics,
and infotypes, e.g.. for a given person, what topics, countries, and

I'm trying to store my MIVA products export in Microsoft Access. One of my
first challenges is the category codes in MIVA. Each product can have several
category codes. So I created a table with the category codes: i.e., AI = Acme
Imports, M1 = meditation, etc, based on my ...

There are several TEMP tables in my Access database that have essentially
the same fields, but are used to support different reports.  Each table is
emptied and recalculated each time the corresponding report is run.  Would
there be any performance advantage if I consolidated ...

First, I don't know if this is possible and second, I don't know if it's
best to use Access or Excel. This is what I want to do:
I have many instruments that I have to calibrate annually and every 6
months. I would have 5 fields: Instrument Description, Instrument

I keep getting a "TOO MANY FIELDS DEFINED" message when trying to add a new
field to an existing table with 22 fields.  This also happens when I try to
create a report using 2 of the tables in this data base.  I have tried
everything I can think of, but nothing works.

is is possible to make database window unaccessable to users (except for
admin) .so that they can use db thru swithboard.

I would like to use Access to manage my contacts.  Access has a very good
template for doing that.  I then want to export the data to Outlook.  The
field names and characteristics do not match.  Any ideas how to fix would be
greatly appreciated.

I am creating a scheduling database.  I think I have to have a table with all
of the dates from 2005 to 2015 (The table can be updated to add more dates
after that). The reason for the dates table is so there is a record created
for each date.  I don't want the user to have to ...

I am in need of a database to collect user demographics and survey questions
& results. I have seen that many people recommend the 'at your survey'
example by Duane Hookum, but I cannot download the database - I get an error
message 'not authorized to view this page' after I ...