On 14 Jan 2004 12:23:29 -0800,
aspguru@email.com (aspguru) wrote:
I don't know of any such tool. Did you check with fmsinc.com - their
Detective program?
You can use Database Documenter before and after, and perform a text
search for differences.
You can ask for permission to set up a VPN or Terminal Services
connection with the office and work through it.
SQL Server offers this option natively, and I often use it to "play
back" design changes.
BTW, in case BillG is reading this: why can't you keep a Modified Date
for SQL Server objects? Talk to the Access guys across campus that
have been doing this for years.
-Tom.
[color=blue]
>Hi
>
>I frequently take a live copy of the corperate LAN Access 2000 DB
>offline on my laptop and do structural changes. What I am looking for
>is some way of a recording a macro of all the changes i've done and
>then playing it back on the live DB when I get back into the office.
>I have scoured the access help and it doesnt appear to accomodate
>this. The nearest I've found is replication but this looks more for
>data rather than structure and I dont want data being synced as it
>will be full of dummy test records.
>
>I am hoping there is a 3rd party table admin interface out there which
>allows you to script your changes into an SQL file (or a series of VBA
>DAO commands), similair to the way SQL server can script off objects.[/color]
