Access Remote Management Tool?

[Dave]

I use access on a remote server for my data collection. In this db, I have
created several queries and then I use asp to Access the query, so far all
is well.

My question is there a tool or is there a way to create and save a query
locally, then push it up to the remote site.

Presently, I download the db outside the business day, make changes then
push it back up. This is becoming a challenge.

Are tools to do this and administer access remotely?

Thanks

Dave

 

[MBSNewbie]

Why don't you just keep your copy, then export the queries from your
database to the live database as you go?

 

[Dave]

I had not thought about that - that would work!

Thanks

 

[aaron.kempf]

if you used 'Access Data Projects' then you could use a free web-based
utility for managing SQL Server objects.

Free. Web-based.

it comes from Microsoft; microsoft.com/sql look under downloads


-Aaron