SQL server MS project 2000 integration

[Marcel]

Im opening MS project plans from an access DB. Access and Project are both
running form MS SL server "not a project server" MS project clients are set
up to use an ODBC connection. The SQL server in using the sa account for the
clients to authenticate onto the server. So far so good BUT every time a
user connects to a project plan the it requires the user to inout the
Username and Password, this is gererating complaints. The Question

How do I pass the UserName and Password from VBA so as to authenticate the
user onto the SQL server?

Im using the shell command
params = """<" & Recordset("PROJ_DATA_SOURCE") & ">" &
Recordset("PROJ_NAME") & """"


WindowID = Shell("C:\Program Files\Microsoft Office\Office\WINPROJ.EXE " &
params, 1)

I've seen a few ways of connecting using /u Username /p Password but they
dont seem to work as the syntax hasnt been documented very clearly

can anyone please help me


regards

Marcel

 

[Mike Glen]

Hi Marcel,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP