How do I open a project from database used VBA?

S

Spring

I have a project saved in the sql server database, I want open it used VBA
and not used ODBC data source.
The command fileopen must have a ODBC data source and not have server name
in command.
It have a method to open project not used ODBC data source?
 
R

Rod Gill

Unfortunately Project uses ODBC to talk to SQL Server, Record a macro of you
opening a project from SQL Server and what gets recorded is what you have.
 
S

Spring

I used hereinafter two kind to open project:
1. FileOpen Name:="<ODBC data source name>\Project1", ReadOnly:=False,
UserId:="user", DatabasePassWord:="", FormatID:="MSProject.ODBC"
2. FileOpen Name:="<{SQL SERVER}>\Project1", ReadOnly:=False,
UserId:="user", DatabasePassWord:="", FormatID:="MSProject.ODBC"

That must create a ODBC data source in the computer, I don't want the user
know the server name and userid and password.
Have a kind open a project and user don't know project in which server and
how to open in database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top