Replies

Hi Wendell,
There is no password on the front end – there are only 2 users anyway. I’m running Office 2003, so Tools / Security / Workgroup Administrator / Create or Join or OK I joined!

Wendell, thanks. Yes this is related to my post about macros and editing forms. Where do I find Access User Security please? I can find Tools / Security

Spot on Hans, thankyou. But I do not know what changed the property from yes to no though!

Thanks Hans, I’ll have a good look at it.

Yes, indeed I could Hans – thank you for the comment. The ideas was to be able to make changes in the future and automatically synchronise the computers on a weekly or daily basis.

Hi vincenzo,
I use the Outlook connector too – no problems with it at all.

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.

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

This is an .mdb file

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

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?

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?

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

Wendall, a very interesting reply; can I follow up with a supplementary question regarding the database splitter? I have 2 pc’s – pc1 and pc2. I want to split the client database so that there is a front end on pc1. Having done that do I, just, copy the front end files from pc1 to a (same/similar) location on pc2? Do the references in the queries and forms change to reflect this movement please?

Hi Hans,
Thanks for the information. Part of it worked (that referring to Returns) and the self-employment and employment didn’t.
The screen snip shows what happens when the button on the sub form is clicked. The button runs the macro in the second snip – which reads
[SEID]=[Forms]![FrmIndividualDataQuery]![FrmSelfEmploymentListingShort]![SEID]
Both of the form names are correct.
The first one I treid worked perfectly:
[TRRecord]=[Forms]![FrmIndividualDataQuery]![FrmTaxReturnsList]![TRRecord]
I’d appreciate any help please.

Your description leaves me totally confused. Could you try to explain that more precisely and clearly? Thanks.

Sorry for that Hans.
Client form displays 2 sub-forms: employment and self-employment. Each has a macro button on them. When the forms are viewed outside of the client form, the macro opens the full record of employment. However when the sub-forms are displyed, the macr makes you enter the ID number to get to the underlying form. Please have a look at the picture.