MS-ACCESS – COPY OF FORM

0 pts.
Tags:
Development
Hello everyone, I'm developing an application using MS-ACCESS. My question is how to copy a new form or a modified one to the customer's PC without disrupting the data. I want to copy the form only not the whole database again. I don't think this is diffcult but so far I have not been able to copy the form. Thanks and look forward to hearing from one of you. Nacere
ASKED: March 11, 2005  5:40 AM
UPDATED: March 14, 2005  5:13 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

One standard solution is to create two databases. Your back end database which contains all of the tables and would be sited on a server somewhere. If you’ve got your structure right, the number of times you would need to take the back end off-line for upgrades should be a lot smaller.

You would also need to construct a front end database which would contain links to the tables and all of your queries, forms, code etc. etc.

The joy of this solution is that you can have different front ends for different users, a protected back end and also you can distribute the new front end in a number of managable ways eg. executable zip which can be run by the user? overnight scheduler task to bring the local pc up to date?

And lastly, it means that you can more effectively manage version control, testing environments and so on.

Hope this helps

M

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following