The front end application is MS Excel 2000 which queries and updates the backend system (MS Access 2000). I am using ADO to connect to MS Access. I wrote some VBA code in Excel to update the Excel spreadsheet with data from Access. How to update a spreadsheet with ADO Recordset? please help...
Please suggest why the following code is not working.
===================
===================
Private Declare Function LogonUser _
Lib "Advapi32" Alias "LogonUserA" _
(ByVal lpszUsername As String, _
ByVal lpszDomain As Any, _
ByVal lpszPassword As String, _...
Hi,
I need to build an Excel application (excel 2000) that uses Windows authentication. That is to say, when the user clicks on the excel spread sheet, he is required to enter his Windows user name and password before he can view the content of the spreadsheet. I was told that in the program I...
Hi Geoff
I don't really want to get the password off the system to check against, but I want to make sure that the user's password and user name are the same as their Windows Login ID and password. There is no need to get the password stored in the Windows registry in clear.
Please suggest...
Hi,
I need to build an Excel application (excel 2000) that uses Windows authentication. That is to say, when the user clicks on the excel spread sheet, he is required to enter his Windows user name and password before he can view the content of the spreadsheet. I was told that in the program I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.