I am using pyodbc, via Microsoft Jet, to access the data in a Microsoft Access 2003 database from a Python program. The Microsoft Access database comes from a third-party; I am only reading the data. I have generally been having success in extracting the data I need, but I recently noticed some discrepancies. I have boiled it down to ...
I have a table that contains, among other things, about 30 columns of boolean flags that denote particular attributes. I'd like to return them, sorted by frequency, as a recordset along with their column names, like so: Attribute Count attrib9 43 attrib13 27 attrib19 21 etc. My efforts thus far can achieve something...
I can use the following syntax in a Jet (mdb) query to select data from another .mdb file: SELECT * FROM [Database=C:\Tempo\AnotherDB.mdb;].MyTable alternatively SELECT * FROM MyTable IN 'C:\Tempo\Another.mdb' I want to extend this to use workgroup security a.k.a. User Level Security (ULS). I know how to specify a userID and passwo...
Hi All, I have a 3rd Party tool that generates an xml spreadsheet (*.xls). I have another program that reads this spreasheet and processes it. The content of the generated xml spreadsheet is a table with 5 columns and my program runs select queries on them. I m facing an issue while opening a connection to the generated spreadsheet. It s...
I have an MS-Access database with a DateTime column. ex: 03/08/2009 12:00:00 AM. I want query based on date like: select * from tablename where date='03/08/2009' I want display data as 03/08/2009 12:00:00 AM. How would I write this query in C#? Please help me. ...
Hi, I am using MS Access Database and trying to full data from C# 2.0. How can i get the constriant name (Eg: name of Primarykey not the field name of primary key) using ADOX. Thanks in advance Madhu ...
Consider the following table with a constraint that's a bit daft but simple enough to demonstrate my point. Note that, to keep things very simple, the constraint's criteria only involve literal values. The column ID only exists because a table must have at least one column (!!) but that column is not involved in the constraint. While a l...
Our application (sadly) uses an MDB back-end database (I.e. JET engine). One of the items being persisted to the database is an "event" object. The object is persisted to a table with an ID (EventLogID) that is an Autonumber field. The NHibernate mapping is as follows: <class name="EventLogEntry" table="tblEventLog" proxy="IEventLogEnt...
Hello! I wanted to use JET (Java Emitter Templates) in my Netbeans projects, but had to find out that JET heavily depends on Eclipse libraries. Is there something similar to JET, but as a standalone project? Something which is open source and well maintained? Futhermore, is "code generation" the common term for such tools? I didn't fi...
I have an ASP.NET Project. I am connecting to the DB and then closing and disposing of the connection object. But when anyone enters my site, MS Access creates a temporary dbname.ldb. When I want to download my original mdb file from my server it won't let me access the mdb file. I can't do anything if there is ldb file in server. It's l...
If I have an MS Access database with linked tables from two different database servers (say one table from an SQL Server db and one from an Oracle db) and I write a query which JOINs those two tables, how will Access (or the Jet engine, I guess?) handle this query? Will it issue some SELECTs on each table first to get the fields I'm JOIN...
We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a temporary .txt file using a schema.ini. (I'm not sure yet exactly why are are writing to this temporary file, but that's how the code currently works). From there, we are loading a DataTable via OleDB using the following connection string (for ASCII...
I need to manipulate some tables in a JET database housed on a web-server: check existing indexes change table cluster/primary key see what tables exist rename tables add tables drop tables browse data etc I don't have the option of installing PlaneDisaster or Access (even if i had it) on the local machine. I've already written a ge...
I realize that the answer to this question is likely quite obvious (if somewhat inconvenient to me), but I'm hoping someone will have an ingenious solution. I'm slowly building an application in my free time that I hope will be useful at work. It's a simple tracking application for the assignment of peer reviews. Basically, I'm just try...
Hi, I'm using this query to get some specific data: "select * from emp where emp_name LIKE 's%'"; emp_nam is character field, how can I use the same logic condition with numeric field? something like: "select * from emp where emp_id ???? where emp_id is numeric field. Thanks, ...
Hey Guys, here is my code for this, the only help i get from VS is that the INSERT INTO statement syntax is incorrect? I have gone through all of the code and just cannot see where i have gone wrong, can someone gimme a hand please? public void New(string ApplicationStartupPath, string FileName, string Department, string Month,...
There was a problem with DAO 3.6 in that it didn't support row-level locking. For details, see this Knowledge Base article. I learned from the Access team's blog: In Office Access 2007, new objects, properties, and methods will be added to DAO to support the new features in the Access database engine. From looking at this li...
Hello. I am currently creating dynamic SSIS packages that import/export and access data between a SQL Server and several Access DB files. (Jet files if you want to get technical.) Anyways, everything is successful during testing, as long as my SSIS packages have hard-coded connection strings to the Access file. This is great and works f...
We've inherited a rather large Access DB that has some very strange (and unsettling) behaviour: Some updates to the database are lost. What can we do to avoid this? Are there any settings in Access to provide better transactional control? Here are some more details: We have one access user that has write access (shared by a very limit...
Hi all. I'm having a dead-end situation with one of the clients using my software. Out of about 40 copies of our product sold (Application programmed in .NET 2.0 using VB.NET 2005), about 2 get non-responsive with 1 core of the dual core CPUs stuck at 100% (program uses 1 core only) The most logical guess is an infinite loop causing th...