help

Any have any suggestions?


All right, I am learning VBscript with a hands on approach (trying to teach my self). However I am in need of knowing how to do something quickly.

I have queries setup to gather the information that I want, however I have the problem of users who are not using Access '03, so I created DataAccess pages. Is there a way I can use VBscript to run these same queries and return the information in a new window?

Let me know if this makes absolutely no since, I will try and revise if it does not.
Thanks, Chad

===============

I don't have any VBscript, currently accept for what Access 03 generated for me.

I want Access to be the database (obviously) however since other co-workers use Access 97, they can not run the querries that I have setup in Access 03. So what I am trying to do is add the queries to the web page, or use VBs to call my databases table(?do not know how that will work if the table is inbedded in the database) and then generate a printable form based on selected queries?

Maybe VBs is not the best way to go. But it is about all I have to work with. Thank you much for your time.

Save your Access databases as Access 2000, they're the most compatible.

Yessss, It is. Unfortunately it does not work. This is why I am using the web format.
Thank you.

You should look in to coding your own asp pages for database access. When you rely on apps like Access to make your pages, you are in a very restricted environment where your stuff isn't very portable to other servers.

*cough*

Ok, sweet!
So know for the next question, do you know ASP pretty well then Doug?
If so could you help me with the code, or help me find an INFORMATIVE tutorial?

Thank you, ASP from what I have seen looks to be the way to go.

I advise against ASP... it's too old. Go with ASP.Net if you get the chance, that way you can use Visual Studio Web Edition, which is freeware from Microsoft.

Here is one link to example code

http://www.w3schools.com/ado/ado_examples.asp