Hi,
I have an Access database that I have to create text files, fixed length field width, from a table - actually 3 text files from 3 tables. There's a module that does all 3 for me and puts them in the right place.
How can I call that module from an asp page and generate 3 text files.
This gives me the error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement line 17
Dim db As Database
-------^
Dim db As Database
Set db = OpenDatabase("\\iisserver\database\employee.mdb")
db.Execute ("createTextFiles")
I also tried the following but it gives me this error:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
set access = server.createobject("Access.Application")
access.opencurrentdatabase "\\iisserver\database\employee.mdb"
access.docmd.runmacro "createTextFiles"
access.quit
Anybody have any ideas?
Jess