Questions tagged as 'ms-access'

Tagged questions
2
answers

corrupt access database: "Unrecognized Database Format"

Good! I am using Microsoft Access 2007 to do my practices at home with JAVA and VB.NET. I ran the program that I had done in VB.NET when out of the blue reproaches me with the message of the title ... I tried to download the database I had in...
asked by 12.12.2016 / 00:49
2
answers

Query access keysensitive

I have a query of the style: SELECT * FROM tabla WHERE keyTabla = 'cadena'; What I want is for this query to compare the key and the string but discriminating upper case of lowercase.     
asked by 13.12.2017 / 15:32
2
answers

Why do I get "System resources exceeded" C # Access?

I'm working with c # and access, this is my code: foreach (var item in alumnos) { OleDbDataReader reader = Connection.Read("SELECT * FROM Estudiante WHERE cod=" + item.cod);...
asked by 09.10.2017 / 16:44
1
answer

create table from java that has a database in access

I would like a table, when I want it to increase again from 1, but I searched in many places and this can not be done from java ... although if someone knows it would be great, if they could help me. Then going back to the topic, as an alternati...
asked by 11.03.2017 / 05:04
1
answer

INNER JOIN in Update

I am migrating an Access query to SQL Server, the problem is that in Access it allows to perform INNER JOIN in the UPDATE UPDATE (Aux_Nodos INNER JOIN Nodos_NULL_Titular ON Aux_Nodos.Necesidad = Nodos_NULL_Titular.Necesidad) INNER JOIN Out_Arc...
asked by 13.02.2017 / 16:38
1
answer

Problem accessing the Access Database with UcanAccess in Java

I am with a simple project, learning to create, modify and access databases from Netbeans with Java . They force me to use a Microsoft Access database, and I know there are problems accessing them from Netbeans version 8 . I am using the...
asked by 26.01.2017 / 23:27
1
answer

Access query with DateTimePicker type dates in C #

Good morning. I have a problem with my code. Does not understand the variables for a query between dates DateTimePicker . This is my code. public DataTable selcfecharegitro() { DataTable dt = new DataTable(); OleDb...
asked by 20.12.2016 / 13:43
1
answer

Open a report with several IDs

I have a Recordset that offers data with between 1 and 10 records. On the other hand, to call a report that shows on each page the data of its associated table given some Id's: DoCmd.OpenReport "ordentallerSobre", acViewPreview, , "ID IN (2...
asked by 27.09.2018 / 18:08
2
answers

Error in SQL statement in access

Could someone please tell me what is the error in this sentence or what is missing? select count(distinct BLART) from COV_SAP_AccP_LA where Country = "XXX" I'm doing it in access and what I want is for you to tell me separately the...
asked by 10.08.2018 / 14:41
1
answer

Access database connection with JAVA

Greetings I do not know why the connection does not run, it will be for the jackcess that will be obsolete or for the version of my jdk 1.8? because you already add JAR UCanAccess 4.0.4 to libraries through netbeans packag...
asked by 20.04.2018 / 21:50