Viewing a Database

1 May 2006 7:17 PM

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.

1 May 2006 8:46 PM

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

1 May 2006 9:07 PM

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?

"Kevin Audleman" wrote...
Show quote

> 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
>

1 May 2006 10:31 PM

Bob Barrows [MVP]

Bill wrote:
Show quote

> 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

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

1 May 2006 11:28 PM

Brian Staff

> 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.

MS Visual Web Developer Express (free) will do this

http://msdn.microsoft.com/vstudio/express/vwd/

it might require you to update your MSSQL though.

Brian