Copying an object from a test environment over to Production

[detaylor1242]

I have a duplicate database for development but it has a subset of the data that is in the production version. I am updating a number of the reports and forms plus adding some VBA modules.IS there a way to copy the revised objects over to the production database? This would save me quite a bit of time and minimize the time the production version is down.

[pbaldy]

You can import or export objects using the External Data tab. The real question is why would the production db be down at all?

[ssanfu]

Adding to what Paul said.....

Normally, you would have the dB split into a FE and a BE. Everyone would get a copy (not a shortcut) of the FE, linked to the BE. The BE would typically be on a server. You can make changes to the FE (forms/reports) without worrying about the data - the data is in the BE.
When you have saved the revisions/changes to forms/reports and are ready to start using them, everyone gets a new FE. Easy peasy

If the dB is not split, having more than one person in the dB WILL, at some point, corrupt the database. It might be a little corruption or enough to lose all data. Not a question of IF, just WHEN.

Here are links to why/how you should split the database.
http://www.kallal.ca/Articles/split/
http://www.access-experts.com/%5Cdef...lSplitDB&sm=18
http://www.techrepublic.com/blog/10-...cess-database/
http://allenbrowne.com/ser-01.htm

[detaylor1242]

Thanks for the help I will try that tonight. The database is on a single computer and my only access is during business hours. So If I am going to do any work on it the DB is not available to the user. I try and do any updates either early in them morning or at lunch time. Just thinking it would be great if I can modify the forms and reports on my computer and then export them to a flash drive and import them when I am in.

Thanks again for your suggestion..