Form not allowing cosmetic changes

[David1234]

Hi All,

I've reached the point now where i'm releasing my database to end users to use. Cosmetic changes were requested by the users, so i've attempted to do this - However, when the changes are made and attempted to be saved, the system goes through the normal process of confirming what to save - But does nothing.

The database is linked to a central switchboard, and from the switchboard several other databases are linked - These have no problem with them, so I know it is specific to the single form I am working on....any ideas?

 

[vbaInet]

How did you split your database?
Are you working on the LIVE database?

 

[David1234]

I'm working on the live version, users are working on v2, i'm on v2.1

I haven't split the database, within the company there are several databases - These have been consilated into a central one via switchboard. This is the only new one that has been added manually - The strange thing is that it has been on here for the last few weeks, and i've made more cosmetic changes than an L.A Surgeon since then

 

[vbaInet]

Basically, you should not be working on the Live version.

1. Make the changes on an offline copy (or development copy).
2. Request for downtime and get all users to log off the db.
3. Upload the new version.
4. Inform all users that the db is back up and running.

It's evident that your organisation isn't following best practices for deploying and running Access databases. The database should be split and each user should have their own copy of the Front End linked to a shared Back End. I guess you can't change that because that's how it has been setup but it's worth bringing it up.