Access 2007 closes without updating recordsource

[Fred Boer]

Greetings:

If I change the recordsource for a form using the query design grid in
Access 2007, and then click on the top "X" to immediately attempt to close
Access, a popup asks if I wish to save the changes to the recordset. If I
select "Yes", the pop-up closes, and Access itself closes, but the changes
in the recordsource are not saved.

If I change the recordsoure, then close the query design window, clicking
"Yes" to accept the changes to the recordsource, I return to the design view
of the form. If I then click to immediately attempt to close Access, the
program closes without actually saving the changes to the recordsource.

If, before I attempt to close Access, I first change from display mode to
viewing the form, then Access prompts to save form design changes, and
recordsource changes are preserved.

Anybody else see this behaviour? In Access 2003, if I followed this
sequence, I'd be prompted to save the recordsource changes, *and* be
prompted to save the changes to the form, IIRC.

I see that on Allen Browne's list of bugs there is a very similar (the
same?) bug listed - and it is shown as fixed in Service Pack 1. I have
Service Pack 1 installed.

 

[Jeff Conrad [MSFT]]

in message:

Hi Fred,

Comments inline...

If I change the recordsource for a form using the query design grid in
Access 2007, and then click on the top "X" to immediately attempt to close
Access, a popup asks if I wish to save the changes to the recordset. If I
select "Yes", the pop-up closes, and Access itself closes, but the changes
in the recordsource are not saved.

I'm not seeing that on my machine. What OS are you using?

If I change the recordsoure, then close the query design window, clicking
"Yes" to accept the changes to the recordsource, I return to the design
view of the form. If I then click to immediately attempt to close Access,
the program closes without actually saving the changes to the
recordsource.

I'm not seeing that either. In both cases the changes are saved and I can
see the changes the next time I open the program/form.

If, before I attempt to close Access, I first change from display mode to
viewing the form, then Access prompts to save form design changes, and
recordsource changes are preserved.

Anybody else see this behaviour? In Access 2003, if I followed this
sequence, I'd be prompted to save the recordsource changes, *and* be
prompted to save the changes to the form, IIRC.

I see that on Allen Browne's list of bugs there is a very similar (the
same?) bug listed - and it is shown as fixed in Service Pack 1. I have
Service Pack 1 installed.

What's the exact build listed under:
Office Button | Access Options | Resources
(bottom of the form just below the About area)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Fred Boer]

Hi Jeff:

I'm running Windows XP Professional Version 2002 Service Pack 2.

Microsoft Office Access 2007 (12.0.6211.1000) SP1 MSO(12.0.6213.1000)

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

 

[Fred Boer]

BTW Jeff...

I've tried it with Northwind too.. I think it is only a problem when the
recordsource is a SQL statement, rather than a saved query...

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

 

[Jeff Conrad [MSFT]]

in message:

BTW Jeff...

I've tried it with Northwind too.. I think it is only a problem when the
recordsource is a SQL statement, rather than a saved query...

Ahhhh, yes, that does make a difference.

If I change the recordsource for a form using the query design grid in
Access 2007, and then click on the top "X" to immediately attempt to close
Access, a popup asks if I wish to save the changes to the recordset. If I
select "Yes", the pop-up closes, and Access itself closes, but the changes
in the recordsource are not saved.

With a SQL statement, yes I am seeing that as well.

If I change the recordsoure, then close the query design window, clicking
"Yes" to accept the changes to the recordsource, I return to the design
view of the form. If I then click to immediately attempt to close Access,
the program closes without actually saving the changes to the
recordsource.

I see that as well.

Two workarounds:
1. After returning to the form view, click save to save the form changes. It
will "stick" then.
2. After returning to the form view, tab off that property sheet line onto
another line. It will "stick" then as well.

Thanks for pointing this out Fred, I'll bring this up to the team's
attention.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Fred Boer]

Dear Jeff:

Glad you see it too. Not serious, though I will have to change the "twitch"
I have of closing/reopening Access to apply/see changes to my forms. Not
sure when I picked up that habit, but this behaviour sure made me notice
it...

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

 

[Jeff Conrad [MSFT]]

in message:

Dear Jeff:

Glad you see it too. Not serious, though I will have to change the
"twitch" I have of closing/reopening Access to apply/see changes to my
forms. Not sure when I picked up that habit, but this behaviour sure made
me notice it...

Actually, no, it's not good I see it. That means we have a problem.
;-)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Tony Toews [MVP]]

Actually, no, it's not good I see it. That means we have a problem.
;-)

Those are called "bugs" not problems and not features. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jeff Conrad [MSFT]]

in message:

Those are called "bugs" not problems and not features. <smile>

They're also called job security.
;-)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com