Creating dynamic web page from Access form

[Jan]

I'm totally new to posting Access information on a web page so pardon my
ignorance. I have created a database for suppliers information, such as
rebates, special pricing etc. I have also created the accompanying form.

What I would like to do is post a dynamic form so when suppliers go to a
website they can....
Enter their company code
Verify this information with a password (so they cannot view information
from other suppliers)
This will pull up the information we currently have for 2008
Then they will be able to modify this information for 2009 on the form
It will automatically get stored in my database.

Because they are suppliers they don't have access to our server, so this has
to be done via the web. First, can this be done? Security would need to be
added on the record level I would think. Second, Where can I go to find
instructions on how to do this? I do have Frontpage.

Thanks for any direction you can give me.

 

[Arvin Meyer [MVP]]

If you don't want them to have an account on your server, you would need to
create an ASP page, or use other web code (ASP.NET, PHP, ColdFusion) to
access your database.

 

[Jan]

Thanks. What's the best resource to use so I can learn how to do this
quickly? I don't know where to start.
--
Thanks!
Jan

If you don't want them to have an account on your server, you would need to
create an ASP page, or use other web code (ASP.NET, PHP, ColdFusion) to
access your database.

 

[Albert D. Kallal]

I'm totally new to posting Access information on a web page so pardon my
ignorance. I have created a database for suppliers information, such as
rebates, special pricing etc. I have also created the accompanying form.

MS access in of itself is not a tool that has any relationship to web based
interfaces at all. In other words you can build an application in MS access,
or in some other programming language of your choice (say perhaps visual
basic), but unless that system has any interfaces or is designed to be used
with the Internet, then you're using the wrong tool. in this case MS access
is the incorrect tool to use, and has no relationship to the web.

I can not develop web applications with excel, and I can not develop web
applications with MS access. It is simply the wrong tool to try and develop
a web system with.

As mentioned you'll have to choose some particular web development tools,
and choose a set of tools that your web provider allows you to use. note
that liked just like these different operating systems for the desktop
(apple, windows, Linux etc...), there is also different operating systems
for web providers, and either you adopt a set of tools and THEN choose the
web provider that allows you to use those tools, or you pick a web provider
and then find out what tools they support and learn those tools. So the
decisions as to what platform you using is really up to you, likely in your
case you should probably choose a provider that supports asp.net if you're
used to using Microsoft tools.

Unfortunately you're in the wrong newsgroup and using the wrong technology
to develop anything related to the web. MS access can help you at all in
this quest for the web part.

 

[Norman Yuan]

You need to understand what web application is and which technology you are
to use to develop. At very first, you need to decide if you can afford to
host the web site yourself (it very likely no). If you host it somewhere
else, you need then decide what technology you use for your web application
or web site. It could be developed with different langauge/platform. In all
cases, anything you have done in your MS Access application is useless,
except for the tables that may still be possible to be used (but definitely
strongly not recommanded).

So, if you really want to make your data online with the Internet, you need
to find someone who knows web technology well for help and be prepared drop
the MS Access completely.

Thanks. What's the best resource to use so I can learn how to do this
quickly? I don't know where to start.

 

[Arvin Meyer [MVP]]

I don't think it will be quick, and it also depends upon the technology you
choose. Here's a few:

http://www.asptutorial.info/
http://www.aspfaq.com/
http://www.4guysfromrolla.com/

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thanks. What's the best resource to use so I can learn how to do this
quickly? I don't know where to start.

 

[Dominic Vella]

I have been doing this for many years and tried many tricks, including using
'Inet' controls which can be found when you click on the elipses '...' found
on the toolbox bar. By far though, the best advise is to use the inbuilt
operating system command 'ftp.exe'. The trick is though that you need to
build a script text file too to make it work.

I'd recommend you build an .ASP internet website, however if you're
hardcore, make MS-Access build on standard HTML websites then you can check
out the code fragment (not complete) to give you a head start.

strReplyFile = "C:\response.log"
If Dir(strReplyFile) <> "" Then
Kill strReplyFile
End If

intFileNumber = FreeFile
Open strReplyFile For Output As intFileNumber
Print #intFileNumber, "open " & strFTPAddess
Print #intFileNumber, strUsername
Print #intFileNumber, strPassword
Print #intFileNumber, "cd " & strFTPFolder
Print #intFileNumber, "binary"
Print #intFileNumber, "lcd """ & strLocalFolder & """"
Print #intFileNumber, "get " & strLocalFilename & " " & strFTPFilename
Print #intFileNumber, "bye"
Close #intFileNumber

strCommand = Environ$("COMSPEC")
strCommand = Left$(strCommand, Len(strCommand) - Len(Dir(strCommand)))
strCommand = strCommand & "ftp.exe -s:""" & strReplyFile & """"

ShellWait strCommand, vbHide

If you are still interested in the 'ftp.exe' idea, then replay back and I'll
try to help you with more information.

With ASP, well type 'ASP Tutorial' in Google.

Dom

 

[Dominic Vella]

Actually, I love using MS-Access to build my websites, particularly because
I can get away with not having to pay big prices for business sites when I
can simply use HTML only. Of course, there is a limit to it's capacity.

I create template information and then use Access data to fill in the gaps,
and then simply send the completed pages with links up to the net.

I've done this for sporting facilities, dog breeders, churches, etc. Of
course, it's tricky, but I love it. And the users are happy too because
they don't have to learn how to work new software, they use a user friendly
customised interface.

I think MS-Access is a great tool to use, albeit it takes some development
work. MS-Access is readily available (free runtime versions available) and
works great on cheap HTML based websites.


Dom