[AccessD] Cannot open second Recordset?! SOLVED

S D accessd667 at yahoo.com
Wed Mar 31 05:31:57 CST 2004


Hi Ryan, Gustav,
 
you're both correct! thnx a lot.
 
Sander


rsmethurst at uk.ey.com wrote:
Sander,

I had a similar problem not so long ago and it was definitely associate
with a reserved word in the syntax.
If you place [ ]'s around all field names, I'm pretty sure it will work
for you...and if you need to find out which one it is, just remove them
one by one.
(Was a real pain because that error message is about as helpful as a kick
in the teeth.)

Ryan





Gustav Brock 
Sent by: accessd-bounces at databaseadvisors.com
31/03/2004 10:27
Please respond to Access Developers discussion and problem solving


To: Access Developers discussion and problem solving

cc:
Subject: Re: [AccessD] Cannot open second Recordset?!


Hi Sander

Maybe End is a reserved word?
Try leaving out one field name, then another etc. until the query
doesn't fail.

/gustav


> when I change the SQL:

> strSQL = "SELECT InterfaceID, FieldID, FieldName, Start, End,
> Mandatory " & _
> "FROM tblInterfaceLayout " & _
> "WHERE InterfaceID = " & InterFaceID

> strSQL = "SELECT * FROM tblInterfaceLayout WHERE InterfaceID = " &
InterFaceID

> it does work?! How is this possible? BTW i did NOT misspel the
fieldnames because when I use the debug window to display strSQL I can run
the query!!

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






This e-mail and any attachment are confidential and contain proprietary information, some or all of which may be legally privileged. It is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient, please notify the author immediately by telephone or by replying to this e-mail, and then delete all copies of the e-mail on your system. If you are not the intended recipient, you must not use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and any attachment has been checked for viruses, we cannot guarantee that they are virus free and we cannot accept liability for any damage sustained as a result of software viruses. We would advise that you carry out your own virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered in England and Wales with registered number OC300001 and is a member practice of Ernst & Young Global. A list of members? names is available for inspection at 1 More London Place, London, SE1 2AF, the firm?s principal place of business and its registered office.
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---------------------------------
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.


More information about the AccessD mailing list