Forgive me if this has been covered in the past but I couldn't find any threads when I searched the forum.
The root of my question is how do Access Developers update their published frontend and backend databases from their development databases?
The stituation I am in is that I have my published and semi-functional database that has live data that I am using and continually adding records to but I still have alot of work to do to get this database to where I want it. So I do all my experimenting and development to a separate development database, frontend and backend, so I don't corrupt any of my live data records. But this involves, obviously changing the frontend code, forms, and queries which are not too difficult to update by cut and pasting, importing or an all out replacement of the frontend. However I sometimes find small mistakes or changes that need to be made to the backend or tables that need to be added and with my live data I am not sure how to keep things in sync.
Thanks for any advice or comments.