Proj98 SQL & DeleteFromDatabase method

[David]

Hello,

I have ;
MS Project 98 via ODBC with
MSSQL2000

I would like to use the "DeleteFromDatabase" method to delete old Project98
projects from MSSQL.
I can find several references to it, but anything related to it on the MS
site gives a page not found.
Anyone used this method that could provide code, and some documentation or
examples?


Thanks,

Dave

 

[Rod Gill]

Hi,

What happens when you record a macro of you deleting a project manually?
What code is produced?

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[David]

Thanks for the reply,

Deleting projects manually is a nightmare, so we don't do it.
There are so many tables, and its difficult to tell how some of them are
related.

I just don't know how.

 

[Rod Gill]

Hi,

I mean in File Open dialog delete a project via the interface(see help)
whilst recording a macro. That code will likely have your answer.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[David]

No such option for database projects.
I could delete files located on the network, but I can't find that option
for a project stored in a database.

 

[Rod Gill]

I'm not connected right now, but memory suggests there's an icon in the top
right of the file open dialog for database projects and it's on the drop
downlist it presents. You can definitely delete a project in a database
(provided you have database rights to do so.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Juan Espinel]

Hi David

When you open a data base of projects via ODBC you have
a list with all the projects in that database. If you
select one you can delete the project with the button with
an X on it.

Hope that's what you need.

Juan Espinel

 

[Rod Gill]

Hi,

You are doing an Import based on the title of the dialog box.Do a File,
Open, Select ODBC then the delete button or option in a drop down list
(depends on your version) is available from there.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[David]

Hello,

I thought I was pretty application savy, but now I think I am insane....

When I click file...open...ODBC...
I get the import dialogue box
I've tried every way I can think of to try and get another ODBC dialogue
box, but I only get import.

In my drop down list of project (again on the "Import" dialogue box) I don't
have a button with an X on it anywhere even after highlighting a project...
The only X I see is in the upper right of the dialogue, and that simply
exits the dialogue box.


Am I a total ID-10T ;-D


Dave

 

[Rod Gill]

What version of project. I've just done File Open, clicked ODBC, selected a
valid DSN and seen a list of projects. At the top was a X icon to delete a
project with. This was Project 2003.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[David]

I am using Project 98

I should have made that more clear in the subject line.

 

[Rod Gill]

A number of people have all said the same thing, there must be a delete
button or option from a drop down menu. If you truly haven't got that, then
maybe you don't have rights to delete from your database? Check how the DSN
is giving you access and make sure your login has delete privileges.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[David]

I'm running out of things to try, several people mentioning the delete
button reference more recent versions of Project.
I have Project 98

I created a new DSN with the SQL Administrator Logon and Password.
No Delete Button

I've created a DSN to connections other than SQL, and every one does the
following.
File...
Open...
...ODBC
Brings up the Import Dialogue box (never an open dialogue)

I'm assuming the deletefromdatabase method is not a common option for
deleting projects from databases anymore since everyone seems to have a
delete button from their open...ODBC dialogue.

In my original search for ways to delete a Project 98 project from the
database the "DeleteFromDatabase" was the only method referenced.