I couldnt' find anything on the net soo here's my problem.
We have a vba access runtime application and this application was installed on a computer that was recently formatted and then was installed with Windows XP SP3 edition. After I install the runtime application the user is unable to insert/update anything to the database. I am sure it's able to reach the database since he's able to run searches.
The error that comes up every single time user clicks on the "insert" button or "update" button is: "Type Mismatch" error. Which I assume has an error number of 13. This same application is working perfectly fine on all the other machines with windows xp or with windows 2000. Even on a machine that has XP SP2 and XP SP3. Moreover, in one of the searches that brings results back to the listbox. One of the columns always says "Binary" even though it should have some sort of number like: 22-33-23-65. The reports that we generate also is showing bunch of "Empty Boxes" and weird characters instead of the number I mentioned above. I did check the regional settings on the user's machine and they do seem fine. Data coming back is in English.
If anyone at all can suggest me ANYTHING that I can try. Please tell me. Thanks.
I haven't checked what you suggested. I will once I go back to work. But I was assuming that was the whole reason that Access Runtime Application comes handy that we don't need to worry about what client computer has or does not have. Because all the files that the application needs are already packaged along with the application anyways. So I assumed it had to be related to some Windows XP missing dll's or something along those lines?
all the files that the application needs are already packaged along with the application anyways.
Not always. I believe it has the standard references, but if you go adding libraries I'm not sure those extra references will be there in runtime. I hate runtime, because you can't step through code with it to isolate problems like this.
So I assumed it had to be related to some Windows XP missing dll's or something along those lines?
I was thinking more along the lines of office dlls, but it could be XP as well I guess.
I did what you suggested. But unfortunately all the dll's and refrences were fine and vba has access to all the dlls that are refered in the refrences. So what i did I actually went to debug it. And I notice that the error occures when a recordset is being opened. When the rst is opened (below) there is no value that comes back and because no value is coming back the case 1 statement fails and throws Type Mismatch error. The problem is why is the value not being able to be selected? In all the other machines it works fine. I am using MYSQL ODBC 3.51 driver. Before I tried using 5 but that didn't even open the Access db. But the build that I am using is 27 I don't know if that could be the issue or if it's even related to MYSQL driver. Here is the code:
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.Open "SELECT @INSERTCompleted AS STAT, @lastrec AS LASTREC;",myconn, adOpenForwardOnly, adLockReadOnly, adCmdText
If Not rst.EOF Or Not rst.BOF Then
blnCompleted = rst!STAT
Select Case blnCompleted