By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Synchronizing Table definitionns in one mdb file with those from a second mdb file

P: n/a
I see this is a common question, however I haven't found any good
answers.

I receive ms-access mdb files from various clients. These mdb files
have roughly the same structure, however each client tends to make
some slight modifications to one or two tables.

When I receive these files, I need to transport data into a standard
file template. Currently I have to modify table field names and
definitions manualy before I transport data from the clients database
into my database template. I refer to this as "mapping" data from the
client's database into mine.

My template needs to remain relatively un-modified, as there are
multiple queries and reports that are configured to my field names and
defitions.

Are there any free or commercial utilities available today to do this
on the recent versions of ms-access?

Mark
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
mr****@ogclearinghouse.com (Mark) wrote:
Are there any free or commercial utilities available today to do this
on the recent versions of ms-access?


See the following page for a list of utilities to compare Access databases
http://www.granite.ab.ca/access/thirdparty.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #2

P: n/a
Mark,

Create an append query and append your client's data to an empty copy of your
template.It doesn't matter what the client field names are, you will keep the
field names in your template. No muss no fuss!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Mark" <mr****@ogclearinghouse.com> wrote in message
news:9b**************************@posting.google.c om...
I see this is a common question, however I haven't found any good
answers.

I receive ms-access mdb files from various clients. These mdb files
have roughly the same structure, however each client tends to make
some slight modifications to one or two tables.

When I receive these files, I need to transport data into a standard
file template. Currently I have to modify table field names and
definitions manualy before I transport data from the clients database
into my database template. I refer to this as "mapping" data from the
client's database into mine.

My template needs to remain relatively un-modified, as there are
multiple queries and reports that are configured to my field names and
defitions.

Are there any free or commercial utilities available today to do this
on the recent versions of ms-access?

Mark

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.