Results 1 to 12 of 12
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Access 2003 under windows 7.
    I make a change to a macro button on a form, click the save icon. Then when I try to close the form I get the dialogue box "Do you want to save changes....." Click Yes. So the form is saved? Try closing it a second or 3rd time and the same message pops up! Can anyone suggest what is causing this to happen please?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='StephenElms' post='796028' date='02-Oct-2009 08:39']Access 2003 under windows 7.
    I make a change to a macro button on a form, click the save icon. ...[/quote]
    Does that mean you are making changes to the macro (or VBA) that is initiated by the button? And do you have another form or report open at the same time? I've seen that behavior with Access 2007, but not with 2003. Windows 7 is an unknown environment with Access 2003 so that may also be contributing to this issue. The security environment in Win7 is quite different from WindowsXP. Try making the same change with only that object open in the database and see if you can save it.
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='WendellB' post='796031' date='02-Oct-2009 16:01']Does that mean you are making changes to the macro (or VBA) that is initiated by the button? And do you have another form or report open at the same time? I've seen that behavior with Access 2007, but not with 2003. Windows 7 is an unknown environment with Access 2003 so that may also be contributing to this issue. The security environment in Win7 is quite different from WindowsXP. Try making the same change with only that object open in the database and see if you can save it.[/quote]
    Hi Wendell, thanks for the suggestion. I have tried, just now, to open the one form and make the change to the macro button - no luck though! Can't save the change - any further advice please
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does this happen in all databases or just in one specific database?

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='StephenElms' post='796042' date='02-Oct-2009 09:22']Hi Wendell, thanks for the suggestion. I have tried, just now, to open the one form and make the change to the macro button - no luck though! Can't save the change - any further advice please[/quote]
    Well, the only thing I can think of that might cause that is the file permissions in Windows 7. Do you get a message when you open the database that it is read-only? Also check your explicit permissions on the folder where the database is stored - Windows 7 has much more robust file and folder security, and that could be the underlying problem.
    Wendell

  6. #6
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Wendell, well the drive d: on pc1 is shared, the directory database is shared read/write permissions for everyone. I re-booted pc1 after enabling sharing to the directory. From pc2 I can change but not save anything in the database. Very peculiar this, as last week I was able to make changes and I am not aware of making any programme additions or permission changes until now. Any further suggestions please?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  7. #7
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Guys 'n Gals,
    Curiouser and curiouser: editing the forms in the database on pc1, using pc1, it seems that 2 particular forms cannot be changed. Both are based upon the same query, I can edit the query. One form is a list of the data and the other is individual data records. Can anyone explain why these two forms are locked please?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  8. #8
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Adding more info', from pc2, editing the database on pc1, I can edit the table and queries BUT NOT THE FORMS! Any ideas please?
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='StephenElms' post='796712' date='07-Oct-2009 19:44']Adding more info', from pc2, editing the database on pc1, I can edit the table and queries BUT NOT THE FORMS! Any ideas please?[/quote]
    Is this an .mde file or a .mdb file?

  10. #10
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='patt' post='796871' date='08-Oct-2009 01:49']Is this an .mde file or a .mdb file?[/quote]

    This is an .mdb file
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='StephenElms' post='796899' date='08-Oct-2009 03:33']This is an .mdb file[/quote]
    Are both PCs running Windows 7, or is PC1 on Win7 and PC2 on Vista or XP, or....? At this stage I can't think of anything else that would cause this behavior. Can you post a stripped down version with just the forms (and a little data) that can't be saved?
    Wendell

  12. #12
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='WendellB' post='796984' date='08-Oct-2009 19:29']Are both PCs running Windows 7, or is PC1 on Win7 and PC2 on Vista or XP, or....? At this stage I can't think of anything else that would cause this behavior. Can you post a stripped down version with just the forms (and a little data) that can't be saved?[/quote]


    Hi Wendall,
    Both Pc's are running W7RC1 - we are looking forward to the 23rd October!.
    When I open the form(s) to edit them, the form is the only thing open. Yesterday afternoon I split the database into front end and back end and decided that I would go through all of the form and "audit" them. I am opening each one in Edit, adding a small rectangle to the footer and seeing if I can save and close it. If I can save and close then the "audit" rectangle stays in the form as a positive marker that the worm works. So far I have deleted 3 forms and rebuilt them - they are now working OK. 13 out of 129 so far audited! (Well, work impinges on the task!)
    Sorry, I can't post a copy of the db - it will take too long to delete data. Thanks to all who have assisted and offered advice.
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •