Security Question Regarding Sharing Database
Feb 9, 2007
Hi everyone,
I am going to be implemeting security on my split database but have a question? The database will have the back end on a shared drive and I will copy the front end to the desktops of the people who will use the database. My question is such that when I use the Access security wizard it creates a shortcut on my personal PC. Can I simply create security access levels, then create the shortcut on my computer, and then copy the shortcut from my PC to every user that will use the front end? Will I just need the shortcut on the associates desktop or do I need a copy of the entire database? I will have a max of 30 users but probably no more than 5 logged on at a time. I have read and searched and couldnt find anything that actually answers that question? Thanks for all your assistance.
Scott
View Replies
ADVERTISEMENT
Mar 14, 2006
Im not sure how to go about this, so I need plenty of advise. The Database I have built is, at the moment on a number of laptops, none of which are contected to a network. If things go according to plan the DB will eventually go on to the desktops which are conected. the aspiration is that the DB will be on one main PC with all others accessing it. Problem is I have never done anyting lke that before and am unsure where to start. alny advis gratfully received. Thanks!
View 4 Replies
View Related
May 11, 2007
hello,
I am working on an ACCESS database. I saved it in my computer "A" on a "shared" folder. Now I want somebody else to be able to modify the tables when I am working on the database and when I am not in my office from a different computer "B". Both computers are on the same network. The problem is that when I try to open it from computer B it gives me a read-only message. How can I accomplish this??
Thank you
View 1 Replies
View Related
Oct 8, 2007
Am new too this forum and I dont know whether this is the place to place this post. We want to share a database with my boss. I dont want to split it yet and make an MDE because am still working on it how do i share it
Also anyone with an idea where i can get a clothing shop database sample
View 1 Replies
View Related
Dec 3, 2007
Hi
Windows XPPro SP2
Access 2002
I'm a little ... ahem ... confused?
I'm trying to share out a database using the FrontEnd (FE) BackEnd (BE) concept. I've had an unexpected result however. I've made two copies of the FE, one resides on the same machine as the BE (but in a different directory), the other FE resides on a remote machine.
I carried out an experiment whereby I updated the same record from each of the FEs but using different data (some free-text in a textbox). I was expecting to see the record displaying the data from later of the two entries... but both FEs show their own version of the record in question?
Here's how I split my Db.
1. Whilst on the PC remote to the intended network share, converted the original Db to Access2002 (from 2000 format).
2. Again, on the PC remote to the intended network share, used the Database Splitter in "Tools" where I set the target directory for the BE.mdb to be on the network share.
3. After some fiddling with "Trusted Sites" in IE's options(?), got the FE on the PC remote to the network share to finally connect (or so I thought) to the BE.mdb.
4. Placed a copy of the FE onto the PC owning the network share (but in a different directory).
5. Used the "File" / "Get External Data" / "Link Tables" to link to the BE.mdb
6. After some minor "compile" errors, the 2nd FE seemed to fire up OK.
The two FEs seem to be using their own copies of the tables?
I guess I've missed a step somewhere? can one of you kind people out there educate me please? - Any help as always greatly appreciated... Thankyou.
Regards
P.S. I've noticed that .ldb locking files appear in the same directory(ies) as the FEs... I was rather expecting the .ldb to be on the same share as the BE.mdb?
Thanks
View 2 Replies
View Related
Feb 21, 2005
Well, I am mostly done with my database design and I want to share it out on the network. As I have stated several times before, I am not a programmer, so if I explain how I have tried to do things badly, you'll know why.
1st, I tried just moving my database out to a shared file within my office. That worked, as for as them being able to see everything but any changes they made to tthe database, from their pc, didn't save to mine. So...
2nd, I created a new network drive and mapped the other persons pc to my IP address and then shared to database onto the new drive. That loaded up Access but it wouldn't open the actual database because..."this file is located outside your intranet or on an untrusted site".
After talking with my network administrator, he feels that the problem is within the security settings of Access but he is unfamiliar with Access.
Does anyone know why I am getting this message from the opening the network copy of this database?
View 10 Replies
View Related
Jun 9, 2005
I have an access database that I used to be able to share between 5 different people (we were all able to input data at the same time) Something has changed and now only one person can get in to work on it at a time. If someone else tries it tells them that it can't find the database. Has anyone seen this before and if so what's the fix. Any help would be greatly appreciated.
View 2 Replies
View Related
Feb 19, 2007
hi everyone,
i have designed a simple database which need to be accessed by 3 different people(number likely to increase) located in different towns.what do i need to do especially from a technical point of view.
Thanking you in advance.
View 5 Replies
View Related
Mar 21, 2007
Please forgive me if I have missed a post on this. I spent the last few hours searching here and the internet for some things to try.
We currently have three computers running a database. Each of them has a front-end and a back-end is located on my computer. All front-ends are linked to the back-end. The two remote computers are using 2007, my computer is still using 2000. Only recently has the OS been ungraded on the remote computers, but the networking/sharing problem was around then as well.
We are using a wireless-g connection. All computers have mapped the network drive to my back-end share. On one remote computer(#2), the password to access the mapped drive is not saved (an unrelated issue), but she could access and edit the database while I was doing the same.
On the other remote computer (#3), they can only use the database when it is not in use by me (computer #1). And when #3 has it open, it locks out everyone else. With #3 opening it first, it puts me on "read-only, not updateable" status and it puts #2 on similar or worse.
When I have the database open first, #3 cannot access the backend at all. She gets "file is in use by another user" or something to that extent.
The back-end is set to Shared, No Locks and "Open database with record level..." checked.
At this point, we would like to set it up so that ONLY I can enter/delete/edit data and all remote computers can read but not change. I have tried a number of things, including some Windows XP permission changes, but nothing seems to work.
Any help would be great. Thanks
View 3 Replies
View Related
Dec 28, 2004
i have an Access form which is in local drive of each computer on the LAN. This form has the tables linked to Excel spreadsheats which is on the LAN nw...so that all users can get the data for thier Access form from the same excel database. (every user has his/her own Access form but share one excel-database) I have made the Excel sheet to share the workbook (by tools--> share workbook) to allow changes by more than one user at the same time.
This works fine with one user at a time.
But does not allow multiusers at the sametime.. ie.. two people cannot use the form at a time...the second user who is trying to get the access form will get a message saying that the excell spread sheat is open exclusively by another user.
I know that i can copy the excell spread sheat to each computer and access it from there... but I would like to have one database in the LAN..so that i just have to update this whenever the data base needs to be changed.
Hope im not wasting ur time
soni
View 1 Replies
View Related
Nov 2, 2005
Hi,
I am sharing a database on the network. I get wierd problems when many users are trying to access the database at once. It gives and error saying "The database needs to be repaired" and when I click "yes" it says "Cannot be repaired because its locked exclusively by someone". I am sure everyone is opening the database in the normal view. Can anyone help me with this.
Thanks
Neelima.
View 3 Replies
View Related
Jun 12, 2012
At work a few of us all need to access the database to edit/update etc and at the moment only one of us can use it at once.We are getting a server in the near future so we will all be able to access it at the same time but I was wondering if there is an alternative way to do this in the meantime? I have been looking at "shared folders" but am unsure if they are suitable or how they work.
View 4 Replies
View Related
Apr 8, 2008
I have an access database which is shared, I can open it on 2 pcs at the same time no problem. I also have an html and asp page which is used to add recoreds to the database, this works fine if the database is closed everywhere else but this cannot be the case. I am now desperate for answer to any help would be greatly appreciated.
I have attached the asp file, I can upload all files and database to a server if someone requires them (too big for the forum).
Thanks,
Richard
View 2 Replies
View Related
Dec 3, 2013
What is the best solution for sharing a front end DB as me having the BE installed at my pc, giving all user the FE and then refreshing table link with BE installed at pc but the problem is that the shared FE becoming slow any option ? as only 5 users using this at a time.
View 4 Replies
View Related
Jul 30, 2012
i have made a database in access 2010 . and i have put that in a shared folder . split that into fe and be. and on my network i am using access 2010 runtime on other computer to access it . on that computer in registry settings i have trusted locations as //server/database i.e. in database folder i have the fe and be.i can open the fe but with potential security warning i.e. of trusted locations i think . and when i click open on it it doesnt open my forms those are linked with tables from navigation form and displays the error that is something concerned with location g:database which is on my server computer.
View 2 Replies
View Related
Aug 16, 2014
Imagine you have a split database with two users making reports on their own front end. Lets say user 1 wants to share a report they built with user 2. is it possible to send this Object through vba so that user 2 would received a working editable copy that they can use on their front end without sharing the actual accdb front ends?
I thought about creating a Database that would just host the reports but again if I cannot send or access secondary database objects then this method would not work.
View 3 Replies
View Related
Dec 29, 2014
In the past I have only done data input into Access databases that have already been created. They have been simple text fields only. I was hired on contract to finish data input for a database that serves to catalogue material resources. The database itself was supposed to have been completed by a former contractor but I'm discovering bits and pieces that weren't finished. I don't have any background in IT or coding.
So, this database eventually has to be shared in a "locked" format so that other entities can view our resources (like a catalogue) without changing them. My next step is to add images to each of the items being catalogued (there are about 100 images). The former contractor began a table labeled "Pictures" in which there are 2 columns: PictureID and PicturePath, the latter being a path starting with C:. The issue is, his picture paths include the hard drive name so that it looks like this:C:HardDrivePicturesPictureID.jpg
I need the database and its images to be share-able on other computers. And I need to use relative paths to connect the images to the database so I'm not tremendously increasing the size of the database.does the location/path of the database need to be changed so it can be shared, and if so how do I do that?
Second question: I have all the images I will be using in a folder on my desktop; how do I save them in a "fixed subdirectory" of the database so that they get moved with it whenever it is sent out to another user?
If I change the database name as I'm working on it (I've been saving a new database each day, so that if I screw up something I can go back to the most recent working one) will that mess up my picture paths?
View 5 Replies
View Related
Apr 27, 2012
I created an access database for the sole purpose of sharing approved data with my entire company. The end users will view the data in a Form which utilizes several tabs and also gives them the ability to run pre-set queries out of the Form. The Form was created using several queries which were built from tables off of the server.
The tables update every day, as does the information in my Form. The problem I am running into is that it takes about 2 minutes to open the DB (the DB opens directly to the form and all queries run immediately to update), which is annoying to end users and might deter them from actually using the tool. I have tried moving the DB to SharePoint, but that did not work due to the size of many of the tables.
View 2 Replies
View Related
Aug 4, 2013
I've just split a database into the front-end and back end components. But how to distribute it further.
Additionally, I need people who have the front end to access the database from their homes, not just from work.
What would I need to use?
Is there anything available for free?
View 3 Replies
View Related
Jul 13, 2005
Hello,
I have a very basic Access Database that is a contact resource for vendors. I have a Switchboard manager form when you open the database with the option to take you to a Form for the supplier contact information or to 2 different reports.
I have set up security so that I have full access and then a Data Entry user is allowed to edit, add and delete data but no make changes to design of the database. I also have just the minimum toolbars showing.
I set up the security and work group file with no problems. It works great on my computer but when I try to transport it to another computer, I get an error stating:
"You do not have the necessary permissions to use H:/File Name.mdb. Have the system administrator or whoever created this object establish the appropriate permissions for you."
How do I set up the database security and still have the database be portable and be able to be used on any computer?
Also, is there a way to restrict the toolbars for the common users and have the full toolbars for the administrator?
Thanks for your help.
Lisa M
View 7 Replies
View Related
Jul 27, 2005
Hello.
Prior to MS Access 2003 a different workgroup information file (system.mdw) could not be joined unless the user had access to run the workgroup administrator utility with the file WRKGADM.exe to create a new or join another existing workgroup information file. With the 2003 version of Access there is now a command (Tools menu then Security then workgroup administrator) to run the workgroup administrator utility within the MS Access menus. This could allow any user, once they are able to log in to MS Access, to change the workgroup information file to one that doesn’t require them to log in and has no restriction on rights for users for any database. My question is: How can I make it so users can’t run the “workgroup administrator” utility from the menu? Note: If you remove it from the menu then any user can also customize the menu to bring it back so that is not a problem solver. Any suggestions would be greatly appreciated.
View 9 Replies
View Related
Apr 19, 2006
I have an old Database which someone had created and they stopped using it. Now they would like to get the information from it. The problem is whenever I try to open it, it says
'You do not have the necessary permission to use the c:SGSS Database.mdb object. Have your system administartor or the person who created this object establis hthe approprirate permissions for you'
I have the secure.mdw file. when I open it all it has is a few queries with the usernames and the groups.
Is there anyway I am able to get into this database? I have looked around in the forums here, but I didnt' really get a straight answer or the solution was for a different circumstance.
Thank You
View 2 Replies
View Related
Apr 24, 2006
Hi, I'm working on a piece of coursework which is due in pretty much tomorrow. I've finalized everything except security. I need my database to prompt for a user name and password when a user loads up the database. If a user name and password is given that is correct, then it'll open up the database with that user's permissions. But if an incorrect username/password is given then it should deny access.The help files weren't very helpful on this, I'd be very grateful if anyone could tell me how to set up this security.[Edit] Also, I dont know how to make the database automatically open up an input form (in this case, the main menu form) when the database is opened. How do I do this?
View 4 Replies
View Related
Apr 4, 2007
Thanks to all the folks in this forum who helped me to develop my fist access database application. Access is a great product and I really enjoy working.
I need to put this db for full scale production use and I would like to brainstorm some of your experiences on the security issues I need to address. I have like 12-15 users and everyone has a standalone version of MS Access 2003 full edition installed on their local hard drive. We do have a shared network drive (s :). I have few questions as follows:
1. Is it a good idea to split the database into front end and back end and install only the FE on individual user machines or just run the .mdb file from shared ‘s’ drive? I don’t have any experience with how the BE and FE works.
2. Currently I don’t have any user workgroup and permissions set to run on the database. Anyone can just open the .mdb file like any MS office suite applications(.xls, .doc) and start using (navigate, input data into the table through forms, search database, print reports, access to DB window, etc). Can some one advise what kind of security level should I incorporate as a minimum?
3. Under Tools-Option-Advanced TAB, I have selected No Locks under Default Record Locking and also checked “Open databases using record level locking” option box. Is it safe to keep it this way? Is it possible to lock only few records on a table? I have a situation that on a particular project (this is a decision supporting db application) after the project (project here refers to a record) is done, I want to lock these data so that no one can modify the existing data. At the same time, if they are working on a current project (record) then the user should have add/edit/delete access to that particular record. I am not sure if this (record level locking on a table) can be done.
4.In future I know that I need to modify the table design, forms, reports, modules. Is it good idea still to consider creating MDE file?
Your input is greatly appreciated and thanks a lot for your support.
Shan.
View 4 Replies
View Related
Jul 2, 2007
Help, please.
I have built a database for my employer which is held on a server and accessed by 8 terminals. This arrangement has been in place and worked well for 3 years. The database is secured and is accessed by users using individual user id's and passwords. Recently I have had to replace a faulty terminal. The new terminal has access to the main server but seems to bypass the security element as it gives access to the database without asking for user id and password. What do I need to do to correct this position? All the other terminals are working as they always have done.
View 1 Replies
View Related
Aug 15, 2007
How can I keep a user from accessing a database file from the directory? I've seen it before where if a user tries to open the database from the directory without being attached to the workgroup file it gives them a permissions error. I've set the users up with shortcuts to the database with the workgroup parameter but some users still go through the directory to open the file. When they do this, the currentUser property isn't captured. It logs them as the Admin. I want to keep this from happening. What can I do?
View 12 Replies
View Related
