If I create a select query using more than one table I can not edit the
records
I get a message on the status line " The record set is not updatable"
How do I setup the query so the records can be edited

Using office 2k and windows XP
with a secure database. Logging in as admin I got
"unable to save database properties" in both the FE & BE
When I ran Access 2003 on same computer and open same FE, I could change

anybody have a good way to keep up with the correct connection string?
several of the access apps i work with use linked ms sql backends.
in this environment we use development, testing, and production
servers.

OK I have my 7,000 name index sorted by surname, say Smith, now I cant
figure out how to sort first names from Anne Smith to Zeta Smith.
Please help, thanks
Patricia May

Made a table and made a form.  Is it possible to enter information into a
form and use a command/control button for the information to "post" to the
table?  I notice that the field is updated each time a user tabs or moves to
the next field in the form.  I need to know what type ...

I restructured my database and now I find that the data in two textboxes
does not display when the main data entry form loads or is in focus after a
different form has been opened.
The data in the textboxes used to be in the table that the form is based on,

I have a date/time field in my record that I plan to use to indicate when a
record was modified.  If the record was never modified, I'd like that field
to be blank.  It seems to want to default to 0 which is giving me a bogus
time of 12:00.  All my records are originally imported ...

I have a subreport that displays/prints from one computer but displays a
blank box on another computer. Both computers are set to the same default
printer. Any suggestions?

Is it possible to modify the following code to search an entire table
instead of just the studentid? I have a single table named tblscanlog with 9
fields including a PK. I would use the same control names.
Thanks

Hi, all
I want to share one data base file with two computers, may file contains
query, forms & reports. So please I want help step by step to create this
sharing and how it will work.

I am creating a table.  I the "data type" i selected memo.  According to the
help section, this can be expanded to accept up to over 65,000 characters
through DAO.  Can someone please explain how to do this.  Thank you in
advance for your help.

Hi - I created a custom report to look like a current form we use in our
department. When I run the report, it shows all 1500 records.  Is there
anyway to print individual pages in a report?  I am new to Access.  We input
many Serious Adverse Events for the Oncology Research ...

I have a DB of rates.  The rates change.  Therefore they have effective
dates.  I want to pull the Max effective date that is less than the Freight
Tender date.  I have included the SQL below for your reference.
SELECT qryGetBasePerContainer.[Broker Ref #], Max(tblOcean ...

Another organization generates a database in Access 2003 that I have to
interact with and send back.  I am using Access 2007.  The error message that
I get is to the effect that the database or project contains a missing or
broken reference to the file FPDTC.DLL version 1.0.

I'm trying to enter data into a form which includes 2 tables "A" and
"B".  "B" is simply yes / no check boxes.
If the user does not use the forms check boxes in "B", a record is not
created for that table (which I understand).  But, I would like this