I was given a task to make an application that will enter/monitor job assignments of our technical staff on a daily basis (roughly 15-30 assignment per day), so I created a table which has all the fields and it worked well.
So after the dressing up the database, I split the table and saved it on our server, copied a FE on workstations but the data is not refreshing the way it supposed to be, what I want is whenever a user accessed the application data will be refreshed on diff. workstation in real time.
Can someone point a link on the forum regarding my problem or can someone help me to solved this problem from ground up?
My database is used by a few users on a shared drive in "read-only" mode so they can't change any data.I set a scheduled task to copy an updated version of the database (which I edit) every morning.
The problem is that when the users forget to close the database file I can't overwrite it.For this purpose I wrote a small code that quits the application at 00:00 using Application.Quit.The code WORKS when I test it on my computer, but every morning when I try to open the file I see that it is opened by another user since I also open it as "read-only" - meaning the code didn't work...getting the code to work properly OR get a better solution to be able to overwrite the file even though it's opened by other users.
Hi everyone, I am hoping someone will be able to help me with a problem I have. I am undertaking a social network analysis and in order to do this I need to be able to create a matrix with the following format:
Group Person J Smith G Fowles M Jones X 1 0 1 Y 0 1 0 Z 1 1 0
I also need to be able to store and retrieve personal and group level details. Note that people can be in more than one group and groups can have more than one person. My problem is that the data has been gathered by another institution and is only available in the following (Excel) format.
Group Person Role Group Characteristic ..... X J Smith Strategist Level One X M Jones Supporter Level One Y G Fowles Financer Level Three Z J Smith Strategist Level Ten Z G Fowles .... Level Ten
Any idea how I can go about doing this? I know how I could do it if I manually entered the data, but because there are literally thousands of individuals (and a whole heap of groups too) I am hoping hoping hoping that I can do it using Excel and Access. Any advice would be incredibly appreciated.
I have just upgraded to office 2007 and was wondering if it was possible to make my access database into a stand alone application so users cannot edit it?
I got a chance to make some extra money outside of my usual job.
I am creating a billing system for a plumbing business. It's pretty easy and shouldn't take me long to do. The only thing is I'm not sure what to charge.
I do not have full time internet so I cannot sign in to office 365. I like to know for creating web application locally on my computer what software I have to install and how?There is special procedure for installing software's?
I'm trying to create a database whereby employees within a business can select their name, or scan the barcode on their ID badges, to clock in and out of work.
I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.
Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.
I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?
it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!
I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?
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.
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.
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 ?
