Frank Rocco
|
| Posted: 05/09/2002, 7:42 AM |
|
Hello,
I want to be able to create multi web applications using only one contact
file.
The contacts can be employees, students, vendors...
This is turning out to be a real bear in CC2.
I have designed the following in MS Access database.
Database 1 (Security)
A. Master Contacts table.
B. Login Table
C. Application Table
D. Application allowed table
E. Contact Type table, Student, Employee...
A points to E for each type
C. contains all applications developed with their URL path.
D points to C for all contacts allowed in A
B points to D and A for a single login.
For each application I develop:
1. Create a database.
2. Create application required tables.
3. Add links to Database 1 (Security), to allow application to get desired
data as needed, like contact name.
Goal:
Because of cost and other factors, I want to migrate this to MySQL.
The whole purpose of this design was to prevent the duplication of contact
data for each application and allow a single signon.
Questions:
1. Am I doing this the hard way? Is there a better way to achieve the Goal?
2. I am interested on how others approach this problem.
Thanks so much for the feedback I hope I made this clear.
Frank Rocco
St. Elizabeth Medical Center
|
|
|
 |
Barry G. Sumpter
|
| Posted: 05/09/2002, 2:31 PM |
|
Hi Frank,
An excellent start.
Although I didn't like puzzling together the x points to y scenario.
1. Create a security database. ==> Create a single security database.
Period.
2. In this single database you have the tables as you listed.
I'd call the master contacts table a Users Table
Don't mix business contacts info with Users info.
Don't mix employee info with Users info.
This is for web use security only. ie Don't need business
address etc...
3. A single applications table in this single security database.
Multiple apps for a single user.
Could even have user groups.
Just add apps recs and users recs as administrator sees fit.
The security portal
4. A single front end page 'a' which uses this security table to login
userID and Password.
5. A single front end page 'b' which either
uses this security table to diaplay the login UserID
Apps and allows the
user to select which App
or load common header with applications hyperlinks
here we have to pass around the usersIndex and the
header would have to
reload the applications hypelinks each time a new
page is loaded.
Or perhaps a left frame.???
Again this is for web security only.
If your whole premis is for contacts and employees then you can just place a
link in the
security database to another detailed employees/contacts table.
I hope this helps someone,
Barry G. Sumpter
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:abe1rv$7j9$1@news.codecharge.com...
> Hello,
>
> I want to be able to create multi web applications using only one contact
> file.
> The contacts can be employees, students, vendors...
>
> This is turning out to be a real bear in CC2.
>
> I have designed the following in MS Access database.
>
> Database 1 (Security)
> A. Master Contacts table.
> B. Login Table
> C. Application Table
> D. Application allowed table
> E. Contact Type table, Student, Employee...
>
> A points to E for each type
> C. contains all applications developed with their URL path.
> D points to C for all contacts allowed in A
> B points to D and A for a single login.
>
> For each application I develop:
> 1. Create a database.
> 2. Create application required tables.
> 3. Add links to Database 1 (Security), to allow application to get desired
> data as needed, like contact name.
>
> Goal:
> Because of cost and other factors, I want to migrate this to MySQL.
> The whole purpose of this design was to prevent the duplication of contact
> data for each application and allow a single signon.
>
> Questions:
> 1. Am I doing this the hard way? Is there a better way to achieve the
Goal?
> 2. I am interested on how others approach this problem.
>
> Thanks so much for the feedback I hope I made this clear.
>
> Frank Rocco
> St. Elizabeth Medical Center
>
>
|
|
|
|
|
