Macros in Access through ASP

[NikkP]

Hi I am trying yo run an Access macro through ASP. Does anyone now how to do this or where this code might be wrong, this is some VB code which i found on an article in the MSDN site...any help would be great..trying to do a final year project and am bit stuck here!

Dim oAccess
Set oAccess = CreateObject("Access.Application&quot
oAccess.Visible = True
oAccess.OpenCurrentDatabase "C:\MyDocuments\Project\wbspdb.mdb"
oAccess.run "GetStudents"

 

[SHARKY99]

First ASP is a server side script so you won't(to my knowledge) be able to open an Access database on your computer.

Again i might be wrong but i always used it with servers.

A guess!!! try VbScript or JavaScript???? Have Fun...

Sharky99 >:O>