Search results

How to track changes to the database Access, keep a log of changes. Or compare recordset with an array in Excel? The "Microsoft Access 2010 PROGRAMMER'S REFERENCE" there is a common example of using these macros to track changes in tables. Or create a table with logs and global function to...

Help pls change ADODB.Recordset and adodb.connection with New.ADODB.Recordset and New.adodb.connection in that code: Option Explicit Function DataSql(dt_sql) DataSql = "#" & Format(dt_sql, "mm\/dd\/yy hh\:mm\:ss") & "#" End Function Function GetAccessConnect(FilePath As String) Dim sCon As...

Help write code to set a password on the Access database through excel. And just ask to help with the code - how to open password-protected database from Excel. It so not simple for me. Many days spent, but no any ideas and working solution. Example where need out it in attach. Use only...