ASP&Access

Robert · 19-04-2007, 18:35

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 · 19-04-2007, 18:49

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

Garp · 19-04-2007, 19:24

with an access database? *shudder* Something evil that way comes

SQL server or MySQL would be much better and far less resource intensive.

Mark · 19-04-2007, 21:07

Quote:

Originally Posted by Garp

with an access database? *shudder* Something evil that way comes

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 · 19-04-2007, 21:58

Quote:

Originally Posted by Mark

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.

Robert · 19-04-2007, 19:27

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 · 19-04-2007, 22:04

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.

19-04-2007, 18:35	#1
Robert Chump!!! Join Date: Jul 2006 Location: North West Posts: 993	ASP&Access 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.

19-04-2007, 18:49	#2
Davey_Pitch I iz speshul Join Date: Jun 2006 Location: Liverpool Posts: 6,296	http://www.w3schools.com should have something on it, they've got tons of web development stuff on there __________________ Our deepest fear is not that we are inadequate. Our deepest fear is that we are powerful beyond measure. It is our light, not our darkness, that most frightens us. Your playing small does not serve the world. There is nothing enlightened about shrinking so that other people won't feel insecure around you. We are all meant to shine as children do. It's not just in some of us; it is in everyone. And as we let our own lights shine, we unconsciously give other people permission to do the same. As we are liberated from our own fear, our presence automatically liberates others.

19-04-2007, 19:24	#3
Garp Preparing more tumbleweed Join Date: Jun 2006 Location: Hawaii Posts: 6,038	with an access database? shudder Something evil that way comes SQL server or MySQL would be much better and far less resource intensive. __________________ Mal: Define "interesting"? Wash: "Oh, God, oh, God, we're all gonna die"?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

19-04-2007, 19:27	#6
Robert Chump!!! Join Date: Jul 2006 Location: North West Posts: 993	This is our uni for you The course notes are years old and the guy teaching it has no idea what he's doing.

19-04-2007, 22:04	#7
Mark Screaming Orgasm Join Date: Jul 2006 Location: Newbury Posts: 15,194	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.