Connect to Access with a DOS program?

[Jouster]

Sorry if this is a silly question, but is it possible to write a dos program that can connect to an Acess Database on the network server and retrieve some data? If so where can I find the information.

Thanks,

Rick

 

[nja5150]

I'm not sure of any DOS program that can directly open up Access files...but that doesn't mean it doesn't exist

I'm using a DOS program now that was developed with Visual FoxPro. The data is stored in .DBF files. Access can link/create/edit these files with an ODBC driver found at Microsofts Visual FoxPro site.

What I am doing is reverse of what you want though. There might be other roadblocks to this idea...and this definately is not a direct solution to what you need.

 

[willir]

You would need an ODBC DOS driver to perform this. I am not aware of any. However, Access can read a DOS file.

 

[alvechurchdata]

However, Access can read a DOS file

If you were to use the dbf format then you could write the DOS application in a DOS version of FoxPro and read the files in Access. This gives you a clear upgrade path to Visual FoxPro if yo need to move across to Windows later.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dragonwell]

OK - I might be way off here, but by DOS do you just mean something that can be run from the command-line? If so, a script like jscript or vbscript can do this using ADO.


Share your knowledge! -

http://www.howisitdone.com