Top "Jet" questions

Table-less UNION query in MS Access (Jet/ACE)

This works as expected: SELECT "Mike" AS FName This fails with the error "Query input must contain at least one …

sql ms-access jet

How fast is SQLite compared to Microsoft Access MDB?

Currently I'm thinking about replacing the usage of Microsoft Jet MDB databases on a single-user .NET C# Windows Forms application …

.net sqlite ms-access jet

How can I get a list of tables in an Access (Jet) database?

I need to see if a table exists in an Access database used by my c# program. Is know there …

c# .net sql ms-access jet

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 …

vba ms-access ado dao jet

VBA: Querying Access with Excel. Why so slow?

I found this code online to query Access and input the data into excel (2003), but it is much slower than …

excel vba ado jet

Select Top (all but 10) from ... in Microsoft Access

Say I've got a query SELECT TOP 10 ... FROM ... ORDER BY ... in Access (well, really Jet). The question is: how can …

sql ms-access jet

@@IDENTITY after INSERT statement always returns 0

I need a function which executes an INSERT statement on a database and returns the Auto_Increment primary key. I …

sql database ms-access primary-key jet

Is Jet database engine included in Windows xp, vista and Windows7?

I need a data store for single-user, read-only access. I need multiple tables, but not related. I also need to …

jet

Access/jet equivalent of Oracle's decode

Is there an equivalent for Oracle's decode() in Access (or Jet, for that matter). The problem I am facing is: …

sql oracle ms-access jet

Connect to MS Access remote .mdb file from php on linux

I have been digging internet for couple days, reading very old information, that leads to very old and nonexisting sites, …

php ms-access odbc jet unixodbc