Looking for 3rd party Access Admin tool

[aspguru]

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.

[Tom van Stiphout]

On 14 Jan 2004 12:23:29 -0800, as*****@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.

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.

[aspguru]

I have used a VPN and Terminal Services but I often travel to places
where there is no network (and indeed work whilst in transit) so the
whole solution has to be on my laptop.

I am wondering, if theres nothing out there already whether its worth
spending time developing one myself.