Hello,
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?
Thanks,
David
how to give someone authority on one button in form
View 8 Replies View RelatedHi,
I've been working hard at learning Access for past two months and spent a lot of time Googling and speeding through Alison Balter's books and at a slower pace the Paul Letwin’s Developers Handbook set (fantastic but I probably need a year to absorb the incredible detail).
I've built a prototype reconciliation tool using the recommended FE-BE model. I opted for a total ADO solution and have had great success in putting together a fast and useful tool for 10+ users.
I avoided using Workgroups in my design and developed my own basic sign-on authority model which allowed an Administrator (don't confuse with Admin user in Workgroups) to add new users who can use the Access app. The allowable users and which ones are signed on are stored in the BE. This all works reasonable well until network issues occur and the signed on user record on the BE is not reset as should be if the user signed-off genuinely.
This is where I realised I need to be able to monitor who is connected to the BE. There is a way of doing that using ADO which I can get to work. I then noticed because all users are signed on with Workgroup Admin as default I could not differentiate between users. I then decided to implement Workgroup authority retrospectively.
I decided to place the .mdw on the LAN with the BE (this seems to go against conventional wisdom but could not workout how else I could achieve what I wanted to). This enables the two Administrators in different places to maintain users via the FE. I use the /wrkgrp command line flag to point to the correct .mdw.
I then started getting all sort of problems . . .I'm still in testing . . . not so bad but deadlines are looming and I'm worried.
Sorry, I digress. . .the problem I seem to be getting is when I open the FE :
Run-time error -2147217843 (80040e4d)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user
I also have problems developing the FE with the workgroup file in place. It seems to complain about another user is locking the FE.
The problem is a little verbose but just trying to paint a picture . . .now, this is what I'm after. . .I need the following ability:
1. Two Administrators who can maintain users. When a new user is added the Administrator chooses a password.
2. When the new user signs on the user is prompted to enter new password.
3. The administrators can view who is genuinely signed on and reset accounts appropriately.
I am currently studying the Access Security sections in the Paul Letwin book to better understand what is going on. It does seem retro-fitting an app to a workgroup model is not straightforward. Admittedly, I should have considered Workgroups in my design before starting (I will know).
Thanks for staying with me if you're still reading . . .any suggestion/pointers would be great.
Lastly, using Access 2000 : O/S W2000
I'm using a DLookup to show a calculated value in a field on a form:
=nz(DLookUp("OutstandingQty","qryremaininginvoiceamount2","[ODID] = " & Forms!frmOrders!sfrmOrderDetails!ODID),0)
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?
Thanks
Hi
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.
Any suggestions?
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.
How can I resolve this problem??????
Thankyou in advance
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 ?!
thanks
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.
Many thanks
Just trying to get some more replies...
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..
Thanks a lot.
Hi everyone
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?
Any suggestions appreciated
James
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.
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.
Hi Guys,
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.
Thanks for any help.
Donna
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.
View 13 Replies View RelatedHi,
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.
Any tips, to help get this to speed up some?
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?
Any suggestions would be greatly appreciated!
I have a database built in Office 2000.
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 ?
Many thanks.
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. :)
Hi
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:
Sorry All,
I have a simple question, how can I tell if my laptop has a wireless network in it. Thanks.
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...
View 2 Replies View RelatedThis 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!!
I am making a database and after a small amount of progress I save it and then copy and save with same name but with an extension V1, V2 etc. so that I can keep a working one as backup. Throughout this process I have come across 'Error accessing Network' connection may be lost.....! I have to go back to my previously saved version and redo the changes I was making. This time I didnt save until I was about to make my usual backup and I had quite a few changes. How can I stop this happening and make my last DB work again.
View 1 Replies View RelatedI'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.
Anyone have any ideas how I can make this happen?
I have a 16Mb DB. The intention is for users to access this over the network without copying onto their local machines.
At present, many of the forms are located on 1 master form and they are all subforms on tabs. There are a lot of calculated control boxes on the forms, and these seem to be very slow to bring back the data over the network whereas on my local machine, the data is displayed in a couple of seconds.
COuld this be sped up somehow? Maybe using queries or other methods?
Hello,
I have a database that will be installed on a network server and then accessed by the client workstations. I want to be able to lock down the db to that particular machine, so that the client cannot port/copy the db to any other machine and then run it from there. Is this possible to do? Has anyone attempted anything like this before, and if so how did you accomplish such a task?
The reasoning behind doing this is to prevent the client or employee from taking the db and going to another company and implementing it for free.
Thanks in advance.