Questions tagged as 'ms-access'

Tagged questions
2
answers

Where to create a database without having privileges

I created a "program" in Access because I need a database, and having a graphical environment, everything was going on until the company "remembered" to delete Access from the available package. As I am not a system administrator, I ask if there...
asked by 11.04.2016 / 21:12
1
answer

Error in doing search by name Access ASP.NET C #

I have a search error by name (value entered by the user) in the access database it says that the values inside the parameters are null. Follow the code.       Person.cs responsible for the bank's logic. public Contato obterCadastroPorNome(str...
asked by 11.11.2016 / 13:35
1
answer

INSERT with Random SELECT

I have a table with a lot of information and an empty one. I need to make an INSERT on this empty table with just one information from the other table, but SELECT must be random. I'm using the following line in VBA: db.Execute "INSERT IN...
asked by 30.09.2018 / 08:15
1
answer

Open Access file on linux

By connection, how do I change my DSN? one of the cases in my connection class that opens file in access case "fatura" : $strHost = ""; $strUser = ""; $strPass = ""; $strBase = "";...
asked by 29.08.2018 / 15:50
1
answer

JAVA Query with ACCESS - Slowdown

I need access to the database ACCESS, the query is accessing correctly, but I noticed that to have the information return, JAVA first reads and all tables and all data, is it? does not have a way of doing the query only what is requested? DAO...
asked by 15.02.2016 / 14:33
1
answer

Validate field in VBA

In Mozambique there is a unique tax identification number (nuit), and this number takes 9 digits. How would an application validate nuit under the following conditions? If there are more (+) or less (-) than nine (9) digits, say "nuit inval...
asked by 10.06.2014 / 11:16
1
answer

How to calculate delay in days in Access

Today I use the formula =DIAS(HOJE();H2) to calculate the delay time in Excel: But this source I extract from Access, does anyone know the syntax to mount this formula in Access?     
asked by 04.12.2018 / 13:16
1
answer

Access - Update on table without using VBA module

I need to update a table once a month, in which the inserted data should be placed in its current month. I have done this using VBA code, but since the table has approximately 30,000 lines, the process is time consuming. I would like to perform...
asked by 28.03.2018 / 20:09
1
answer

Error executing select with alias

When executing the query below using AT instead of "T" as a join alias, the following error is returned: "IErrorInfo.GetDescription failed with E_FAIL (0x80004005). " OleDbDataAdapter da = new OleDbDataAdapter("SELECT A.*, " +...
asked by 04.10.2017 / 23:08
1
answer

Connecting MS Access and PHP

I have a problem connecting to MS Access and PHP, this is giving an error that I do not know how to fix, could someone help me? The code is this: //Abre a conexão asdasda $conn = new COM('ADODB.Connection') or die('ADO não iniciado'); //lin...
asked by 25.07.2017 / 13:38