Solved

Cannot open form first try; get 'recordset is not updateable'.  Will open it if close/reopen database and try again.

Posted on 2011-03-04
10
276 Views
Last Modified: 2012-06-27
My database has a switchboard that allows you to open a form.  This form links to a table in another database in a different directory.  The information displayed on the form is controlled by a query so it only picks records where a checkbox is set.

When I open the database and click the button on the switchboard, it says 'recordset is not updateable'.

If I close the database, reopen it and click the button, the form displays.

Any suggestions on what I should be looking at?

Thanks
0
Comment
Question by:CBHelpDesk
  • 5
  • 4
10 Comments
 
LVL 15

Accepted Solution

by:
Simon Ball earned 500 total points
ID: 35036601
could try removing the recordsource from the form and adding it in on onload function...
me.rowsource = "Queryname"

your db could be trying to draw the form before its connected to the other DB, or some other weirdness.
0
 
LVL 14

Expert Comment

by:VBClassicGuy
ID: 35036628
Microsoft says:

"The table that you are updating is a linked table that does not have a primary key or a unique index. Or, the query or the form is based on a linked table that does not have a primary key or a unique index."
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35036881
but wouldn't that occur every time, not just on first load, if that were the problem?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:CBHelpDesk
ID: 35037053
I'll give the form Load function a try later today.

There is a primary key on the linked table so that eliminates one possibility.

Thanks for the quick responses!

0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35037122
also, are there multiple controls on the form drwing sperately from the data aset?  they might create locks on records?
0
 

Author Comment

by:CBHelpDesk
ID: 35038136
The form contains information from the linked table (read only) and fields in a table in the current database (allow updates).

Database A - tblClient (linked table for reading) where the primary key is Client_ID
Database B - tblAddl_Info where the primary key is Addl_Info_ID

The form in Database B displays fields from both tables.

The query for the form in Database B is:
SELECT tblClient.*, tblAddl_Info.*
FROM tblClient LEFT JOIN tblAddl_Info ON tblClient.Client_ID = tblAddl_Info.Client_ID
WHERE tblClient.CBCS_Client=True;
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35040125
did the onload option not work then?
0
 

Author Comment

by:CBHelpDesk
ID: 35040189
Today went crazy so it'll be Monday before I can get to it.

Sorry for the delay.
0
 

Author Closing Comment

by:CBHelpDesk
ID: 35110920
I added the following to the form load and it worked like a charm.

   Me.RecordSource = "qry"
    Me.Requery

Thanks for all your help!
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 35112358
excellent.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Disable Outlook Security Warning Window Access 2016 5 49
How do I bind a table in Access 2013 to a form 5 32
database opened as read only 10 31
Access/Visual Basic Question 3 24
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question