User Level Security : Sending user name to another database

[yus2aces]

Hi,

I have a problem in my current project.

I have several databases link to one central database. I want to build a user level security by using User Name table in one database. I have built the login form and it worked in the central database, but how to transfer that user name into another database, so I can manage the access rights based on the username table.

Hoping somebody could help me solve this, or maybe giving a sample of working database where I can learn the way. Thanks in advance.

 

[G37Sam]

You can use Shell command to open another database.

I would do it all in one DB though and have add/edit/delete privileges linked the logged in user.

 

[yus2aces]

Thank you so much for the reply. I am so grateful, but still I have no clue how I can transfer the username between the databases.

I can't join the databases into 1 database, because each database consist of massive data, so I'm afraid it will reach 2GB limit in very short time.

 

[G37Sam]

Thank you so much for the reply. I am so grateful, but still I have no clue how I can transfer the username between the databases.

I can't join the databases into 1 database, because each database consist of massive data, so I'm afraid it will reach 2GB limit in very short time.

And that is why you should have a front-end / back-end environment.

The back-end database(s) store(s) all the data, the front-end is sort of like the hot receptionist that's smiling all the time. The front-end is linked to all the tables you'd need behind the scenes.

 

[yus2aces]

And that is why you should have a front-end / back-end environment.

The back-end database(s) store(s) all the data, the front-end is sort of like the hot receptionist that's smiling all the time. The front-end is linked to all the tables you'd need behind the scenes.

Thanks G37Sam, but still that is not what I am looking for. Thanks anyway.

 

[yus2aces]

I have figure out the way to do this, still in my head though. I'll try to write down the code.

After opening DB by using Shell command, the centralized DB will write down the active username in TXT file. Then the new DB will try to find out the active user name from the given TXT file.