Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Run queries on Network This may not me the place to post this question but it is the best place I could find so far. On my server I would like to run a series of queries at say 12:00AM while my computer is on but I am logged off. I was thinking I could do this in Windows Scheduled Tasks. I think I can make some sort of code or batch command or something to fire Access to run a macro or other vehicle to run my ... 3 30.09.2006 03:32:01 multi user database i am a total newbie with access. I am looking to take a database that someone else made it is on 5 computers individually and split the database make 1 backend to store all 5 users contacts in. I also want to be able to fix the forms, add fields etc. The most important thing is as it is a sales floor i need to be able to keep each persons contacts private from everyone else. any ideas on ... 2 29.09.2006 23:20:03 42 FE's and 1 BE Greeting All, Ive never had to do anything like this (Newbie). I am building a DB to conduct some Voting. Consists of 42 Voters. I have created the Tables I need for it, created the forms and split it. Now Im in the process of testing. Question is? What should the relations look like for the below basic set up? I put down what I bave so far. I dont want to run into the records be... 3 29.09.2006 20:47:24 Retrieve missing table? Hello, Monsters! I've been working with two coworkers on a small Access database for a few weeks now, but all of a sudden one of the main tables is simply no longer there. No one has deleted it (as far as we have been able to determine), but it's simply not there anymore. If anyone has any suggestions that might help get back a table that has gone missing, I would be very glad to hear it! ... 5 29.09.2006 12:55:38 FEUpdater on Peer to Peer I have been using the FEUpdater for several years now for an Access Database in a peer to peer network. It worked great until just a couple of months ago. Now I can't do design work in my front end without it locking up Access. If I get everyone out of it--no problem. But everyone has their own front end and we are only sharing the back end. Has anyone else had this problem or where to s... 4 28.09.2006 19:30:44 Trackin Users If i create individual accounts in an Access Database(using access 2003) is there a way for me to track the changes that each user makes? Thanks ... 2 26.09.2006 22:15:07 data not saving I have a client that is reporting their data is not saving. There are four users that enter data at the same time into the same table. They enter the data straight into the table not using a form. They have reported when viewing the data later some of the records have not been saved. We have the Database Exclusivness set to 'Shared' and records locks set to 'No Locks'. Any ideas? ... 4 25.09.2006 16:08:15 Best Practice?? Hi All, Can anyone advise on this please. I have a shred database with security. Database is shared between five users, all except me have Access 2000, I have Access 2003. Database in an Access 2000 format. We keep getting corruptions where the Form page goes blank. Repair sometimes brings the forms back visibly but they are still not accessible. The App and Data are not split and... 12 22.09.2006 20:39:31 Question about Access across a network I'm experiencing extremely poor response on my front-end application when it connects to a back-end database across a network. I've set up a real simple network. Three Windows XP computers and one hub. Each computer is given it's own IP address: 192.168.0.1, 192.168.0.2, and 192.168.0.3. One computer is the main computer and the other two are satellites. I shared out the folder were ... 5 20.09.2006 21:14:40 Only 1 user able to access mdb with Access 2003 We are unable to get multiple users to be able to use a mdb (no passwords) using Access 2003. If a user with Access 2003 is in the database, a user using Access 2000 can access the database but users with Access 2003 cannot. Is this a problem with Access 2003 or is there a setting within Access 2003 which will allow muitiple Access 2003 users to use the mdb? ... 2 15.09.2006 10:54:39 Unable to open database exclusively Occasionally, I have experienced times when I am unable to open a database exclusively. I understand that if someone has it open, its not possible to open it exclusively. However, I have a tracking mechanism in the database that checks to see who has the database open. Has anyone ever experienced times when you are unable to exclusively open the database to make some updates / modificatio... 1 14.09.2006 19:16:18 Determine if a record is locked & by whom Group: I have a multiuser form and I want to write some code to determine if a record is locked, and if so, by whom. Any suggestions and sample code would be greatly appeciated. My application has been split into a front-end and a back-end database. Thanks, BobV ... 2 14.09.2006 04:18:22 How to get multiple users to use the Database I am having problems with letting multiple users use the database at one time. I've been told to make a Front End and a Back End but being a newbie it's a little trouble. Do I have to make one of the ends into a .MDE??? I hope someone can help moi. Thanks Newf -- Newf ~Everyone needs a NEWFIE as a friend~ Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Fo... 4 13.09.2006 15:55:54 Record Locking Rules I posted this in the "getting started" forum, but maybe it belongs here... When you choose record locking rules (I happen to be using Access 97 for this one...), do those rules you just set apply to the database, no matter who uses it, or to the user, perhaps on this database alone? How does that work? -- Jim... 1 11.09.2006 23:35:02 determining if any records being edited Hello, I need to figure a way of determining if any records in a table are being edited before running a few different update routines on the table (Access 2000, program MDB on local C, data MDB on network drive). I have a form that lists out all the records in a small table (<200) and different machines can edit different records. At a particular time, I need to compare and update... 2 11.09.2006 15:46:54 Can't Open mdb When anyone else is using an mdb file, I can't open it at all even to just browse a table. All our computers have Access set for no locking and tried record-level locks as opposed to page locking. I've never had this problem before even though I've been using Access since 1.0. Can anyone tell me what to check for? TIA Tom Lake ... 10 10.09.2006 03:38:32 se indica hola como te va,aqui voy ... 1 10.09.2006 03:37:34 Thanks Thanks for the info Doug. I'll check it out. Bob ... 1 10.09.2006 01:34:25 Record locking problems with split db I have a split A2000 database, with about 10 users each with their own copy of the FE. I'm getting strange record locking behavior: If I have "No Locks" set on the forms, I get the normal message that "Another user has edited the record, do you want to overwrite/ cancel/ etc". But if I have "edited record" set on both users' forms, and I try to edit a record that is being edited by anot... 2 09.09.2006 23:07:00 Problems with multi-user Access database in updating from txt file Hi All, I'm a newbie at access but have been doing hardware IT for computers for about 15 years. I've got a client that is using MS Access for a database that is multiuser in the office, but in the field (6 supervisors) is is a single user database. The supervisors enter the new information or updated information and twice a month they perform an 'export' to the main office to update ... 8 09.09.2006 20:30:13 Database integrity We are using Win2000 with Access 2002. Hopefull I used the correct FE/BE setup. The only table resides on a constant network "K" drive. This is a linked table. I created an MDE file and put it on the 10 users "C" drive. After a very short while of use, the data becomes corrupted. This happens over and over for the past week. I salvage what I can, make some changes, and redeploy. The messa... 2 09.09.2006 15:35:22 Records not in order Win2000 pro - Office 2000 After entering data using a form - getting out - and returning - I find that the records are out of order. I have a generated primary key - the key does not show in the correct order. When I look at the table - It is not in the correct primary key order. Any thoughts? Thanks Bob ... 2 09.09.2006 11:25:55 Windows Xp 2002 Sp3 All, I am running MS Access 2002 SP3. Does anyone know what the latest service pack this version has ? Thanks for your help. regards US. ... 1 08.09.2006 17:14:35 Code to determine if record is locked Group: I have a front-end and back-end database. I have set the Record Locks property to "Edited Record" for the main form where users enter data. Is there a VBA statement that I can use to determine if a record is currently being edited by another user so that I can then bring up a dialog box to let the other user know that they cannot make changes on this record? What happens now i... 1 06.09.2006 15:24:06 Multiuser From to Pull Policy Numbers I am trying to create for work a tool for our employees to pull known "Policy" numbers from a table using a form after collecting additional information. Basically the user will select what type of policy, fill in some fields and click a button to get the number. The problem is there could be several people using this and I can not figure out how to pull the first "unused" number seperately for ... 1 06.09.2006 02:07:26 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13