BE/FE Security *Important*

Mar 12, 2006

i have an access application in fe/be environment. I have put the BE in a shared forlder on the network.

Now the problem is that the shared folder where the BE is stored, has full read/write access. And this folder is visible to all users on the network from their network neighbourhood or through the mapped metwork drive.

So the problems are:
1) The shared folder has read/write access, so anyone can delete the BE mdb file. <<<<< main problem >>>>>

2) As this folder is visible to even those users who do not use this softaware, anyone can see the data.


We are using winxp and win98 on our network.
What can i do to secure the BE mdb file?

View Replies


ADVERTISEMENT

2 Important Questions

Nov 13, 2005

Hello,

>> How can i get all the results if no input parameter is put in the query e.g. if i have A,B,C and need to get all results, only A, only B and only C?

>> How can i block 1 cell and only acess it if the last cell have a correct value?

Thanks in advance,
Kobee

View 3 Replies View Related

IMPORTANT - Help With Access

Jan 16, 2005

I was wondering if anyone could help me. I am designing a database for a bowling alley as a project and I am wanting to know if there is a way of doing a search which will bring up all lanes which are unbooked. I have got a search which brings up all lanes booked in ascending order but need a more detailed search. Hope someone can help and if this does not make muc sense please contact me.
Thanks!!!

View 2 Replies View Related

Hiding The Important Bits

May 9, 2005

Hi,

I've developed my little database and it works a treat... now I want other people to be able to access it input info via forms (add data), and see reports and run searchs etc... all of which is done through a central switchboard menu.

What I dont want is other users getting into the setup of it all - basically i just want to hide the background workings, relationships, queries etc so nothing can be messed up...

What can i do, and how?!

bear in mind, i still want to be able to have full access myself.

Cheers

amx

View 3 Replies View Related

Simple Yet Important PROBLEM

Jun 10, 2005

I currently have a database and I would like to add in page numbers. I tried the built in functions but they did not work and they are not exactly what I am looking for. I want my page number to look like this:
"1 out of 12 records for MICROSOFT"
So I need the counter to know how many records exist for a specific client and keep track of which one of those records are being viewed. Can anyone help?

View 1 Replies View Related

Disabling And Enabling A Button. PLEASE HELP, VERY IMPORTANT

Mar 14, 2007

Hi, I have a form called Product Details Display Form, which is for Product Details Display table. This form contains a button "Done" which saves everything into the table, or in other words, bounds the unbounded textboxes to the table. Basically, I want this button to be disabled at the begining, when the form loads, and when the user enters ALL the fields, it becomes enabled. Here is the code I have at the moment:
Private Sub Form_DataChange(ByVal Reason As Long)
If Me.Product_Brand = Null Or Me.Product_Code = Null Or Me.Product_Name = Null Or Me.List34 = Null Or Me.Price = Null Or Me.Details = Null Or Me.Discount = Null Or Me.Combo0 = Null Or Me.Combo2 = Null Then
Me.Command36.Enabled = False
Else
Me.Command36.Enabled = True
End If
End Sub

I also have Me.Command36.Enabled = False in the Form-Load. I dont really know if it has to be in Private Sub Form_DataChange or not.

Please help me ASAP

Thanx in Advance

View 4 Replies View Related

Important Notice To Vista Users!

May 28, 2007

Important notice from Micro$oft's Knowledge Base:

When you open or are using a Microsoft Office Access database on a computer that is running Windows Vista, you may encounter one or more of the following issues:
• Access appears to stop responding.
• Access responds very slowly.
• Access exits unexpectedly or crashes.

For the complete article and possible work arounds goto:

http://support.microsoft.com/?kbid=935370

View 9 Replies View Related

Text Color For Urgent Or Important Items

Jul 2, 2012

How do I set the text color in one field as Black for regular records & a different color for Special records?

View 1 Replies View Related

Need Some Important Help To Get Added/modified Rows From Access Tables.

May 23, 2007

Hi,
I have a 3rd party desktop application to manage inventory. The data will be stored in local MS Access database. I want to sync any changes (insert, update or delete) made to this database to remote MS Sql server immediately or in batches using a scheduler.

Is there any method to know the changed rows in an MS Access table after x time. I mean I want to get all the rows in an Access table that have been added or modified after a particular date and time (say "05-23-2007 10:15:00") without using a user defined date time column in that table.

If i can do the above operation, i will write queries to get the added or modified rows and update remote server in batches.

Thanks and Best Regards,
Anz

View 1 Replies View Related

Advice For Security & Question On Built In Access Security

Mar 26, 2007

I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.

Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.

I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)

View 4 Replies View Related

Add Security To A Table If Table Is Created After Initial Security Is Set Up

Oct 26, 2011

Is it possible to do this through vba. If security is setup for all the tables and a user goes in and creates a new table, can that table have security applied to it using code?

So maybe the creator of the table has read/write privileges but everyone else only has read only.

View 3 Replies View Related

Help Me About SECURITY???

Jul 1, 2005

:confused: I can't access my database. I used many tools to scan my database password, and I had many results but I can't used any one.
This's my database. Can you help me?

View 1 Replies View Related

Security

Aug 28, 2005

Hi

I am experimenting in creating security of a database, and elements within.

I started by creating a user account with a password. I then made a few mistakes, so wanted to delete the mdb, and start again.

However, when I now try to create a new database, or even open a pre existing database, I am asked for the user and password created in the now-deleted mdb.

Apart from the fact that it shouldn't ask for the user name and pasword created in the first database, I am sure it doesn't accept the password I intered in creating the account.

