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

Looking for 3rd party Access Admin tool

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.


Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.