How to deploy my design changes

[leigh_ph]

hi,

i've never done any MS access application before, but i am tasked to enhanced an existing MS Access application.

I have a local copy of the production db and i'm just concern how i can deploy or refresh the production database with my updates.

Also, the clients is using a linked copy of the database.


Thanks for any help

 

[Bigmo2u]

Get everyone out of the production DB. Delete the forms, queries, etc that you want to changed in the production DB. Then import all the changes from your copy on your hard drive. or if it is FE only Just replace it when everyone is out of the production.

I don't know if you have security on this production DB or not that is why i offered the second option.

A little more detail as where the system is and what security you have on the DB would help. I am sure there are probably fast ways of doing this but that is how I make my changes.