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
CBHelpDeskAsked:
Who is Participating?
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.

All Courses

From novice to tech pro — start learning today.