Accessing a JET (.mdb) database in Python
Is there a way to access a JET database from Python? I'm on Linux. All I found was a .mdb viewer in the repositories, but it's very faulty. Thanks ...
jet
How to convert a JET database to SQLite?
The title says it all. I'm a Linux user so an open-source, Linux-friendly solution would be preferable. Thanks ...
OleDB Jet - Float issues in reading excel data
When I read a sheet into a DataTable using the OleDbDataReader, floating point numbers loose their precision. I tried forcing OleDb to read the excel data as string, but although the data is now contained in a DataRow with each Column defined as System.String it looses precision (18.125 -> 18.124962832). Any idea how to avoid this beh...
Error accessing certain Excel sheets with Jet
I am using ASP.NET to open an Excel 2003 document hosted on the server. The excel spreadsheet, produced by a system outside of my control, has 5 named worksheets. I access the data in each sheet as follows (line breaks added for readability): string ExcelConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sample.xls; Extended ...
How to combine two sql queries?
Hi Guys, I have a stock table and I would like to create a report that will show how often were items ordered. "stock" table: item_id | pcs | operation apples | 100 | order oranges | 50 | order apples | -100 | delivery pears | 100 | order oranges | -40 | delivery apples | 50 | order apples | 50 | delivery Basically I...
JET SQL: do LEFT JOINS and RIGHT JOINS only work under JET 4.0 and above?
Does the following article apply to all uses of JET (including from within client apps via DAO or OLEDB): http://support.microsoft.com/kb/275058 Does this mean JET 4.0 or above is mandatory for anything involving an Access MDB? ...
What does Error 3112 indicate when compacting an MDB file?
What does Error 3112 indicate when compacting an MDB file? The Error description is "Records can't be read; no read permission on 'xyz123.mdb'" There is a known issue with the Compact function on some versions of Access MDBs. Is the solution in this case to run the Microsoft utility JETCOMP.EXE on this file? What are the other possib...
Get id when inserting new row using TableAdapter.Update on a file based database
I have a database table with one field, called ID, being an auto increment integer. Using a TableAdapter I can read and modify existing rows as well as create new ones. However if I try to modify a newly inserted row I get an DBConcurrencyException: OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Sou...
How to determine Jet database Engine Type programmatically
I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn't already that version. (This enables use of SQL-92 syntax features) Upgrading is (relatively) easy. A call to the JRO.JetEngine object's CompactDatabase method (as described here) should do the trick, but before I do this I need to de...
Help with this JET Sql Query [SOLVED]
Hi: I need help to do this query select. for example I have these fields: idInvoice date amount Depending of the date I need multiply the field "amount" for x number or other one. For example, if the date is less 01/01/2010 to multiply for 20 . But if it is major or equal to multiply for 35 Select idInvoice, date, amount, amou...
VB6: what is the likely cause of Error 3078 " ... Jet database engine cannot find the input table or query ... "
VB6: what is the likely cause of Error 3078 " ... Jet database engine cannot find the input table or query ... " ...
eclipse Java Emitter Template class loader issue
I'm trying to pass one of my own classes to a Java Emitter Template but i can't get it to work. The generated Java file looks ok and can be compiled manually. But the JETEmitter will fail like this: The import test cannot be resolved : 'C:/prj/.JETEmitters/src/test/eclipse/codegen/TestTemplate.java' at line 4 Hello cannot be resolved to...
Getting around the lack of a Left Trim(string, char[]) function in JET / Access
I need to remove leading zeros from a string field in an Access database that is destroyed and recreated every time it is used within a C# program. Most string libraries (even SQL ones) include a Trim function to remove leading or following whitespace. Unfortunately, Access does not seem to have a LTrim(string s, char[] trimChars) or som...
Will an MS Access back-end for a client server application have transfer speed problems?
If I use MS Access in the back-end of a client-server type software and the database file is sent from client to server, will it create any problems in further database handling, transfer speed, or performance compared to SQL Server? ...
OLEDB JET error in Vista & Windows 7, not in XP.
I wrote an application with VS2008 on Windows XP, and produced an .EXE file. This application will only run on Windows XP OS. It fails on Vista and Windows 7. It gives an error saying that a Microsoft OLEDB JET 4.0 occurred. I use Microsoft Access as a db in this app. What should I do? ...
Which affects Access Database performance more: Thousands of tables or Millions of records?
We're using an Access Database as the back-end to our software product. The program has been alpha/beta tested at a company for about 2 years now and we've noted that one of our tables has been filled with over a hundred thousand records in that time. This is probably not an example of the heaviest usage that our product will endure, an...
Database advice needed: porting VB6/ADO/JET app to VB.NET
I need to update (well, rewrite really) a SMALL VB6 application which uses ADO to access a JET database, to a vb.net app in Visual Studio 2008. My research suggests that I should use LINQ, but it doesn't seem to be possible to connect to JET. If JET is now deprecated, what should I use? Or should I use ADO.NET without LINQ? Please don'...
Jet Database and pass-through queries, parameters
Hi, I'm connecting to a Jet 4 DB through ODBC. The Jet DB uses pass-through queries to an Oracle DB. This works so far (can't access the p-t queries directly, but creating a view on the query does the trick). I need some subset of the data returned by the p-ts. Parameters would be best, but are not supported. Two questions: 1) Jet d...
Typeof data in GridView/ Listview bound, template and auto-generated fields
Background: I'm populating lots of asp.net c# GridViews and ListViews from a database and subsequently users may export them to Excel. I want export as native Excel (not html). I can't use office automation, and I'm using JET which works fine. I have no control over users' machines. Question: When doing the export, you have to tell Je...
Are Hierarchical Rowsets supported by JET and SQL Server?
The OLE DB documentation documents a hierarchial rowset feature, with SQL examples, but doesn't indicate what DB providers support it. Do JET and SQL Server support this feature? And do they use the same sort of syntax as in the documentation, or their own extended syntax? ...