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
272 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
 

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now