Re: Access mdb file

Tech-Archive recommends: Fix windows errors by optimizing your registry

Almost forgot, I then get the error:

ODBC Microsoft Access Drive Login Failed

Is there a standard password I can use or a way for me to get it so as to do
a data conversion project?

Thanks,

"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:eC9rciLtFHA.1848@xxxxxxxxxxxxxxxxxxxxxxx
>A value less than 0 means the query failed. Use AERROR() to create an array
> of errors and find out why the query failed.
>
> Dan
>
>
> Mike wrote:
>> Hello - can someone please elaborate on this. When I test this the
>> value in nerg is -1. Do I need to use create connection or something
>> before running this code or is this code all I need. Are there any
>> step by step instructions on how to create a query from a table in an
>> mdb file? This code and the code from the other replies in this
>> thread is not working.
>>
>> Thanks,
>>
>> "tom knauf" <hbgmail@xxxxxxxxxx> wrote in message
>> news:dbfnjj$h1n$02$1@xxxxxxxxxxxxxxxxxxxx
>>> Hi,
>>>
>>> if you just want to read from access (and know/ask user for the
>>> tablename)
>>> we use code like this :
>>>
>>> cFile = "d:\Daten.mdb"
>>> cconn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" + cFile +
>>> ";Exclusive=1;Uid=admin;Pwd="
>>> nConn=SQLSTRINGCONNECT(cConn)
>>> IF nCOnn>0
>>> nerg = SQLEXEC(nCOnn,'Select * from table1','dummy2')
>>> if nerg>0 && Now data is in cursor
>>> dummy2 SELECT dummy2
>>> browse && or so
>>> endif
>>> SQLDISCONNECT(nConn)
>>> ENDIF
>>> CLOSE DATABASES
>>>
>>> You do NOT need a sqlserver or msde, just installed acces or
>>> installed access odbc drivers.
>>>
>>> HTH
>>> Tom
>>>
>>>
>>>
>>>
>>> "Jan" <nomail@xxxxxxxxxxx> schrieb im Newsbeitrag
>>> news:uyoDTfdiFHA.3336@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Hi all,
>>>>
>>>> I have a small app that does some reporting from legacy dbf files.
>>>> The app
>>>> that created the dbf files has been migrated to a windows app and
>>>> now produces mdb files. What do I need to access mdb files from
>>>> vfp? I would like to add this as an option to my existing reporting
>>>> app so that the user can choose from their older files or their
>>>> newer ones to produce the report.
>>>>
>>>> Some sample code would be useful as would a pointer to the
>>>> available syntax to do this.
>>>>
>>>> TIA
>>>> Jan
>
>


.