Non-saving forms

Topic

New Reply

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?

Reply | Quote

Replies

Access 2003 under windows 7.
I make a change to a macro button on a form, click the save icon. …

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.

Reply | 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.

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

Reply | Quote

Does this happen in all databases or just in one specific database?

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

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.

Reply | Quote

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?

Reply | Quote

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?

Reply | Quote

Adding more info’, from pc2, editing the database on pc1, I can edit the table and queries BUT NOT THE FORMS! Any ideas please?

Reply | Quote

Adding more info’, from pc2, editing the database on pc1, I can edit the table and queries BUT NOT THE FORMS! Any ideas please?

Is this an .mde file or a .mdb file?

Reply | Quote

Is this an .mde file or a .mdb file?

This is an .mdb file

Reply | Quote

This is an .mdb file

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?

Reply | 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?

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.

Reply | Quote