Microsoft Access is a rapid application database development and reporting tool.
3
votes
0answers
187 views
Report Builder (Digital Metaphors) add empty rows in details band until the end of page
I am using ReportBuilder 10 in Delphi 2006 with an Access 2000 database. I am trying to create a report using a filtered query.
Telerik Report : Starch line in Detail band or Add Empty rows
Repeat a ...
2
votes
0answers
31 views
byte vs retrieving runtime performance measurement
I am doing a project of image processing in which i am copying pictures inside a byte[] in c# and matching it with some algorithm. I have placed two options inside by software, so user can select ...
2
votes
0answers
269 views
Libraries for connecting node.js to odbc on Windows?
I'm looking for a library that allows node.js to connect to ODBC on windows. All the libraries I have found thus far seem to work with UnixODBC but not windows, can someone please suggest a library ...
2
votes
0answers
1k views
java.sql.SQLException:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
I have a java application that uses access database. My PC has 64-bit Operating System, 64-bit Microsoft Office, and 64-bit JDK. I even installed the Access Database Engine x64. Basically everything ...
2
votes
0answers
648 views
Open ms-access data file (*.mdb) with OpenOffice
I'm trying to browse an ms-access data base on a mac. Best results so far, I had with using OpenOffice on a Mac like described here.
Now I can see all the tables. But when I try to access the data ...
2
votes
0answers
357 views
Datatable-Access Database Updating Concurrency violation
I'm working on a project which uses an Access database. First of all I copy the information that i need from db and put it in a DataTable (with combining 2 tables). Over this datatable I search items; ...
2
votes
0answers
323 views
How to connect with database in talend
I am facing a problem. I can't connect to my Access Database. I selected the Database but when I checked the connection, an error message appear. The error message is
: [Microsoft][Pilote ODBC ...
2
votes
0answers
616 views
Is it possible to modify an MS Access database schema using ADO.NET?
I need to modify the schema of an MS Acess database (.mdb) via code.
Since the Jet Engine DDL statements (ALTER TABLE, etc.) are quite poorly documented, I'd prefer to use some kind of object library ...
2
votes
0answers
1k views
What Access 2010 Ace DAO libraryfiles do I need for VB6 connection
Hello and thank you for reading/helping :).
I have an application that was created with VB6 using MS Access 2003 with DAO 3.6.
Upgrading the Access database to 2010 has been accomplished and I am ...
2
votes
0answers
282 views
Retrieving MS Access column with international name from Java (encoding)
I need to import data from some legacy Access databases. I ran the code with some database file, and everything went fine. Now, I tried it with another one and the same code doesn't work.
It seems to ...
1
vote
0answers
25 views
How should I specify an item in a checkbox list, when using the dom?
I am currently automating use of the wordpress editor using VBA in access 2003, but would like to extend the automation to include the selection of category, taxonomy items etc.
That is with Checkbox ...
1
vote
0answers
38 views
VBA PasteSpecial does Partial Paste
thank you in advance for taking your time to help me out,
I currently have a loop running which selects a range, copies and then pastes the values in the required columns.
Set ...
1
vote
0answers
27 views
Exporting MS Access Forms and Class / Modules Recursively to text files?
I found some code on an ancient message board that nicely exports all of the VBA code from classes, modules and forms (see below):
Option Explicit
Option Compare Database
Function SaveToFile() ...
1
vote
0answers
16 views
Why does my query add an ORDER BY property whenever I open it in SQL View
This annoys me to no end. Whenever I edit a lot of my queries in design / SQL view, after saving them, it adds random fields that I'm not even querying for in the ORDER BY property of the query. That ...
1
vote
0answers
44 views
Access Form Textbox as Input query to ODBC source returns empty dataset
I have an Access 2010 utility that is designed to query an Oracle DB via ODBC connection as Linked Tables. I created a simple form with two textbox's and a command button. The command button ...