|
Home > Archive > MS Access Multiuser > August 2005 > Make copy of database onto a web page for employees to sign in on
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Make copy of database onto a web page for employees to sign in on
|
|
| ILoveAccess via AccessMonster.com 2005-08-11, 8:25 pm |
| Hello,
I work with sales leads and use Access 97. I have salesman that work from
the road. I need them each to be able to view ONLY his records in forms and
reports and then make changes to their records and let me view the changes-
basically have live data.
Would this idea work?
1.) Create a main database with the main form that I enter leads in, and a
query, form, and report for each salesman.
2.) Create a seperate database for each salesman linking to their queries,
forms, and reports from my database.
3.) Set a different password for each database.
4.) Create a webpage with each of their names on it that are linked to each
of their databases.
Would I get live data? Would this be secure enough? Would this cause any
function problems? Any suggestions?
Thanks!
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...tiuser/200508/1
| |
| Alex Dybenko 2005-08-12, 3:24 am |
| Hi,
i think you can just build a web application, so after user login - it will
show only his records. But i think you have to build this on ASP or ASP.net,
using same database with tables
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
"ILoveAccess via webservertalk.com" <forum@webservertalk.com> wrote in
message news:52B2D299C9F38@w
ebservertalk.com...
> Hello,
>
> I work with sales leads and use Access 97. I have salesman that work from
> the road. I need them each to be able to view ONLY his records in forms
> and
> reports and then make changes to their records and let me view the
> changes-
> basically have live data.
>
> Would this idea work?
> 1.) Create a main database with the main form that I enter leads in, and a
> query, form, and report for each salesman.
> 2.) Create a seperate database for each salesman linking to their queries,
> forms, and reports from my database.
> 3.) Set a different password for each database.
> 4.) Create a webpage with each of their names on it that are linked to
> each
> of their databases.
>
> Would I get live data? Would this be secure enough? Would this cause any
> function problems? Any suggestions?
>
> Thanks!
>
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...tiuser/200508/1
| |
| ILoveAccess via AccessMonster.com 2005-08-12, 1:25 pm |
| Thank you for replying so quickly! I am a novice and have no idea what ASP
is or what a web app is.
Alex Dybenko wrote:[color=darkred
]
>Hi,
>i think you can just build a web application, so after user login - it will
>show only his records. But i think you have to build this on ASP or ASP.net,
>using same database with tables
>
>[quoted text clipped - 19 lines]
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...tiuser/200508/1
| |
| Alex Dybenko 2005-08-13, 7:24 am |
| This is a technology which allows to build a web pages similar way you build
access forms. You can find a lot of info at www.microsoft.com
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
"ILoveAccess via webservertalk.com" <forum@webservertalk.com> wrote in
message news:52BE3B6372444@w
ebservertalk.com...
> Thank you for replying so quickly! I am a novice and have no idea what
> ASP
> is or what a web app is.
>
> Alex Dybenko wrote:
>
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...tiuser/200508/1
|
|
|
|
|