I've never used the security in access before but I have designed my database and have used the security wizard to set my security. it has now put a shortcut on my desktop which is now used to open the database.
The problem is that now I need the database to be opened from other computers on the network. Ive tried to simply open the database file from other pc's on the network but I get the permissions error, Ive tried copying the shortcut from my origional desktop short cut and modifying the targets but that also didnt work.
I'm making a version of my dba using the upsizing wizard, then i'm packinging it to distribute it as a runtime version and save the data on sql server
But i'd like to be able to keep track of who is adding what to the database. How can I check who added what data? from which station? how can I monitor things in that setting?
Also if 2 users open the same form I'd like to restrict the second user, and have a window poping up telling him/her "you cannot add data to this table until user#123 is done with that table" a little bit like quickbooks does.
I have an access database that I created and setup user level security. I have encrypted the database and followed the directions of removing the admin from the admins group and created the new *.mdv file. When I access the database I get prompted for a username and password. When someone else from another computer accesses the same database they don't get prompted for anything and can go in and edit or access anything in there. Is there a way for me to secure the database up so they can't do this. The whole purpose of me setting up the User Level Security was for all users to have to login to there respective groups.
I'm doing some support for a company who's access is on a network. I think it must have been setup so that their login to the network determines whether they can access it or not, although it still asks for a username and password.
Anyway I have a local copy of the database and a username and password for the administrator. But I can't open the copy I'm getting the error
" you do not have the necessary permissions to use the "filename" object. Have your system administrator or the person who created this object establish the appropriate permissions for you"
I was hoping to be able to work on the database without having to be on site all the time. Is there anyway around this? or do I have to go back onsite to resolve it, and when there how do I do it :confused:
Ok.. I have done this before at another job, but this network (or stupid me) is giving me trouble. I'm trying to setup a database security (login/password) for a database on a network. I setup the security levels..setup a seperate workgroup... From my computer it logins fine with the correct workgroup.
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)
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.
I have a database that located on a network. I have several child replicas that only certain persons can access. The main database, everyone has all rights to. The child only the person allowed to have access has rights to. We keep getting the message that the database is already in use, when a second persontries to get into the database. Does anyone have any suggestions that might help?
I can't add it to the form's base query because when I do the query becomes un-updatable.
While I'm working on the form on my pc locally the field shows the correct value. However when I view it on my client's pc, where the data is on the server but everyone has a frontend, the field shows Error#.
Any ideas or is there a better way to show this calculated amount?
I have created a management DB which basically shows a high level overview of our Call Logging system. This is basically a split DB (FE on users machine and BE on Network). In th FE there are also a couple of ODBC Linked tables from the main DB.
Everything is working fine with this but periodically there seems to be a Network Blip which causes numerous error messages 'object not set' and Disk or Network Error.
I appreciate that this is probably due to the Network experiencing a tiny blip but it kills my DB.
Is there any way to either automatically reconnect the DB or alternatively close the DB cleanly without all the error messages.
I have two pc,s hooked up as a workgroup network( no server) I have a database on one of the pc,s and when I open the database in the other pc it says that it is "read only". So I cant enter new records.
is there any way to use a same database in a network that if i entered some entery and some body else entered another entery it will show all data entered by every people in everyone's computer ?!
For the past several years I have been designing and building Access databases. They are designed for small evironments to be used on one machine only. I am now faced with a situation where my client would like to have his database placed on his network server so it can be accessed by several computers. This is a little outside my area of expertise. I have searched the forum but I keep coming up with references to front end and back end and other things I don't understand. Can someone point me in the right direction to search for: what should be on the netword and what should be in the computer. what changes should I make to the database stand-alone vs. network. what unexpected problems should I expect.
Or perhaps you could suggest a book I could buy to assist me.
This post is really aimed at someone that has experience of network databases and the problems they can pose but if you can help at all that would be great!
I work for an insurance company and we have created a database for registering complaints on. The one we currently use is a single .mdb file which can be shared by up to 60 people at any one time. This is creating a lot of problems when the queries and some VBA code are run. I therefore made a server file which is just an mdb file with data tables in and NO forms or queries. This file is stored on a shared drive on the network server. We then created a client file which contains all of the forms and queries and code. This file contains linked tables to the server so when data is entered into the form, it "Sends" it to the server mdb file. The client is installed on each of the local machines c:. The problem with this was that if we made a change to the database, we would need to reinstall the client on every single user pc. This would of took ages. I therefore made an auto-update function that checked the version number on the server and if the server number was greater than the client number, a simple .bat fiile was run which copied the updated client file from the network to the relevant users local disk. The problem we have now is that our IT department are concered that if we make a change to the client and all the staff log in at 9am for example, it will start doing multiple copying of a file around 8mb in size to around 60 machines. They are only running on a 2meg pipe so this could cause some problems. We are not looking to change the client & server idea but does anyone know if this will have a big impact and infact if the updates for 60 machine is the equivalent or lesser of 60 people sharing the single file i mentioned earlier. If the IT dept are happy with 60 users accessing the same file at the same time, which they currently are, why are they unhappy with it updating these machine using the new method.
Would really apopreciate any thoughts anyone has..
I have searched for help on this forum and all over for a while but cannot find the help i need.
I have a database stored in my user area on a schools network. Other users around the school access the database by clicking on a shortcut to it found on their start menu. The database is not split with a fe/be and usernames and passwords are not required to log on, they simply click the link.
I would like to know how I can find out which users have the database open at any given time? I have a piece of software that tells me the computer name but that is no use, I need the users name. Is there a way of pulling this from the network because each user must first log on to their computer using their name and password before they can access the database?
I have a small access database that my users keep open all day long. Access 2000.
I have one primary version of the DB on the network. No one uses it. I have another file on the network that has linked tables to the primary db. I copy a version of this DB to each workstation.
So each user has a full blown DB on their desktop with linked tables back to the main DB. Is this a good set up or are there any issues doing this? What is the best set up for multiple users across the network? Thanks.
This might sound like a stupid question but I'm just trying to work through it in my head and I don't want to miss something, so a couple of new pairs of eyes might just clarify.
I've created a call monitoring database for a call centre and I have split this so that they have a front end and a back end as per someones instructions. They have done the normal thing in as much as just putting a shortcut on everyone's computer so that they are all trying to access the one front end instead of putting a copy of it on everyone's machine. I've got a feeling they are going to ask me to go in and put it right, so when they have put a copy on everyone's machine will that automatically link to the back end or do new links have to be made, if so how would I/they do this? - is it done from each computer?
I don't really know, I'm just assuming that's what needs to be done but I don't want to tell an IT team that what to do if it's not.
I've only ever set up a sharing database once before and that was built on the company network and I set it up on each computer in the department, but they weren't doing data entry it was only for interrogation purposes and it was a few years ago now so I'm rusty, but I do remember it took me a long time to do.
I have a db on a network drive and the performance is terrible, it runs fine on my local machine. How can I make it run better? The db is only 2 megs so I figured it would be ok, but since my forms have numerous queries within them, performance stinks.
Hi, I've been developing a database 900k records so far, and with the DB installed on my local machine my queries that I use for my reports work pretty good. They will open in under 10 seconds.
but now that I've about done with the DB, I've moved it to the network, and now those same queries are taking forever to run some over a minute to open!!
Here is an example of one of the queries
SELECT q_complete_list_IIR_2Apt1.Main_ID, q_complete_list_IIR_2Apt1.Code, q_complete_list_IIR_2Apt1.Code_Description, q_complete_list_IIR_2Apt1.Display_text, q_complete_list_IIR_2Apt1.Static_Text, q_complete_list_IIR_2Apt1.Effective_Start_Date, q_complete_list_IIR_2Apt1.Effective_End_Date, tbl_IIR_description.IIR_code, tbl_IIR_description.IIR_description FROM q_complete_list_IIR_2Apt1 LEFT JOIN tbl_IIR_description ON q_complete_list_IIR_2Apt1.Information = tbl_IIR_description.IIR_ID WHERE (((q_complete_list_IIR_2Apt1.Effective_Start_Date)<=[Forms]![frm_report_screen]![txt_date_completelist]) AND ((q_complete_list_IIR_2Apt1.Effective_End_Date)>=[Forms]![frm_report_screen]![txt_date_completelist]));
I've already tried to compact/repair the database, and that brings the overall file size down, but really doesn't help these queries at all.
I thought at first, that maybe since I don't need to look at 'all' records, that I could maybe do a prefilter. So I created another query, to get only certain records, and then used that in the first query. But that actually made it even more slow. I guess it's because this new query, still has to look at the main table to start with, so it really just made another step in the process.
Everything (almost) is ready to go live on my database. My problem now is that when I put the DB out on the network, and went to someone elses pc station, to enter data, it saved the changes there at her station but not back out on the network. WHY? Am I missing some setting in my DB somewhere? Please help?
The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut.
The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to the one database on the server which is in a shared mode. Would the security I have implemented still work or would I have to de-secure so everyone has the same level of access.
They do not have Access on all PC's. IFor this to work I presume Access is needed both on the server and PC's
I understand if I purchase Microsoft Access Developers 2000 it has a feature where I can distribute a database to users without Access? However, am I right in assuming this needs the database to be split.
In the UK are there any suggestions on where I can buy Microsoft Access Developers 2000 ?
We are shortly going to start using tablet PCs over a GPRS bearer circuit for some of our employees to update our core business system from within customers homes. To do this we have purchased a very streamlined version of our core system, designed to work at a reasonable speed even over a normal GSM connection.
The employees that will be using this also use an access database that I've created though. Whilst it isn't crucial that they can use this while they're out and about, it might be useful and it's something I am interested in looking into. In order to make it feasible though, I think I would probably need to dramatically reduce the amount of data transferred between the be and fe due to the high cost of data over GPRS (as well as the speed). So I have a few questions.
1) Am I right in thinking that if I am using ms access as a backend, all the processing is done at the front end? i.e. I run a query on the front end, the whole table is retrieved from the back end and then filtered at the front end?
2) Is there any way to get around this? Or would it require switching the back end to SQL Server or something?
3) Is there any way of measuring how much data (in bytes, kb etc) is being transferred between the front end and back end while running queries, updating records etc.?
I'll probably think of some more questions but this will do for starters. :)
I've got a back end database on one of my computers and i'm trying to get the link tables to work over a network from another computer. Ive set the link tables up but it wont let me edit any data because it is read only. Its not read only when i run the front end from the computer that stores the back end. How do i enable the front end to edit the data over the network?
also, it is a multi-user system so i want multiple front end parts accessing the one back end but whenever i try and access the data from one system when another is already open it says the file is in use and i can't do anything!
I'm really stuck at the moment and i really need some help please! :confused:
I have a access application which is split into 2 bits with the backend being on the network. The thing is its very slow performance wise and i want to try and optimise it...
This problem is driving me nuts!! I`ve just spent a fair few months creating a database to be used by our sales team, I`ve about finished it and came to trial it with the sales manager. When he is using the database at the same time as me it becomes slow. The design has a front end with all the queries, forms etc and a back end on a server containing the tables. The database was created using Access 2000 and was designed to replace a similair db created on 97 which has a decent speed on the network. The other strange thing is that one particular macro that I`ve been using for the speed tests runs quite slow (about 3 secs) when 2 pcs have the db open but once the macro has run if it is run again it takes typically less than a second to run. What would cause a db to run a macro at different speeds after they`ve been run once? I`ve tried everything I can find on the net to try and improve the speed to no avail. Help please!!
