Linked Questions

Ask Question
16 questions linked to/from How to securely store Connection String details in VBA
Hot Newest Score Active Unanswered
1 vote
1 answer
206 views

We have a Word VBA application that is installed in over a 1000 computers and users use it on a daily basis. This VBA addin connects to multiple databases whose credentials are stored in a custom xml ...
Sai's user avatar
  • 722
8 votes
4 answers
4k views

I have an excel file that contains a series of OLEDB connections leveraged by several pivot tables. I would like to create a VBA function that removes all password from that several connection string ...
David Rogers's user avatar
  • 2,743
1 vote
2 answers
14k views

All. I have used a DLL approach explained on How to securely store Connection String details in VBA This code is running very well on windows 10 64 bit and MS Office 64 bit. But same copy of the ...
Shekhar Nalawade's user avatar
  • 127
3 votes
2 answers
3k views

I have an Excel spreadsheet (.xlsb) that connects to an SQL Server via ActiveX Data Objects (ADO) in VBA that I have to share with a bunch of people. The code uses the following string to connect do ...
dkodr's user avatar
  • 83
3 votes
2 answers
3k views

I have an Excel VBA tool which needs to query Oracle. I am using ADO. When building the connection string, I get the database, username, and password out of cells in the spreadsheet. What is a more ...
Erik Olson's user avatar
  • 1,174
2 votes
1 answer
4k views

I am calling oracle stored procedures via Pass Through Query in MS Access. In pass through query properties we are saving connection string with password. I don't want to allow the user to see the ...
y2j's user avatar
  • 207
-1 votes
2 answers
4k views

I've been working with macros on VBA for a while, and there's some information on them that I want to hide. As excel is a very unsafe language, I've come with the idea of creating an .exe file of the ...
Martin Router King's user avatar
  • 155
8 votes
2 answers
1k views

Is there a way to protect VBA Password protection against a crack such as this one: Is there a way to crack the password on an Excel VBA Project? Or this one: https://superuser.com/questions/807926/...
Oday Salim's user avatar
  • 1,147
1 vote
1 answer
2k views

We have several applications in Access/VBA (2013, 64 bits) and the data is stored locally and we want to start saving the data in SQL Server over the network, but connection credentials are visible ...
Georges's user avatar
  • 11
0 votes
1 answer
2k views

I need to send reports to clients. The report is generated in excel via web query. The draw back is everyone has access to the excel, can see the connection string, which could be used for ...
user3447315's user avatar
  • 33
0 votes
1 answer
1k views

I have a question about the ADODB.connection. I use ADODB connection to connect to Access in my Excel application. Do I need to close the connection manually, or will it be closed automatically when ...
Guoliangcai's user avatar
  • 67
-1 votes
1 answer
463 views

I am connecting my Excel 2016 document to my SQL Server to pull data from a table. I can get this to work fine but the issue is with the security. I may be remembering this incorrectly but I thought ...
PJD's user avatar
  • 775
1 vote
0 answers
451 views

Dim con As Object Dim rs As Object Dim cmd As Object Dim query As String Set con = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") Set cmd = ...
Shekhar Nalawade's user avatar
  • 127
0 votes
0 answers
432 views

Background I have an Excel application that connects to SQL Server using ADODB Connection via VBA. This ADODB Connection contains credentials that are hard coded. I know this is not best practice. ...
Oday Salim's user avatar
  • 1,147

15 30 50 per page
1
2