rcorrea
09-01-2005, 12:15 PM
I have a prog that connects to an Access database over the network, on a win2k server.
What I would like to do is code a username and password into the connection string so the program will authenticate as administrator.
The reason behind this is because the win2k server isn't part of our netware network, so the users are totally different. We mainly use the win2k server for IIS for our intranet.
I don't want to have to create every single netware user on the win2k server, its a beeyotch to make them match up.
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\ras\c$\access db\CompInfo.mdb;Username=Administrator;Password=blah"
MyConn.Open
The above gives me an error, what am I doing wrong?
What I would like to do is code a username and password into the connection string so the program will authenticate as administrator.
The reason behind this is because the win2k server isn't part of our netware network, so the users are totally different. We mainly use the win2k server for IIS for our intranet.
I don't want to have to create every single netware user on the win2k server, its a beeyotch to make them match up.
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\ras\c$\access db\CompInfo.mdb;Username=Administrator;Password=blah"
MyConn.Open
The above gives me an error, what am I doing wrong?