Transfer Date of Structure Only?

[Travis Pupkin]

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.

[Larry Linson]

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.

[Travis Pupkin]

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.