Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
| Search | Today's Posts | Mark Forums Read
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 14th, 2004, 03:38 PM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to upload a database onto the intranet?

I have created a database using access and now i want to upload it onto the local intranet. The pages exported from access is in .htm format. Therefore it cannot be uploaded directly onto the intranet to build a user interactive database. Should i convert the pages to .asp file? If so, what program should i use to do so (dreamweaver?)
thx a lot~~~
 
Old June 14th, 2004, 07:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

If you are talking a program to use the Access database, you need a server-based language. ASP can be used, and I believe Dreamweaver does support it. You can also use interdev, as well as a few others (even notepad).

I'm not quite sure if this is what you are asking?

Brian
 
Old June 15th, 2004, 07:46 AM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes~~~ I wanted to write a program(page) that allows the user to fillout the forms online and submit the data to our database. Unfortunately i don't know much about any server-based language, so time to learn~~~
thx a lot....

 
Old June 15th, 2004, 10:46 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

If you are getting into server-based languages, and are choosing Microsoft products, you may want to advance to ASP.NET, if you have the capabilities. This is where they are heading with their products, and at some point, ASP/VB will no longer be supported.

Brian
 
Old June 15th, 2004, 01:14 PM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i don't think i have the time to get into any high tech stuff...i kinda taught myself asp codes this morning and wrote a page with forms...so far everything works ok...except one essential problem:

How do i link the data submitted by the user with access?

thx a lot~~~ ^_^



 
Old June 15th, 2004, 01:42 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

You can access a user ID (if an intranet application) via Request.ServerVariables("AUTH_USER") (something like that, you can find ServerVariables resources on the web). Then use an autonumber, and relate the two via a relationship.

Then display the results by querying the records for a user and base the records on the autonumber ID.

Brian
 
Old June 15th, 2004, 02:40 PM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

wow~~~ thx~~
sorry i'm just an annoying newbie

programming is tough...argh~~

but i really appreciate ur help... ^^

 
Old June 16th, 2004, 11:48 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

It's tough to get used to, but after a while, it starts to get easier. Just keep the application as simple as possible, and don't be afraid to post your questions on this site. Plenty of people to guide you in the right direction.

Brian
 
Old June 16th, 2004, 03:17 PM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thx a lot!!! actually i figured it out already.. : P
in one day~~ i wrote 4 pages of codes already cuz my database is pretty big..14mb...with hundreds of field names.. ^_^ i must be a genius...lol....just kidding...
thx a lot for ur help...i would like to help other ppl too..but i don't know much about programming....hope i'll get better.. : )





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Upload Database akumarp2p C# 2005 2 February 11th, 2007 10:46 AM
How to Upload Access DB to the intranet J.K.W.Y. Access 6 March 29th, 2006 01:49 AM
Upload to Access database malachany ASP.NET 1.x and 2.0 Application Design 1 January 10th, 2005 10:29 AM
Upload image to database or not to database? thachnn SQL Server ASP 0 October 11th, 2004 03:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.