VB Forum / Database Access / December 2005

Been reading every sql/ado/mdb/database related article, website, newsgroup
etc I can find to learn vb/ado/mdb/sql.
About half the articles I've found say always name your tables singular, eg
tblEmployee, and that each row is an instance of that singular object type.

I need to open a MDB file for my report program. However, there is one MDW
file. Everytime I tried to connect MDB file, I have share error. MDW file is
not let me connect database. How can I solve this problem? Please let me know

I have the following code which I have also duplicated in Access 97 with the
same problems:
Set rs_BidsQuery = db_BidBase.OpenRecordset( _
  "SELECT BidNames.Selected, " & _

I have a dataset and have a field call "Name" in this dataset, how can i get
this vale, because i need use this data to compare with the user input. how
can i do it ?

Please check the following code where I am not able to delete the
records where Arrival Date is less than current date. But if I change
it a greater than current date then it deletes all records from the
table.

I currently have a VB.NET application using a number of forms which
access an Oracle database via ADO.NET.  I have pooled the connections.
Everything is fine when someone is working on a screen.  The trouble is
that if the screen is left for a time, the software disconnects from the

Hello Friends.
I have just started a small project front end as VB6 and Access 2000
An Inventory system.
Is the code for the multi user is different, and how does I install i

I have several users running an application against netwroked copy of Access.
The application inserts several hundred records into a table at a time , and
when more than one user is running, we occasionally get 'Could not
update,currently locked' error message.  What can I do to ...

I got an assignment to optimize a custom application which is developed in
Visual Basic as front end (Interface) and SQL Server as back end (Database).
I have studied that application and found some points, but would like to
discuss one point as this could be the major factor for ...

I am trying to create a windows app with data access.  I need to load few
tables on a dataset when the app loads.  I now I need a dataset, dataadapter,
and connection obj. I would like to know which is the best way to go about
loading the tables onto the dataset. My plan was to ...

Is it possible to access the 2005-sql-server-generation by way of VB6 and
ADO?
Or will it be necessary to go to vb.net?
Will there be, or is there, an ADO-Version that works with the SQL Server

I have VB6 ado call to an access 2000 db.  The connection string looks
like this:
       strAccessConnect = "Driver={Microsoft Access Driver (*.mdb)};" & _
                   "Dbq=" & strCurrentPath & strCurrentDB & ";" & _

Hello All you smarter than me, people!
With ADO, I keep reading
               "Uses a dynamic cursor. Additions, changes, and deletions
               by other users are visible, and all types of movement

I am trying to create Excel workbook through ADODB. Which works fine. I
put some data manually in it and try to read back through ADODB. Now, I
am not able to retrieve any rows from the workbook. However, I retrieve
correct number of columns which I created through ADODB. Below, is ...

Getting the error message when updating a record.
         "Error -2147217864 Row cannot be located for Updating. Some values
may have been changed since it was last read."
Doesn't happen all the time, just sometimes. If I update one record and then