Solved
March 16, 2009
Is the join expression not supported by MS Access?
Can anyone explain to me what is wrong with my query? SELECT T2.TIPOPRODUTO , T2.PRODUTO , T1.ESPESSURA , '' AS LARGURA , '' AS…
thumb_up 8
trending_up 4
Access VBA
<p>Relational database design, SQL integration, and form logic.</p>
Solved
January 7, 2009
Difference between DBEngine.BeginTrans and DBEngine.Workspaces(0).BeginTrans
In Access, what is the difference between these two statements? DBEngine.BeginTrans and DBEngine.Workspaces(0).BeginTrans The documentation for both leads to the same place.
thumb_up 7
trending_up 6
Solved
January 7, 2009
Managing and debugging SQL queries in MS Access
MS Access has limited capabilities to manage raw SQL queries: the editor is quite bad, no syntax highlighting, it reformats your raw SQL into…
thumb_up 11
trending_up 11
Solved
December 23, 2008
Create a query dynamically through code in MSAccess 2003 [VBA]
Hi I need to create a query in MSAccess 2003 through code (a.k.a. VB) -- how can I accomplish this?
thumb_up 19
trending_up 9
Solved
November 18, 2008
Simple Oracle SQL date syntax question
I am trying to convert a working MS Access query to run on an Oracle database being accessed via VB Script (.asp). This is…
thumb_up 14
trending_up 6
Solved
October 21, 2008
What are the major drawbacks to using OpenOffice DB vs. Microsoft Access?
I know that Open Office Database uses a java database backend. Does anyone have any insight on how this compares to the Jet Database…
thumb_up 5
trending_up 6
Solved
September 27, 2008
How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?
Does anyone know how to modify an existing import specification in Microsoft Access 2007 or 2010? In older versions there used to be an…
thumb_up 31
trending_up 27