CODEWITHSUNDEEP
ms-access
user1804254
user1804254

Reputation: 59

Access Version Maintenance

I have an access database (access 2010) where the data is being entered everyday by some people through forms. I am also working on it to develop new forms and new queries. The problem is that I am developing a form and by the time I put it on the current version of database, more data is being entered and so consistency is being lost. Is there a way in which I can deal with this problem.

Upvotes: 1

Views: 50

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

An Access database should always be split into a back-end for data and a front-end for forms and so forth. The back-end tables are then linked to the front-end. ( How to split db, Reasons to split db )

Each user gets a copy of the front-end and the back-end resides on a computer that all have access to.

Develop on a copy of the front-end and when you are finished, relink the tables and distribute the new version to each user ( Front-end maintenance ).

Upvotes: 1

Related Questions