Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect to Access with a DOS program?

Status
Not open for further replies.
Jouster

Jouster

Programmer
Dec 4, 2000
82
0
0
US

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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
You would need an ODBC DOS driver to perform this. I am not aware of any. However, Access can read a DOS file.
 
Upvote 0 Downvote
However, Access can read a DOS file
Click to expand...
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
 
Upvote 0 Downvote
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.

[pipe]
Share your knowledge! -
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Harami12
  • Locked
  • Question
Where to Next in Programming 2
Replies
2
Views
179
Andrzejek
Andrzejek
LuciusThorne
  • Locked
  • Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
157
mintjulep
M
RasaBu
  • Locked
  • Question
Hello, I need to create a FoxPro
Replies
1
Views
126
Mike Lewis
Mike Lewis
dwf1962
  • Locked
  • Question
Trying to write a simple Foxpro prog to convert database of probabilities to a life expectancy table
Replies
1
Views
161
SkipVought
S
Mayhem9
  • Locked
  • Question
Yes/No checkbox showing as -1/0 once filter is applied.
Replies
7
Views
150
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top