| Author |
 Topic  |
|
|
seven
Senior Member
USA
1037 Posts |
 Posted - 17 August 2002 : 18:53:56
|
What's an easy way to drop a database if I am using MS MSDE?
You can't do it using access. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 17 August 2002 : 22:23:08
|
You can drop MSDE databases using Access 2000+ projects. Create an adp to your MSDE server, hook it to the database you want to drop, and in Tools-Database Utilities you'll find drop database.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
seven
Senior Member
USA
1037 Posts |
Posted - 17 August 2002 : 23:04:35
|
| Actually, I tried that. It said I had to upgrade to SQL server 7 to use that tool... I have MSDE (the free version for my local PC) |
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 August 2002 : 00:29:15
|
Well, with Access 2000 and MSDE1.0 I can drop db's on a W2K box.
You do have to run Access on the same computer as the MSDE server for this to work, and I think you do get a message like you quoted if you're trying to drop a DB that's on a server over the network.
WebMatrix as Richard said will do the trick, and is a nice free product as well.
Or you can obtain a copy of Enterprise manager, which is what I normally manage my MSDE db's with.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 August 2002 : 00:33:33
|
| I tried to drop a Database on MSDE 2000 using Access XP and it would not let me (got the error about needing SQL 7.0 or higher). Both are on the same computer. |
|
|
|
pweighill
Junior Member
United Kingdom
453 Posts |
Posted - 18 August 2002 : 04:55:23
|
You could try running osql:
osql -Usa -P
Then:
DROP DATABASE databasename |
|
|
|
seven
Senior Member
USA
1037 Posts |
Posted - 18 August 2002 : 09:25:02
|
That's what I got... I have web matrix installed, I'll use that?
But, what are you doing with an ASP.NET product, Richard?
quote:
Originally posted by RichardKinser
I tried to drop a Database on MSDE 2000 using Access XP and it would not let me (got the error about needing SQL 7.0 or higher). Both are on the same computer.
|
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 August 2002 : 12:16:20
|
quote:
Originally posted by RichardKinser
I tried to drop a Database on MSDE 2000 using Access XP and it would not let me (got the error about needing SQL 7.0 or higher). Both are on the same computer.
I guess MS changed something. I have A2K and have MSDE1.0 and MSDE2K on the same W2K box and can drop db's on either server from Access. Someday when I feel the urge I guess I should update my Office 
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Topic Locked
