ASP&Access

[Robert]

Does anyone know of any good tutorials showing how to link an asp website with an access datebase? Say I want a section of my site to allow users to input their system specifications etc.

[Davey_Pitch]

http://www.w3schools.com should have something on it, they've got tons of web development stuff on there :)

[Garp]

with an access database? *shudder* Something evil that way comes :D
SQL server or MySQL would be much better and far less resource intensive.

[Robert]

This is our uni for you :)

The course notes are years old and the guy teaching it has no idea what he's doing.

[Mark]

with an access database? *shudder* Something evil that way comes :D
SQL server or MySQL would be much better and far less resource intensive.
I could say the same about ASP as well. :)

Access isn't that bad, providing you don't want more than one user to 'hit' it at a time, which of course rules out most web apps from the get-go. :)

[Garp]

I could say the same about ASP as well. :)

Access isn't that bad, providing you don't want more than one user to 'hit' it at a time, which of course rules out most web apps from the get-go. :)

We've been far out stepping our boundaries for managed servers and trying to help one customer sort out their mess of a setup. Not quite sure what the company is / does, but they're offering web space hosted from their own server, and an in house developer. Shame the developer was a web designer rather than a coder, and also they didn't think of having a hardware firewall and/or a sysadmin guy of some description. Their server got hacked, we went through great pains to fix it, then the developer displayed great ingenuity by changing the permissions to all the web folders on the server, screwing up Plesk in the process (yup, that was Plesk on a windows server...)
The developer has now left and they're stuck with a customers site that keeps breaking because it relies on ASP and an Access DB. Great for doing "select" type queries, but as soon as anyone does anything that updates or inserts data into the db things start going weird. We even asked one of our windows sysarchs to have a look at it, he took one look at the code and balked, then refused to work on it pointing out that from initial looks it would take a day or two of work to unscramble and fix and he has enough on his plate of normal work without doing that for a customer!

I feel sorry for them to some extent, but I find I don't have huge amounts of sympathy for a company that chooses to run its own web hosting solutions and not have the skills to be able to support it.

[Mark]

Me neither - cardinal sin that, as far as I'm concerned. If you offer support, you'd better have the infrastructure to provide it.

I've done a fair bit of access programming in my time, and pretty much learned what works and what doesn't. None of it, I should add, was in ASP.