The easy solution would be to delete the file where Access stores user accounts. Where is it, and is it protected, such that I can't delete it? And even if the user name and password still exists somewhere, it should only apply to the database in which it was created, shouldn't it?

Thanks
Robert

View 2 Replies View Related

DB Security

Nov 10, 2005

Hi all,

Just looking for a little advice on data protection. I have a split database which is accessed from the front end (forms only). All data is stored on the back end, which is hidden away from the user.

The database is password protected, and both sides use a login authentication to avoid unwanted access. However, the usernames and passwords are easily retrievable by opening the database a text document.

Any ideas on how to make this more secure?

Cheers

sys

View 1 Replies View Related

Security

Dec 3, 2005

I try to play Security.

After I created it, the shortcut is created on the screen.
Everytime needs to click the shortcut to login it.

But, when I go to database file, and then click it, it does not work, it will show the following message:

You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)
You do not have the necessary permissions for the specified object. To change your permission assignments, see your system administrator or the object's creator.

So, is it ony the shortcut to login it?
if delete the shortcut uncarefully, how to do it??

Thanks.

View 2 Replies View Related

Security

Dec 7, 2005

Hi,

Problem 1:
I setup a security, stored the security file and other files in the drive D:

it works.

after I move the files to the drive C:, then it doesn't work.

Why it doesn't work?

Problem 2:
After I created security, there are acc.mdb, acc.bak, and Secured files, right.
how can I add this link:
"C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" "D:acc.mdb" /WRKGRP "D:Secured.mdw" in the target to the acc.mdb file.

Because when it doesn't work, and then I created a shortcut of the acc.mdb file, then add the above code. Then it works, it give out the prompt.

Does any method instead of this, better than this?

Please let me know, thanks.

View 1 Replies View Related

Security

Dec 14, 2005

Hi
When using security login, can we logout and then login to the database without shutting down the database and re-opening.

Such as using a button to logout and then another to login.


Dave

View 2 Replies View Related

Security

Jan 17, 2006

Can some one help me?

I am trying to set up a database in which the the table portion is password protected but the query section can be manipulated or updated as users see fit. Does anyone know how to do this?

Thanks, S

View 1 Replies View Related

Security

May 5, 2006

Hi,

I have now finished my system that will run on a windows network. I now need to get the security setup so different users can access different pages.

I have set a list of users and specified what forms/tables they can access. The problem is, how does access know who is accessing the pages? For example, i have set 2 users - Dave G & Dave S - I have given Dave G access to the admin forms as he is the admin and I have given Dave S access to the general data input forms.

How is this enforced? How does access know which person is opening the forms. Unless access asks the user to login using their user name set in access, I cannot see how it can manage what users can do what.


Thanks

View 3 Replies View Related

Security HELP!!!!!

Jul 18, 2006

I have locked down my welding data base and had some problems arise mabe someone eles has had this problem. All of the tables in other data base that are linked to the welding data base now will not allow me to utilize them I get the error message that I do not have rights too that information. Even though I have full access rights to the welding data base and can make changes at will.

Why can't I do any thing to the others? HELP!!!!!

View 5 Replies View Related

WID Security

Aug 18, 2006

First of all, i am pretty new to this....

We have a few access databases in a network. More and more people in our organization are using the databases so I am learning to create some user-level security.

We have access 2000.

Access links to a WIF to create user-level security.

But I think there is an easy way that anyone can get pass that.

Even if I have set all the groups and users privileges and restrictions, anyone can simply switch from one WIF to another WIF, then they would have changed all their privileges and restrictions.

Am I understanding this correctly?

If so, what can I do better secure the database.

Another question:
How can I prevent someone from simply copy/delete the access file from windows? I am afraid that someone, maybe a disgruntled employee or even myself making stupid mistakes, delete the whole access .mdb file, and I would loss everything.

I do backup the file, but even if I back it up every night, if something like this happens, i would have lost a whole day of work.

Your advice are highly appreciated.

Thank you all for your help.

View 1 Replies View Related

Security

Aug 22, 2006

Hi,

I followed the security wizard and everything worked fine. However, when I move the database to another computer or another folder, it prints this message:

'You don't have the necessary permission to use (path)...'

Is there anyway to avoid this please?

Thanks,
B

View 14 Replies View Related

Security

Nov 22, 2006

Access security is really very confusing, thought I had conquered it but I was wrong. I have been playing with a test DB. How on earth do you reset a password for a user? I just can't see where you go to assign a new password.
Managed to clear the password but then got stuck.
Cheers
RussG

View 2 Replies View Related

Asking For Security

Dec 12, 2006

Hi,

I have a question for user-level security and workgroup.

Suppose we setup user-level security and have a workgroup with storing all username, password, and groups,
if adminstrator want to change one user permission, let's say that change the user permission from update to read permission only, then the user should only have read permission, right. However, previously, the user copied the workgroup file himself before adminstrator change his permission, if he apply to his copied workgroup file, and log in the database, he can still have update permission.

So, how do I prevent the user using his copied workgroup file for the database?

How can I solve it?

Thanks.

View 4 Replies View Related

Security

Jul 22, 2007

Hi again

The security on my database so far is justthe standard everyone has a user name and a password, no one can alter the design of a form apart from me

I am just wondering if there is any way that I can prevent people viewing and altering tables, queries etc. It would be good if when the open the database the main form comes up so they can navigate from that and they are always taken back to this and they can never see the database window

Does this have anything to do with front end and back end databases?

Sorry its a bit vauge but hopefully you will know what I mean

thanks

View 5 Replies View Related

Security DB

Jul 25, 2007

I want to maintain my database work log i.e., who ever opens the database (not through application) and changing the table should be saved in work log. Any way to acheive this?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved