Viewing a Database

[Bill]

On a shared hosting account, I've got access to an SQL 2000 database on a remote server.
Stats are data size: 12MB, Log Size: 25MB. I set it up five years ago, and, uh, forgot
how I set it up...

Anyway, I need to be able to view and browse the structure of my SQL 2000 database - and
it would be nice to do it with an interface like a Microsoft Access style GUI? I need to
be able to see what tables, columns, etc. my db contains.

Is there a web-based, or client-based, interface I can use that will allow me to view
and browse my SQL 2000 database? (Would it be easier if I had my web host provider
convert it to SQL 2005?)

Thanks!

Bill.

 

[Kevin Audleman]

Access can connect to a remote site and do what you want. Just go to
File->New and choose "Project using new data". This will create a file
with an .adp extension. Go to File->Connection, and set up the
connection to your online database.

Kevin

 

[Bill]

1. Are you saying I can safely use Microsoft Access 2000, to load and view a Microsoft
SQL 2000 database?

2. If #1 is true, would it be dangerous to try to modify and save the database in that
environment?


...

 

[Bob Barrows [MVP]]

On a shared hosting account, I've got access to an SQL 2000 database
on a remote server. Stats are data size: 12MB, Log Size: 25MB. I set
it up five years ago, and, uh, forgot how I set it up...

Anyway, I need to be able to view and browse the structure of my SQL
2000 database - and it would be nice to do it with an interface like
a Microsoft Access style GUI? I need to be able to see what tables,
columns, etc. my db contains.

Is there a web-based, or client-based, interface I can use that will
allow me to view and browse my SQL 2000 database? (Would it be easier
if I had my web host provider convert it to SQL 2005?)

Thanks!

http://www.aspfaq.com/show.asp?id=2442