problem with a query

Help,

Code:

---

Rstring = "select * from `custmers`"
    DBr.Open Rstring

---

what is the problem here??

i see no problem and the softwere says its illegle.

-k3pos

Your SQL string should be...

Quote:

---

Rstring = "select * from custmers"

---

assuming also that that is the way you spell customers.

You use ' marks in most SQL queries to show text values, for example

Code:

---

Rstring = "SELECT * FROM custmers WHERE custmer_name = 'Jones' "

---

If you are using ADO, you need to add the connection object

Code:

---

Rstring = "select * from `custmers`"
    DBr.Open Rstring, ConnObjectGoesHere

---