“Cannot define field more than once” error when opening Pervasive table in MS Access?

A few months ago, I updated a system that uses Pervasive v11. Only after that update, I started having problems with...

Combobox null in if statement?

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it h...

ms access - vba: Compile Error: expected: =?

I have a subroutine as below Public Sub updateStagesTable(sName As String, percentageValue As Double) stageName...

What is causing my OLEDbException, IErrorInfo.GetDescription failed with E_FAIL(0x80004005)?

I am using an OleDbConnection, OldDbCommand, and OleDbReader against an Access database. I have a named query in th...

SQL MS Access - Invalid Use of Null?

I have now got rid of the overflow on this query by forcing to a long but now I get Error 94: Invalid Use of NULL ...

Microsoft Access VBA - Run time error '3075'?

I've encountered the run time error '3075'. I'm a novice in VBA! >.< Can i know where did it went wrong? I can...

getting an Unexpected error from external database driver (1) when importing data from excel to access?

I have a 2010 Excel file with a sheet that spans 34864 rows and 1387 columns. I'm trying to import it into Access 20...

'Id' is not an index in this table - MS ACCESS?

I am getting errors in Access when attempting to open both the database and the table. Error: 'Id' is not an index...

Run-time error '3061'. Too few parameters. Expected 1. (Access 2007)?

I have the following 'set recordset' line that I cannot get working. The parameters seem correct according to all av...

Change caption of button to field in a table using Access?

I am trying to make the caption of a button the content of a field from a table. Everything I am finding online in...

Error 3219- Invalid Operation?

I try to write a query in my Access Project but this runtime error occures in the line, where SQL query is. This is...

Access query error (“syntax error in from clause”)?

$consulta3 = "SELECT * FROM Dept INNER JOIN Userinfo INNER JOIN Checkinout on Dept.DeptName = '...

no value given for one or more required parameters?

What's wrong in here, I always get some nasty errors even if the same code that I used earlier works. But when I app...

Run Time Error '2501'?

I'm having the Run Time Error '2501' on a Form. Does anyone have ideas of why this happens and how to fix it? The R...

Persist Security Info Property=true and Persist Security Info Property=false?

For the properties: Persist Security Info=true and Persist Security Info=false Can you tell me what is the dif...