Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

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

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
CBHelpDesk
Asked:
CBHelpDesk
  • 5
  • 4
1 Solution
 
Simon BallCommented:
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
 
VBClassicGuyCommented:
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
 
Simon BallCommented:
but wouldn't that occur every time, not just on first load, if that were the problem?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
CBHelpDeskAuthor Commented:
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
 
Simon BallCommented:
also, are there multiple controls on the form drwing sperately from the data aset?  they might create locks on records?
0
 
CBHelpDeskAuthor Commented:
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
 
Simon BallCommented:
did the onload option not work then?
0
 
CBHelpDeskAuthor Commented:
Today went crazy so it'll be Monday before I can get to it.

Sorry for the delay.
0
 
CBHelpDeskAuthor Commented:
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
 
Simon BallCommented:
excellent.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now