VB Forum / Database Access / August 2005

Ok so heres the code.. for some reason I kept getting the no
permissions message, so I attempted to add the access workgroup file.
Now I
get the "Authentication Failed" message. This is a secure database.

I want to be able to have a Macro in Excel to delete or clear contents in a
number of rows or cells with the start row being user definable
can you help?  I just can't get anywhere with this
many thanks

I have a VB6 app that is trying to detach a database from SQL Server, copy
the database files, rename them and then attach the new database (in essance
duplicating the database and renaming it on the same server).
Upon running the code I get the following error:

I have some trouble in searching a field for the apostrophe character.
If I try it using the Access query wizard, it returns some results, but
translating exactly the same query to a DAO recordset it returns nothing.
The query generated in Access is:

I have a simple script in VB .Net.  I need to convert it to VB6.  Can anyone
please lend a hand?
THANKS!
Dim srv As New SQLDMO.SQLServer2

I am using ADO using VB
I have Insert Query and using cmd.execute, my underlying table has primary
key as autonumber. After execute has been called the record will be added
and how can I get the autonumber for that added record....any tips

I have a program which multiplies product prices by number ordered
The Product price is stored in Access 2K as a Double and is often listed to
4 decimal places
The product price is say $0.35 but access stores it as .3456

Can Anybody Help Me
my code to open recordset is
Set RsAddressDB = New ADODB.Recordset
SQLstr = "Select * from AddressDB_Table"

I am trying to create an Access DB with a table with a column that is the
Primary Key and AutoNumber, programmatically, by ADOX. The Primary Key code
works; the column is a Primary Key. The code to make the same column
AutoNumber generates an error; "Multiple-step OLE DB ...

I am slowly learning to play nice with the DOM, but have a question. I am
attempting to read an XML file which has many nodes set up as:
<object>
    <info1>

the data menu option in visual basic 2005 "Configure Master-Details" dont
activate when selecting bindingsource control so it works which which control
?

My Code is like this for First and Next
'--------.MoveFirst------------
   SQLstr = "SELECT top 1 * FROM  AddressDB_Table"
   RsAddressDB.Open SQLstr, DataBaseConnection, adOpenStatic,

I have a VB module that creates a lot of records in a disconnected
recordset object.  All the fields in the recordset are identical to
the field names in an Access 2000 .mdb file table.  
The table in the .mdb file will always be completely EMPTY of all

I am using ADODB.Connection to execute multiple sql instructions INSERT
within a while.
I want to know if for each INSERT that I execute the ADODB.Connection do a
commit ? or it is do it  after go out the while cycle?

In my Installshield package, I set it to install both MDAC 2.7 and JET 4.0.
My program is using late blinding to the ADO objects.  (e.g.)
CreateObject("Adodb.Connection")
Some of the XP boxes seems to have problem with the late blinding.