Input Data Through Form on Corporate Intranet?

[ryguy7272]

Is there a way to show a Form on a corporate intranet, and allow a user to
input information into a Table in an Access DB. I was thinking of creating a
tool, like an HTML browser, that allows a user to input some information into
one of my tables. If so, how can I establish a connection between the Form
and the Table? Is there some documentation on the web that describes how to
do this?

Regards,
Ryan---

 

[Justo Morales]

Is there a way to show a Form on a corporate intranet, and allow a user to
input information into a Table in an Access DB. I was thinking of creating a
tool, like an HTML browser, that allows a user to input some information into
one of my tables. If so, how can I establish a connection between the Form
and the Table? Is there some documentation on the web that describes how to
do this?

Regards,
Ryan---

Not sure if this helps, but you can start here:
http://www.asp101.com/samples/database.asp. This show you how to
connect web pages to an access database. It is a good start, but you'll
need to learn how to write the data back to the access database. You
may want to peruse through the website as you'll find lots of useful
information.

--)) Justo ((--

 

[Beetle]

It would depend on a few factors that aren't specified in your post.

Is the network LAN or WAN?

Do all potential users have MS Access on their computers?

What version of Access do you/the users have?

You can find some info on the subject at Albert Kallal's page;

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[ryguy7272]

I am using Access 2003. I was hoping to somehow just copy/paste a Form to a
file in a public drive and map this to Access. I would ask users to input a
value on this Form, on the public drive, capture the value and simply
transfer that value to a table in Access. I guess this would be some kind
of a client-server setup...if it works. Not sure if it can be done. If so,
please advise me on the setup.

Thanks so much!!
Ryan---

 

[Beetle]

Well, you still haven't specified, but *if* the following things are true;

1) All potential users are connected through a high speed LAN

2) All potential users have Access on their local workstation

Then you can split your app into a front end (with the Forms/Queries/Reports)
and back end (with the Tables/Relationships). Put the back end in a file on
the network. All users need to have read/write/delete privileges on this file.
Each user then needs to have their own copy of the front end. Do not put
the front end in a network file and have multiple users share it. You are
asking
for corruption if you do that. The FE you give the users can be a simple
one form FE, linked to a table in the BE, if that's all you need.

Again, this is only if the above conditions are true. If not, see the link to
Alberts article from my first reply for information on alternatives.

 

[Nicholas Meyer]

nice Ryan

 

[John W. Vinson]

I was hoping to somehow just copy/paste a Form to a
file in a public drive and map this to Access.

That is NOT an option as written. Forms have no existance outside an Access
database. Follow Beetle's suggestions...

 

[ryguy7272]

Well, actually, not everyone will have Access installed. I was trying to set
up a simple method of getting some data, input through a Form, and then
warehousing it in the Access DB. If everyone needs to have Access installed,
then I guess this concept is not feasible. Everyone does have Excel
installed though. I’m decent with Excel and VBA in Excel, and I suppose I
can set up an Excel Form to be the input device and collect the data, right.
Can I set up a front-end in Excel and use Access as my back-end? Can someone
confirm this?

Regards,
Ryan---

 

[ryguy7272]

I ended up using Excel because everyone here has it installed. I think we
are just going to email the files for now. Thanks to everyone who looked at
this.

Ryan---

--
RyGuy

Well, actually, not everyone will have Access installed. I was trying to set
up a simple method of getting some data, input through a Form, and then
warehousing it in the Access DB. If everyone needs to have Access installed,
then I guess this concept is not feasible. Everyone does have Excel
installed though. I’m decent with Excel and VBA in Excel, and I suppose I
can set up an Excel Form to be the input device and collect the data, right.
Can I set up a front-end in Excel and use Access as my back-end? Can someone
confirm this?

Regards,
Ryan---