VB Forum / Database Access / November 2004

Please help!
A strange buggy quirk has cropped up in my ADO Recordset object. Initially,
it worked fine. Now, however, when the Find method is invoked, and the
specified record is not found it does not return EOF as it should. Instead,

is there a way to compare 2 sql server database 1 table at a time to see if
there are any records that are not the same.
thanks

I've got an Access 2000 database set to SQL Server compatible SQL. A field
in a table is text and can contain the ' character.
I have a recordset and user the filter property to check if a record exists,
something like:

im using the following code to generate a local record set containing all our
clients
Set adoPrimaryRS = New Recordset
     adoPrimaryRS.CursorLocation = adUseClient

is there any way to attach a macro to filtering opperation?
suach as "sendkeys home"

I have and ADO.Net/OLEDB connection string that specifies the machine and
database name in the string as follows:
Provider=SQLOLEDB.1; Data Source=ABCDE; Initial CataLog=MNOPQ; User
ID=sa;Password=dd529a

I have a VB 6 application and store the data in Access 2000 database.  My
application is multi-user on Windows 2000 NT server.  In the past few weeks,
the database is becoming corrupt.  I do run a compact and repair daily on the
database.  Also, when we receive the corruption ...

Guess I'm confused about the difference between Microsoft ActiveX Data
Objects 2.7 tlb
and Microsoft ActiveX Data Objects (multi-dimensional) 2.8 tlb.
I thought 2.8 was the newer version and required in certain situations, so I

Doean anyone know of a tool that will analyse my Access 2000 .MDB file and
generate the CREATE table definitions? Any help will be greatly appreciated.
Thanks in advance,
-U

Why doesn't this work?
.Fields.Append "WCmd", adChar
the other parameters are optional?
Error 3001, arguments are the wrong type?

I am a newbie at ADO code and would like to update a recordset as follows:
rs.Open "UPDATE OccMag AS omg SET omg.AxSeroma = [chkAxSeroma], " & _
       "WHERE omg.AilmentID= " & Me.AilmentID & ";"
My connection string is fine, but I get an error on this line.

Does anyone know how to launch wscript from within MS Access vba, so I can
pass a varible from the access to the Wscript/Active directory?
Thanks

is there a way to compare 2 sql server database 1 table at a time to see if
there are any records that are not the same.
thanks

In Access 2000 database, I have SSNs as text with input mask xxx\-xx\-xxxx &
birthdays in the mm/dd/yyyyy format and input mask 99/99/0000.
In my VB6 Form, I have SSN & birthday text boxes formatted as xxx-xx-xxxx
and Date (mm/dd/yyyyy) respectively.