Beta-testing a database while making improvements

[jmitchelldueck]

Hi,



I need to start using the database I've created (desktop database). However, I don't want my current version to be the final version.

Should I create another file to work in and use the old version for data entry? When I am ready to start using my new version, is it easy enough to transfer all the data from the old?

Thanks,
jmd

[June7]

Importing data would not be easy if using autonumber PK and saving as FK in related tables. Would have to import and replace other objects into the new version. Split the database and 'versioning' is not an issue.

[jmitchelldueck]

Once a database is split, do changes to the back end affect the current front end, or would I need to split it again for users to see updates?

i.e. if I were to change the background colour of a form, would a user see the change automatically or only after I split the database again?

[June7]

Splitting is a one-time event.

Backend only has tables and frontend has everything else with links to backend tables. Backend edits like adding new tables or fields would require edits to frontend.

Backend sits on network server that all uses have access to. Each user should have their own copy of frontend on their computer. Revised frontend must be distributed to users.

Review https://www.accessforums.net/access/...end-27089.html