Re: Access mdb file



I would use ODBC after creating a System DSN to the access MDB directory.

There is a topic in the VFP help files called "How to: Set Up an ODBC Data
Source" - if you check the index for ODBC you will find several topics of
interest - probably with some sample code.

--
Kind regards

Phil Hollingworth
phil@xxxxxxxxxxx
System spec: Win2k3 / VFP 9 (All fully service packed / updated etc)

"Jan" <nomail@xxxxxxxxxxx> wrote in message
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
>
>


.



Relevant Pages

  • Re: Word 2007 mailmerge
    ... The app has been runing fine in Word 2003 for some time, ... odbc for dbf seems to be there. ... "search folder" that does not appear to pick up data sources recently ...
    (microsoft.public.word.vba.general)
  • Re: Extracting data with VFP from PRISM database
    ... Windows "Query Builder" app that looks like it might have been done in VB. ... The app gets data from the PRISM db in the following manner as far as I can ... does Alphameric have a Windows compliant ODBC driver or an OLE DB ...
    (microsoft.public.fox.programmer.exchange)
  • Re: ODBC call failed - weird behavior
    ... It could be an MDAC issue. ... checker on a machine where the app works and another machine ... You could also turn on ODBC tracing then reproduce your ... >ODBC tables to connect to an SQL Server 2000. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Advice request for project
    ... > might be my first opportunity. ... > GUI app on the XP workstations. ... > using odbc to the database. ... Python Web Programming http://pydish.holdenweb.com/ ...
    (comp.lang.python)
  • Login failed for User
    ... I have a question about logging in to MSSQL Server. ... users can log in to our app if they are logged in to the ... If we add the Windows User to ... If the user is logged in as a regular user the odbc fails ...
    (microsoft.public.sqlserver.security)