Synching up two versions

[Steve]

Hi,

I'm using Access 2003 and have been doing a bunch of volunteer work for an
organization from home. I've created several new queries and reports on some
tables that have not changed in their structure - just content. I've also
created some new tables, forms, reports, etc...

Two questions:

1. I'm going to visit the organization tomorrow and want to put the new
queries and reports for their existing tables/forms onto their network drive
without impacting the existing data - what's the best way to do this?

2. Same question for the new tables (empty) and the queries, forms, reports
associated with them - best way to get them over?

I'm definitely not an Access expert and have been just doing some volunteer
work to help these folks put on a very cool sporting event - I'm nervous
ablut losing the existing data they have. Would I be better off exporting
those records to the version I have and then putting the whole database on
their network? If so, what's the best way to do that?

Thanks a bunch in advance.

Regards,

Steve

 

[Dale Fye]

Steve,

If you have been using this newsgroup for long, you will probably have heard
that you need to split the application into a front end (application forms,
queries, reports, and code) and backend (tables). There is a wizard in
Access for doing this. If you have not already done this, I strongly
encourage you to do so.

The advantage of this is that you can continue development using the front
end, and when you want to deploy the new front-end you just provide it to the
users with the links to the backend.

In the case where you add new tables, then you would just copy those new
tables to the backend database. Then link them to the front-end before you
give the new front-end out to the various users.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.