jet

相关标签：javascript jquery android 多少钱 iPhone

Page-level locking in Jet 4.0 insert? "Can't update; currently locked" error

I\'m getting this error intermittently before record insert on a subform. The subform is in \'continuous records\' mode. The subform recordsource is a parameter query opened via querydef.OpenRecordse[详细]

2023-02-12 05:34 分类：问答
Where can I find the documentation for the particular kind of SQL used by the Jet 4.0 engine?

Which I think is the same as the one used by MS Access, which I think is not the same as the one used by MySQL and others. I need the documentation fo开发者_如何学Gor this particular \"kind\" or \"sub[详细]

2023-02-09 07:16 分类：问答
Getting "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)" when querying "select * from open"

I have my C# app connected to Jet 4.0 engine. When I run the query \"select * from open\" (I think \"open\" is a keyword and this is why I\'m getting an exception, but...) I 开发者_Python百科get this[详细]

2023-02-09 04:30 分类：问答
How do I use my alias in the where clause?

I\'m trying to search multiple columns of text and memos for certain phrases and blacklist phrases I don\'t want to see.[详细]

2023-02-08 05:45 分类：问答
SQL Statement With Several Logical Operators

I need to run a SQL query where -current_queue does not equal i01 and does not start with F -prod_code starts with R[详细]

2023-02-08 00:42 分类：问答
VSTO Outlook GetTable filter, why is it invalid?

I\'m trying to get a table from the contacts folder GetContactsFolder().GetTable(filter, OlItemType.olContactItem);[详细]

2023-02-07 05:57 分类：问答
C# change mdb filed data type to memo and save it

I would like to change the data type in my db from \"Text\" to \"Memo\". first o开发者_运维技巧f all, I didnt find the \"Memo\" data type in c#.[详细]

2023-02-07 02:02 分类：问答
How to make Extensible Storage Engine Database Shrink? - the database should not have much data inside?

Hoping Laurion Burchall is listening :) My database has a longbinary field that is used to temporarily cache some data.The data may not actually be needed for very long.Typical sizes range from 1k to[详细]

2023-02-06 12:37 分类：问答
vb.net database application does not work on user machine if database is password protected

In vb.net I am using password protected database with following connection string connetionString = \"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\vai\\vaiDB.mdb;Jet OLEDB:Database Password=s开发[详细]

2023-02-05 14:54 分类：问答
convert database field encoding in Jet Database / Delphi

I have a legacy application written in Delphi which uses a Jet Database as its back-end for storing data and I need to export the data to a new format.[详细]

2023-02-05 12:35 分类：问答