How to upload a database onto the intranet?

MilkPudding · June 14th, 2004, 03:38 PM

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~~~

bmains · June 14th, 2004, 07:24 PM

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

MilkPudding · June 15th, 2004, 07:46 AM

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....

bmains · June 15th, 2004, 10:46 AM

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

MilkPudding · June 15th, 2004, 01:14 PM

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~~~ ^_^

bmains · June 15th, 2004, 01:42 PM

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

MilkPudding · June 15th, 2004, 02:40 PM

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

programming is tough...argh~~

but i really appreciate ur help... ^^

bmains · June 16th, 2004, 11:48 AM

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

MilkPudding · June 16th, 2004, 03:17 PM

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.. : )