VB Forum / Database Access / September 2004

Hi gurus,
Does anybody know how'm I setting 'memo' column type in ADOX for an Access
database? Like in the context:
<code snippet>

I would like to translate an algorithm written in Matlab language in Visual
Basic language. Is it possible?
Someone has experience with this kind of translations or someone knows if
there is some tool that does the translation in automatic?

I've got a VB6 application that uses an Access 2000 database with ADO.  
Occasionally I get a "multi-step operation generated errors" message when
trying to change the value of a field in a recordset.  The data type is just
simple text and the problem is intermittent as far as I ...

I need to delete a table via DAO. I can see how to use a tabledef
object to determine the table exists but do not see how to simply
delete it from the database.
TIA,

Message cross posted to ADO and DAO groups as involves both.
I am at a loss here as to what I am doing wrong......
Does anyone have any suggestions as to the following.
SELECT ACCTRANSACTIONHEADER.ACCDEBTORSID,

Anyone know how the Login Page in VB should be like? Using ADODB Connection, I've got connection code done, but I have no idea how to start this one involving the use of recordset. Can anyone give some code example? By the way I'm using VB 6.0 Thanks in advance.  

I've this problem
I have an application that run on computers dislocated in 3 different net class (es.
XXX.XXX.100.XXX, XXX.XXX.101.XXX and XXX.XXX.102.XXX).
For any net I've a domain server but I would like use a single MDB file (ex. over http)

Having a very odd problem with Oracle 8i involving table/column names.
So far the problem seems to crop up only when I'm connecting to an
Oracle data source; the code below works fine with MySQL, MS-SQL, etc.
Anyone have any tips, tricks, suggestions to get rid of this

i'm using Visual Basic 6.0 Application , and Connect to SQL Database by
ODBC.
but i think when you config ODBC to Connect SQL Server any outher
Application Like (MS Access)

warning ado noobie question ahead
I've been reading up on sql but still haven't figured out how to count the
returned records (duh!)
I have referenced Microsoft Activex DataObjects 2.7 Lib in a vba project

I am currently using DAO 3.6 in my app to create an Access database from
scratch. I am having problems trying to format a Time field. When I create
the field I set it to a dbDate type and then update the database. When I
look at the info it appends  AM or PM to the time, the info is ...

How to reference a single field in an ADO recordset?  I need to compare the
date in the current record and then grab it in the next record.  But I am
not sure how to do this in MC Access.

Can anyone assist me in how to access a single field in ado access db

Hello, I convert my Access 97 Database to Access 2002-2003, because I’m now
using WinXP. And now when I run my VB program, I get Runtime error '3343' -
Unrecognized database format. I'm using DAO350.DLL. Do I have to change to
another DLL? Thanks.

In my application I have to read an excel files. There are two problems I
found.
First Select * from table only works if table was already predefined in
excel (not a spreadsheet name)