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

Transfer Date of Structure Only?

P: n/a
Hi,

I made a copy of an Access 2000 database to do some dev work on it which
involved fixing a few bad data types and adding a few columns to a
couple of tables.

Meanwhile the original database has been continuously used and had its
data updated.

Is there a utility that can synchronize the two database files by
specifically adding the structural changes to the original MDB file
without changing the pre-existing data, or moving (not appending) all of
the data from the original file into the new, upgraded MDB file?

The trick is I don't have Access. I have SQLServer2000 and a web-based
Access-editor, but don't really want to buy Access for this one task.

Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I don't know of software that does what you want, but you can, with some
work, create either queries to do it manually, or an application to do it
programattically -- with Access itself. I'm not familiar with "web-based
Access editors", so can't address that issue. You could also do it with DAO
code in VBA in some other Office application or in classic VB, but a copy of
Access would be a bargain compared to your investment of time and energy, I
suspect. I've seen some copies of Access 2000 on eBay that looked as if they
had gone / were going pretty inexpensively. If you go that route, be sure to
update -- it is up to SP3 now.

Larry Linson
Microsoft Access MVP

"Travis Pupkin" <tp*****@dorrk.com> wrote in message
news:MP************************@news.individual.ne t...
Hi,

I made a copy of an Access 2000 database to do some dev work on it which
involved fixing a few bad data types and adding a few columns to a
couple of tables.

Meanwhile the original database has been continuously used and had its
data updated.

Is there a utility that can synchronize the two database files by
specifically adding the structural changes to the original MDB file
without changing the pre-existing data, or moving (not appending) all of
the data from the original file into the new, upgraded MDB file?

The trick is I don't have Access. I have SQLServer2000 and a web-based
Access-editor, but don't really want to buy Access for this one task.

Thanks.

Nov 12 '05 #2

P: n/a
Being a poor typist, I meant to title this "Transfer DATA OR Structure
Only?," but failed...

In article <FB*******************@nwrddc01.gnilink.net>,
bo*****@localhost.net says...
I don't know of software that does what you want, but you can, with some
work, create either queries to do it manually, or an application to do it
programattically -- with Access itself. I'm not familiar with "web-based
Access editors", so can't address that issue. You could also do it with DAO
code in VBA in some other Office application or in classic VB, but a copy of
Access would be a bargain compared to your investment of time and energy, I
suspect. I've seen some copies of Access 2000 on eBay that looked as if they
had gone / were going pretty inexpensively. If you go that route, be sure to
update -- it is up to SP3 now.

Larry Linson
Microsoft Access MVP

"Travis Pupkin" <tp*****@dorrk.com> wrote in message
news:MP************************@news.individual.ne t...
Hi,

I made a copy of an Access 2000 database to do some dev work on it which
involved fixing a few bad data types and adding a few columns to a
couple of tables.

Meanwhile the original database has been continuously used and had its
data updated.

Is there a utility that can synchronize the two database files by
specifically adding the structural changes to the original MDB file
without changing the pre-existing data, or moving (not appending) all of
the data from the original file into the new, upgraded MDB file?

The trick is I don't have Access. I have SQLServer2000 and a web-based
Access-editor, but don't really want to buy Access for this one task.

Thanks.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.