There are two concatenation operators available in Access: +; and &. They differ in how they deal with Null. “foo” + Null returns Null “foo” & Null returns “foo” So if you want to update Null [My Column] fields to contain “Prefix ” afterwards, use … SET [My Column] = “Prefix ” & [My Column] … Read more
You’ll need to declare this WinAPI function in order to call it from procedures in your code. From HERE Private Declare Function URLDownloadToFile Lib “urlmon” Alias “URLDownloadToFileA” (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long Public Function DownloadFile(URL As String, LocalFilename … Read more
In Access you need parentheses when you have more than one join: FROM (drugs as a INNER JOIN warehouse as b ON a.ID = b.drug_id) INNER JOIN pharmacy as c ON b.drug_id = c.drug_id
The FileDialog object is not provided by the Access library, but by the Office library. So your code should work if you set a reference to the Microsoft Office [version number] Object Library. Either you don’t have that reference set, or it’s broken. However if it were me, I would leave the reference unset and … Read more
In many cases we can achieve a similar result by performing an unequal self-join on the table and aggregating the results. For example, for data in a table named [MyData] Ino TYPE DOC — ——– — 1 1800xxc1 3a 2 1810xxc2 3b 3 1700xxc3 3c 4 1700xxc4 3a 5 1800xxc5 3a 6 1800xxc6 3a 7 … Read more
My approach to security in Access is the following: Encrypt the main database using a complex password. Use a second database to log in to this encrypted database. The second database stores usernames, user salts, and an encrypted version of the main database password with the user password. This way, no user needs to have … Read more
PASSWORD is a reserved word in Access SQL, so you need to wrap that column name in square brackets. You really should use a parameterized query to protect against SQL Injection and generally make your life easier. Try something like this SQL = “INSERT INTO [Accounts] ([StudNo],[Password],[FirstName],[LastName],[YrandSec]) ” & _ “VALUES (?, ?, ?, ?, … Read more
The problem here is that the imbedded image was not a simple BMP or JPEG. It was a Microsoft Word Picture and the OLE header information was considerably larger than the 300 byte window of the original GetImageBytesFromOLEField() code. (That is, after scanning 300 bytes it just gave up with “Unable to determine header size…”.) … Read more
Take a look at this very thorough list of reasons why recordsets are and aren’t updateable: When Recordsets Are Always Updateable A recordset is always updateable when: It is based on a single table. It is based on a query based on a single table. It is based on a query based on tables with … Read more
It’s mainly a matter of history, effectively ACE has superceded JET: Wikipedia answers your question in great detail. The most relevant sections are: With version 2007 onwards, Access includes an Office-specific version of Jet, initially called the Office Access Connectivity Engine (ACE), but which is now called the Access Database Engine. This engine is fully … Read more