[kateramsey]

Hi There -

I need data from one of my web forms to go to a file. Ideally, it would go into an access database, but unless i'm wrong, i have to give everyone in the world read/write access to the database in order to do that, and since the form is collecting customer's personal information, that doesn't seem like a good idea.

so what do i do? write it to a text file and import it to the database later? And if so, how do i write it to the text file?

this is in ASP. I currently have it set up to write to a database, but get a VBScript error about permissions when I test it.

Thanks

[TwoD]

You won't need to give everyone access, only a single user. You use the credentials of that user in your script to access the database. Since your webserver is set to not hand out the source code of ASP pages, nobody should be able to see those credentials.

I'll move this to the ASP section for you.

[kateramsey]

oh of course. that makes sense.

[webdevelopmenthouse]

vbscript error means when inserting the data on database.. it means, the write permission have not been set to the directory where your access database is exist.. give that directory write permissions, and you shouldn't have any more errors..