473,326 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Back-End database password

Alireza355
Dear all,

I have a database, splitted into front-end and back-end versions.

I want to set a password for the back-end database, but when I do so, the front-end users can not have access to information in the tables of the back-end one.

Any idea?
Mar 29 '09 #1
5 1902
NeoPa
32,556 Expert Mod 16PB
This is not true Ali.

If you set a password to the BE db, the FE can connect just fine as long as you give the password in your development version of it when setting up the connection.

I use this on the rare occasions when I give out FE dbs to untrusted users. It works fine.
Apr 4 '09 #2
Dear NeoPa,

Thank you so much for your kind support.

Here is the senario:

There are some forms and tables in the back-end database, that only one user must have access to. There are also some other tables in that database, which only the front-end users need to have access to with the forms that are only in the front-end users' database.

In fact, I have divided my office into two different sections by doing this. The accountant uses the back-end db and enters data in the tables using his own forms.

The sales personel enter sales information in the tables (that are in fact in the back-end db) using some forms that are placed only in the front-end db.

Now, I want to have a password for the back-end db, so that nobody else except the accountant can open the back-end db. But the front-end users should freely do whatever they want in their own environment.

If I set a database password for the back-end db, the subforms in the front-end are empty!!!!!!
Apr 5 '09 #3
NeoPa
32,556 Expert Mod 16PB
Try this :
  1. In case there is any misunderstanding here of the process, I suggest you make a good backup of all your databases before commencing this.
  2. Add the password to the BE db.
  3. Delete and re-add all the linked tables from the FE db (passing the new password).
  4. Release the new version of the FE db.
Apr 5 '09 #4
WOW!

IT WORKS!!!!!!!!!!!!!!!!!!!!!!

Thank you soooooooooooooooooooooooo much
Apr 6 '09 #5
NeoPa
32,556 Expert Mod 16PB
You sound surprised Ali ;)

You're welcome of course :)
Apr 6 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Ralph Freshour | last post by:
Is it possible to inhibit the browser Back/Fwd buttons via PHP? Thanks...
11
by: TTroy | last post by:
Hello C programmers, Can someone tell me why ungetc can't sent back EOF, but it's sister function getc has no trouble sending it to us? For a file, this might not make a difference, but for an...
1
by: Peter D. Dunlap | last post by:
Hello, I realize that this may not be the best place to ask this question, through the application is asp.net. I also realize that questions about disabling the back button are generally met...
4
by: Hypo | last post by:
I added a 'Back' button to my page, and wrote 'OnClick' code something like this: Response.Write("<script>history.go(-" + iDepthIndex.ToString() + ");</script>"); But, it dosnt work! Effect...
6
by: Mark | last post by:
I have two dropdown lists. Both have autopostback set to true. In both dropdowns, when you select an item from the list, it redirects to the Value property of the dropdown. Nothing fancy. ...
29
by: Tom wilson | last post by:
I can't believe this is such an impossibility... I have an asp.net page. It accepts data through on form fields and includes a submit button. The page loads up and you fill out some stuff. ...
5
by: Tom wilson | last post by:
I'm developing an application that is a benefits enrolment website. The benefits can be of any type in any order as stored in a SQL server. On each page is a Back and Next button. At a certain...
7
by: Sridhar | last post by:
Hi, I have a question regarding the Page_Load method and Back Button of Internet explorer. I have created a webform. In that webform I have several Text Boxes. Also I have two buttons. When I...
4
by: bendlam | last post by:
I have a page that contains search criteria and when you click on the search button it causes a post back that populates a dataview on the same page. One of the gridview columns contains a link...
22
by: Rickster66 | last post by:
As Instructed this is a new thread regarding my original post: "Select Only 10 Columns Going Back" I'm sorry for the late response. I've been gathering up information and carefully with as much...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.