D
DrAvi via AccessMonster.com
Hello,
These are my first steps with SQL, and I'm sorry if my questions have obvious
answers...
In short, I used to have MDB frontend and backend. The BE exported to SQL
Express 2008 and is connected to the MDB frontend using ODBC. This array
works great and fast locally, but takes ages when remote connecting.
My first question is – any suggestions what to check and how to improve the
remote servicing?
I'm trying to rebuild my Frontend and to rewrite all my Queries to SQL.
My second Question is – which is preferred – MDB using Pass-Through Queries,
or ADP using stored procedures?
My third and main question:
I'm trying to write simple Pass-Through Query, and want to get only the
results matchs to selected value from a text box "TxtChooseYear" placed in a
form "FrmSelect".
The statement I wrote is:
SELECT TblWorkingHours.*
FROM TblWorkingHours
WHERE (TblWorkingHours.RemYear = FrmSelect.TxtChooseYear ) ;
And I'm getting errorMsg : " The multi-part identifier "frmSelect.
TxtChooseYear" could not be Bound. (#4104)
I tried to change the WHERE statement to:
WHERE (TblWorkingHours.RemYear = Form_FrmSelect.TxtChooseYear ) ; - And the
ErrorMSg is the same as above;
WHERE (TblWorkingHours.RemYear = ' FrmSelect.TxtChooseYear ' ) ; - And the
ErrorMSg is: "Conversion failed when converting the vachat value 'FrmSelect.
TxtChooseYear' to data type int. (#245) "
Any suggestions how can I read variants from Forms?
Thank you and Happy New Year!
Avi
These are my first steps with SQL, and I'm sorry if my questions have obvious
answers...
In short, I used to have MDB frontend and backend. The BE exported to SQL
Express 2008 and is connected to the MDB frontend using ODBC. This array
works great and fast locally, but takes ages when remote connecting.
My first question is – any suggestions what to check and how to improve the
remote servicing?
I'm trying to rebuild my Frontend and to rewrite all my Queries to SQL.
My second Question is – which is preferred – MDB using Pass-Through Queries,
or ADP using stored procedures?
My third and main question:
I'm trying to write simple Pass-Through Query, and want to get only the
results matchs to selected value from a text box "TxtChooseYear" placed in a
form "FrmSelect".
The statement I wrote is:
SELECT TblWorkingHours.*
FROM TblWorkingHours
WHERE (TblWorkingHours.RemYear = FrmSelect.TxtChooseYear ) ;
And I'm getting errorMsg : " The multi-part identifier "frmSelect.
TxtChooseYear" could not be Bound. (#4104)
I tried to change the WHERE statement to:
WHERE (TblWorkingHours.RemYear = Form_FrmSelect.TxtChooseYear ) ; - And the
ErrorMSg is the same as above;
WHERE (TblWorkingHours.RemYear = ' FrmSelect.TxtChooseYear ' ) ; - And the
ErrorMSg is: "Conversion failed when converting the vachat value 'FrmSelect.
TxtChooseYear' to data type int. (#245) "
Any suggestions how can I read variants from Forms?
Thank you and Happy New Year!
Avi