Hi,
I have experience in setting up a site using Access and ASP (VBScript) for manipulating data. However, I am now embarking on an endeavor to create a paid membership site.
This is just a shot in the dark to see if anyone is willing to point me in the right direction. Does anyone know of any good resources for, perhaps, templates and code for such a project.
Any input would be immensely appreciated!
-steve

Have a look around at www.hotscripts.com
I'm sure that you will find one or more scripts that will suit your needs. You may possibly have to adjust them a bit.

Perhaps this may hopefully give you some ideas and it's got a downloadable sample:

Classic ASP Design Tips - ASP Web Database Sample
http://www.bullschmidt.com/devtip-webdb.asp

A sample Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.

One can login and add/edit/view fictional customers and invoices...

Steve.

your membership site.

several questions for you.
is it going to be a one time fee membership ?
are you going to be charging a monthly fee ?
are you going to be doing re occurring billing every month, quarter, yearly ?
how are you going to handle billing and collecting the money ?
how are you going to handle upgrades, suspensions, terminations etc ?

obviously if your already familiar with ASP and accessing databases, then you don't need more templates and design tips, what you need is a way to process your accounts. I am sure you can handle the rest.

As a web hosting company, these above are exactly what we do so I would suggest to look into how web hosting companies handle all of the above. While this site is mostly for support type issues, you can read some of how we handle some of these at :
http://forums.webhostautomation.com/

Another consideration is with something like what you are trying to do, even though you probably have the programming skills necessary, don't try to re-invent the wheel, Its not cost effective. there is a program that a lot of web hosting companies use to process their monthly payments, reoccurring billing, refunds, invoicing, customer signup, and a number of other things. the program is fairly cheap too and it will interface with PayPal to process your transactions. the program is ModernBill,

http://www.ModernBill.com

and for $180 it will handle up to 250 accounts. Several of my friends use modern bill for their webhosting companies and it is pretty good. If your time is worth just $10 per hour, you would break even if you spent 18 hours on trying to make the entire signup and billing system. And I guarantee you that you will be more into like 400 hours trying to make all of the system on your own.

ModernBill uses a database back end that you can probably interface with to do customized things with it too.

Also, if you interested in just some type of "sign up" process, check out my site and the "new accounts" section. I wrote the entire thing. Its all VB script and a MS-SQL database on the back end. If your interested I can give you a copy of it. but still, I use a 3rd party program that I integrate to, to handle all of the billing and processing. So while you can go through the first 3 screens of signup pages on my site, the final step of payment and account creations is handled by the 3rd party product.

Let me know if you have any questions, I will be glad to help.

PS, I have been doing programming for 24 years.

OH..
I almost forgot.

If your making a paid membership site, then you will likely need to handle tech support issues, billing issues, FAQ's, knowledge base issues,
etc.... etc.... etc....

take a look at the support section of my site.
http://www.getmysiteonline.com/Support/

And also at the support system that many of my friends use. http://www.kayako.com/

and Kayoko will interface directly to modern Bill so your users have a single username and password to access everything