473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Viewing a Database

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.

May 1 '06 #1
4 1082
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

May 1 '06 #2
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...
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

May 1 '06 #3
Bill wrote:
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.
May 1 '06 #4
> 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

May 1 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Pat | last post by:
Hello, Two questions - hence the weird subject. First, anyone had luck with the Enumerating user accounts in a NT Domain module by Dev Ashish on Access Web...
10
by: NH | last post by:
I have a girdview with paging enabled. How can I add a message in the footer to say "Viewing records 1-15 of 45" etc Thanks
10
by: David Lee Conley | last post by:
When I open the Data Sources window and create a new data source, everything works fine. But if I have a form showing in the IDE, the Data Sources window becomes disabled and doesn't display any...
12
bartonc
by: bartonc | last post by:
Here's something cool that I just discovered (on IE7, I wonder about the others): I was viewing a long code block with some really long lines in it. Since the horizontal scroll bar was WAY of my...
3
by: tom.youdan | last post by:
Hi, I have created a database that is used to store contact information for NGO's accross India. It is simple in structure and I want a portion of the data to be viewable on the Internet. I...
0
by: jai80 | last post by:
hi frenz, I have developed ASP pages with VB Script and for client side validation purpose i have used JavaScript. I have uploaded my pages and when working on the pages using IE6, its working...
1
by: Sher Dil | last post by:
07.02.2007 / 2020 hours. I am basically working as an astrologer, and have developed my own software in VB6.0 + Access + Crystal Report 4.6.1.0 What ever I select (I enter code, which...
1
by: Steve F | last post by:
i have a copy of a SQL Server 2000 database on an external hardrive. I have SQL Enterprise Manager 2005 on my laptop and was wondering if it is possible to view the backup on my laptop when...
14
klarae99
by: klarae99 | last post by:
Hello, I am working on an Access 2003 Database for inventory control. I am setting up a form (frmProducts) for the viewing and adding of product information. I have several tables that this...
3
by: Tom | last post by:
I have a PHP 4.4.7, MySql 5.0 and I.E. 7. My PHP queries the database and renders the info into html forms. Submitting the forms manipulates the data. Now, the problem is that the browsers are...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.