Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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~~~
Reply With Quote
  #2 (permalink)  
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
Reply With Quote
  #3 (permalink)  
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....

Reply With Quote
  #4 (permalink)  
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
Reply With Quote
  #5 (permalink)  
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~~~ ^_^



Reply With Quote
  #6 (permalink)  
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
Reply With Quote
  #7 (permalink)  
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... ^^

Reply With Quote
  #8 (permalink)  
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
Reply With Quote
  #9 (permalink)  
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.. : )

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 08:54 AM.


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