VB Forum / Database Access / January 2004

I have had to convert code that used UDL back to ODBC when
transferring applications from NT 4 and 2000 into an XP environment.
I'm developing in VB and when I try activating the application from
VB, or simply running the executable under XP the application can not

I search a way to get the Last X record of a table....
Ex:
Table name =  Example
Field name = Values

The general task would be to convert data (of a database) to an Xml file. If all given nodes in data would be unambiguous then I would not see a big problem. My problem is that some of the nodes are dynamic, i.e. the same node can appear in data several times.
For example (part ...

I am using ADO to search for specific records in an Access database. Using the Find method works well UNLESS the search criterion includes text with an apostrophe ('), eg
recordset.Find "Name='" & pname "'
pname might equal the text "Adviser's
The program ends with a debug message ...

I am so desperate right now...I hope someone can help..
I have a VB6 project that includes a Data Environment with a hierarchical command from a SQL 2000 database.  I have a form that displays the data.  Some controls are bound to the Data Environment and not edittable, and others ...

I have a code module,  which queries an MSDE database on my local machine.
I had been using ODBC to access the data and I was very disappointed with
the performance.   Today I looked at using OLEDB drivers instead of ODBC.
Below is the connection strings and start and end times of ...

Hi group
I'm running into a rather puzzling situation.  When I run a SQL statement using the LEFT OUTER JOIN clause, I am not pulling back all the data I am expecting
However, when a run the same SQL statement using the *= operator, I get back the data I am expecting
For example

I have a statement in SQL that works within SQL7, but not
in VB6.  It comes up with too many arguments errors.  Is
there anyone that can help with this difference between
sql7 and vb6.  The statement is below and works within

Is there a third party "grid" that can show recordsets that do not support
the bookmark property?
Thanks.

I have been an ASP web developer (using vb components) for some time
now.
Just recently a more experience developer put a demon in my head, by
stating that the proper way to design a database driven site (and for

I have a small problem and I need some guidance.
I am using the following sub to create a table and add 6 fields.
Private Sub psInspectionTable()
   Set mobjTable = New ADOX.Table

I tried:
Dim db As Database
Dim rs As Recordset
Set db = OpenDatabase("E:\ACT\Database\Contacts.dbf", 0, 0, "dBase III;")

i can't insert a Date value from vb.net to MSDE,
do i need convert the data to fit database field?
(the data type in database is DateTime, and i just want to store date value
only)

Hi! i have read the posts of the thread: re:write back to a remote
access database posted last December 14, 2003.
I am also developing a VB application that needs to access a remote
database (MS Access database) on a web server.

pls help, urgently needed ,
when I press the control button on the keyboard and click on the datagrid
rows, it does get
selected , however when I press delete button it displays ' multiple rows