Interface between WSH and MS-Access!

[TimoW]

Hi!

Is it possible to read from and write in a MS-Access database(mdb-File)? I want to store my Script Results in a mdb-File! If it is possible could you explane me what I must do?
I heard there must be a possibility to do this with a OCX-File, but I don't know where I can get it and what I should do with it.

Thank you!

I'm Sorry for my bad English! I'm still learning!

[darkness]

There are multiple ways to do this. Easiest might be to use ADO. You actually perform Insert/Update/Delete/Select queries directly against the database. What you need to do is create a DSN on your machine connecting to the access database. Next you document the column names that you need to perform searchs etc... A real easy way to test your queries is cut and paste them from the Query environment in the access database. A good resource for this is www.learnasp.com this site shows you how to write db interaction. And really asp is just vbscript or jscript encapsulated in webserver environment. You can just cut-paste the vbs code to the vbs program your writing.

Michael McLaughlin/images/forums/icons/smile.gif
Systems Manager
Minnesota State University Mankato

[TimoW]

HI!

Thank you for your Reply!
I don't know any thing about this things!
Who can I create a DSN on my machine? And where can I get a ADO?
Can you give me links to the Programms and Co. I need? And a link to a script example were they're used in? You would help me very much!

Thank you!

TimoW

[darkness]

http://www.microsoft.com/data will help explain things. Also go through www.learnasp.com it's a good site and explains all about ADO and DSN calls in vbscript.



Michael McLaughlin/images/forums/icons/smile.gif
Systems Manager
Minnesota State University Mankato