Well this is something I have never come across before, however, I have found a solution. The error message itself got me wondering why the send command wasn’t recognising the defined application. I questioned whether the code was running too fast. (I don’t know where this light bulb moment came from but it has fixed … Read more
Users put “locks” into an LDB. An LDB is a kind of database of locks for MS Access. Users also put “locks” onto LDB’s and MDB’s. These locks are part of the native database primitives provided by Windows and Windows networking. If there are no locks IN the ldb, the user is not writing into … Read more
You’re facing a limitation of Access SQL text parameters. They can not accommodate string values longer than 255 characters. Here is a simple example which demonstrates the problem. Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strUpdate As String Dim strLongString As String strLongString = String(300, “x”) strUpdate = “UPDATE tblFoo SET memo_field = … Read more
A variant is the only type of variable that can store an empty value or a Null value, and is declared thus: Dim aVar as Variant Dim aVar2 ‘ if no type is given then it’s declared as a variant Immediately after declaration a variant stores no value and it is empty. Also you can … Read more
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
First create an _MouseUp event to execute on the respective control looking to see if the right mouse button was clicked and if so, call the .ShowPopup method. Of course this assumes the Private Sub MyListControlName_MouseUp(ByVal Button As Integer, _ ByVal Shift As Integer, _ ByVal X As Long, ByVal Y As Long) ‘ Call … Read more
For Acces databases (.mdb, .accdb, etc…), you want to use OleDbConnection, not SqlConnection (SQL Server), like this: conn = new System.Data.OleDb.OleDbConnection(@”Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\BC207\test.accdb”)
In line with my comment above and the answer by Yawar, I’m not aware that Pass Through Queries are ever editable/updateable. They are editable in the sense that you can edit a save Pass Through Query object, but I don’t believe it’s possible for a Pass Through Query to produce an editable recordset. There are … Read more
Support for DEFAULT was included in Access DDL with Jet 4 (Access 2000). However it can only be used in DDL executed from an ADO connection. This worked with Access 2007. CurrentProject.Connection.Execute “ALTER TABLE MyTable ” & _ “ALTER COLUMN field2 SET DEFAULT “”foo””;” Note if your db file is Access 97 or earlier, you … Read more
This may be an issue with DPI awareness. Specifically, your application is not declared as being DPI aware and when your code accesses the Microsoft.ACE.OLEDB provider, its process is set to being DPI aware. This is something that I discovered by accident a while ago, but I never seen anyone else report it happening. The … Read more