Reply to thread

Message: [QUOTE="GS, post: 14133067"] Jan, I've never used ADODB with db files, only Excel workbooks and plain text files. That means I would not know what requirements are needed for accdb files. If, as you say, you don't need a username then delete that part of the code. what I was able to find via google is: cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=S:\MyFolder\myDB.accdb;Persist Security Info=False;Jet OLEDB:Database Password=123" ...which appears to be similar to what you posted, though not 'exactly as posted'. This suggests that the password methodology is still JET tech, even though you're using the ACE provider. That also explains why some legacy Excel addins of mine that use JET only still work in Excel 12 and later. -Obviously, JET is still supported but I don't know that it works with accdb files. It could be, though, that JET persists to work only because I use workbooks and/or text files!<?> [/QUOTE]