Question about Microsoft Visual Basic 6.0 for PC
Whenever I am running the project, in some forms there is as an error as mentioned below. "Syntax error in From clause"Here table name is also correct but the above error is occuring in the line below rs.Open "user", db, adOpenKeyset, adLockOptimistic, adCmdTable .I haven't used any From clause
Try to run the record set query (the one rs.open uses ) directly in the db you are using .
If you are not sure what is the query concatenate it into variable and get the full query just before you open the record set.
once you do that you will get better idea of what is wrong with the query .
Posted on Jul 20, 2009
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Aug 08, 2014 | Office Equipment & Supplies
May 27, 2014 | Texas Instruments TI-84 Plus Silver...
Apr 06, 2013 | Computers & Internet
Dec 06, 2012 | Mozilla Firefox
("syntax error" is a kind of...):
Apr 25, 2011 | Playdom WSOP Poker
Dec 20, 2010 | Microsoft Internet Explorer 8
Oct 13, 2009 | Microsoft Windows Vista Home Premium with...
372 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: