jet Questions
6
I am having a problem with my application. When it is run, the error displays
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local
machine.
I tried changing Platform to X86 C...
22
Solved
I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit server it shows the error "Microsoft.Jet.OLEDB.4.0' provider is not ...
Juicy asked 2/1, 2010 at 13:52
11
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? Somet...
2
I downloaded a database file with the extension "VMD".
Now I'm looking for a windows software which can open this file, so that i can see all the included tables to (later) export some of them info...
7
Solved
This works as expected:
SELECT "Mike" AS FName
This fails with the error "Query input must contain at least one table or query":
SELECT "Mike" AS FName
UNION ALL
SELECT "John" AS FName
Is thi...
4
Solved
I need to see if a table exists in an Access database used by my c# program. Is know there are SQL commands for other databases that will return a list of tables. Is there such a command for Access...
3
I've been fighting with OleDbConnection for a while now trying to get it to not cache. Basically I am accessing a shared Access database, which is being written to from another application, and the...
Suttles asked 28/6, 2012 at 10:45
5
Solved
I have a JET table with an auto-number as the primary key, and I would like to know how I can retrieve this number after inserting a row. I have thought of using MAX() to retrieve the row with the ...
4
Solved
I'm creating a utility to import data from Excel to Oracle database,
I have a fixed template for the excel file,
Now, when I'm trying to import the data by Jet provider and ADO.Net - Ole connection...
Flotation asked 29/8, 2010 at 14:34
6
Solved
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() 'Sa...
3
I'm a Linux user so an open-source, Linux-friendly solution would be preferable.
1
Solved
I have a query I am attempting to run however I keep getting a syntax error when running it. Below is the query that is giving me the error:
SELECT A.*, B.Total AS Assigned
FROM (
SELECT tblSkill...
4
Solved
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...
6
Solved
Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this reg...
4
Solved
4
Solved
Currently I'm thinking about replacing the usage of Microsoft Jet MDB databases on a single-user .NET C# Windows Forms application by a SQlite database.
My goal is to lower installation requiremen...
5
Solved
I have been digging internet for couple days, reading very old information, that leads to very old and nonexisting sites, still, I understood, what is needed to achieve my goal.
We have a file.md...
13
I need a function which executes an INSERT statement on a database and returns the Auto_Increment primary key. I have the following C# code but, while the INSERT statement works fine (I can see the...
Marabelle asked 9/10, 2008 at 9:38
10
Solved
I found this code online to query Access and input the data into excel (2003), but it is much slower than it should be:
Sub DataPull(SQLQuery, CellPaste)
Dim Con As New ADODB.Connection
Dim RST As...
2
Solved
In this forum here , someone mentions that Entity Framework does not work with Access (Jet DB - .mdb). However it seems that there is a provider for Jet DB as described here
Which makes me think t...
Adjunction asked 25/6, 2012 at 20:57
8
Solved
We know the MS Access database engine is 'throttled' to allow a maximum file size of 2GB (or perhaps internally wired to be limited to fewer than some power of 2 of 4KB data pages). But what does t...
Sheepfold asked 3/8, 2009 at 9:35
1
Solved
My SQL query is as follows:
SELECT * FROM Suppliers
WHERE SupplierName
LIKE 's%';
When I submit this query on W3 School's TryIt Editor (v1.2) (http://www.w3schools.com/sql/trysql.asp?filename=try...
Chateau asked 27/9, 2013 at 12:41
9
Solved
Someone asked me this the other day, and I couldn't think of a good answer. Platform portability is completely irrelevant to the project.
In fact, Jet has some features that SQLite does not, namel...
5
Solved
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:\Te...
3
Solved
How to determine (for a machine running windows xp/vista/7) whether ACE or JET is installed, so I can use an appropiate connection string to connect to a access database.
1 Next >
© 2022 - 2024 — McMap. All rights reserved.