Search results

Hi, I am trying to open the excel file using VBA in MsAccess using below code, its execute fine and but didnot open the excel file Can any one help me where i am missing , that would be great help. ---On Btn Click event------------ Private Sub Command0_Click() Call ExcelInstance End Sub...

Hi, I created two seperate pass through queries in MS Access SQL Mode its take long time to save and open the same pass through queries . My table is on server and access on my local pc via ODBC link. Please try to resolve this issue , when i have make any changes in pass through query , i...

Hi, I have build one query which has 8 -9 subquery and 5-6 tables each table has 1/2 million records . i link tables via ODBC in oracle.this query take minimum 2 hour to execute, Please any one could suggest me , how to optimize the query and achieve the result in less time. Many Thanks

I want to run simple Select * from Tablename using vba code not going in query design mode. usually i use first create simple query in query design mode with name abc then in vba code I have made the odbc connection in Ms-Acccess Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim...

I have database in Oracle by using the odbc link , I access the table in MS-Access2003 and then made the queries with that table. I link one table from oracle database using Odbc link. my column name in table has underscore like Field_name. if i make Pass-through query like: select...