Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Runtime 97 then 2003 problem with reports Here’s an odd one? My clients just rolled over from Windows97/Access 97 to XP/2003, so yesterday I ran my/their database app through 2003 and converted the file formats frontend/backend to Access 2000 format. We had been running Access 97 runtime and everything worked fine. Now under Access 2003 runtime the uses can input/read/edit data through forms etc but previewing reports shows ... 2 31.08.2006 22:43:56 multi-user sql server views and local tables I'm in the process of trying to convert an Access database that is currently being used by 3 people into one that can be used by more than 20 people. The report that is created uses linked SQL Server views and two SQL Server Tables that are joined in the views. The two tables are used for the user input. One holds account numbers and the other holds the month and years that they want the... 7 31.08.2006 18:03:02 Wireless! Over the last week I have had one use corrupt two databases three times. I soon realised that unlike most other he was using a wireless network connection and the sugnal was inconsistent and frequently dropping. A quick peruse of the this site indicates that wireless connections are a big no no. So my question is, how can I make the local FE detect if a wireless connection is being used and... 1 30.08.2006 15:16:28 filter problems I have one user on the our network that cannot alter the filter settings on a pivot report. The administrator has set him up with full red/write access and other users can change the filters, i.e. select deselect options. Any ideas? TIA ... 1 28.08.2006 22:14:30 User blocked to open .mdb Dear all, I've put my .mdb database file in a local network server to let my colleagues using it simultaneously. It works perfect if all of my colleagues already open the .mdb file and then someone edit the records by using form. However, if one user open the .mdb file and then edit the records, and then another user didn't open the .mdb yet, then when this user want to open the . mdb, an e... 4 26.08.2006 20:35:10 False Error requesting Database password Using Access in Office 2003 with Sql server 2000 backend. Database is secured using workgroup. Within last two weeks, a few times when opening the database, the prompt shows up requesting the database password. There is no database password and never has been. This database and security was set up 6 years ago. Microsoft has really ruined Access. Can anyone help. -- Matthew Mark ... 10 25.08.2006 18:57:42 read only message Hi Heros, I have had my db operating for 3 years and never ran accross this problem. I am not longer able to write to the database. I verified with IT that the permissions on the folder have not been changed. The db error says "Read Only: Database in use by another person" however, there is no .ldb file. Whether or not the following as anything to do with it, I dont know. I was queryin... 3 25.08.2006 14:31:01 Network with mix version of office Hi, On a network we have a win2000 computer where access data are stored in mdb files. The program (front-end) is store on the same computer in another file. To consult the data we have win2000 and win xp client accessing the files concurently, maybe 12 users. Everyone use access 2000 and everyone is using the same program file. The network is instable. What can i do to improve i... 6 23.08.2006 17:01:21 Access' limits I'm intending to create an Access database that will contain records of a product testing application in a manufacturing site. One table will contain most of the data, and could contain as many as 2-3 million records per year. The database BE will be on a networked drive, and the FE will be either VB or VC++ code. Simultaneous access by 2 or 3 users, but never having to modify the same ... 3 21.08.2006 13:28:59 hello this is a test ... 1 19.08.2006 13:51:07 PASSWORD PROBLEM in .MDW FILE we are not able to access our mdw file. it says: Not a valid account or password. I guess the password was changed somehow. How do we hack into our mdw file and find out our password? please please help thanks ... 5 17.08.2006 10:56:02 ADP Hi All, I recently moved a database to a SQL server backend to allow for multiple user access. I was successful in all account except speed. It is extremely fast on my end(east coast), however, west coast users experience extremely slow data access, so forms take five seconds to load as opposed to instant. Now, I don't know much about networks, but could this be due to that? I know that the ... 1 16.08.2006 14:52:47 Mysterious Lock Hello, I have an Access data base that has the frontend and the data portion split. The data is on the network and each user has a local copy of the front end. Everyone is able to access it except for one machine. I've tried to log in using the Administrator ID/Password but I get an error message that the backend data is locked exclusively by some one. I've kicked everyone one, reb... 2 15.08.2006 22:54:04 batch file problems alright, i have a batch file, and i thought i was doing everything correct but it does not seem to do its job. Here is the text in the ..bat file. -------- cls c: cd \docume~1\%username%.domainname\desktop copy j:\Prge\Component\AOV\AOV Database\MNGP Valve Database.mde . -------- i want it to copy this mde file to the desktop of any user who clicks the command button on my access fo... 3 15.08.2006 03:46:23 Splitting an Mde file? I am almost at the finishing line with a great deal of help from here. I have now normalised the tables, built complicated queries, forms, reports, all from scratch as I knew absolutely nothing before I started with Access three months ago. I have compacted and repaired the database using the wizard, and also complied the code and analyzed all tables, forms, queries, and reports and relation... 5 15.08.2006 01:54:10 Running out of Memory I'm having a memory problem with Access 2003. It runs slow especially in design and I get out of memory problems. I should have amble memory at 384mb of ram. But twice my virtural memory had to be updated. Can someone point me in the right direction to get this fixed. It just started last month when we had all those MS updates. Thanks. ... 1 14.08.2006 17:00:30 Split DB Lockouts Question Access 2003/Windows XP, split individual PC FE/Server BE database. Need to have some users who can read and write, others who can only read. Have set server folder- and file-level permissions accordingly. Both FE and BE are set for sharing, no record locking. Unfortunately, we're encountering intermittent, maddeningly inconsistent problems where users in BOTH categories get lockout m... 7 14.08.2006 12:58:01 Sharing a database Ok in a nutshell here is my problem and I havn't worked with access since 97 so I need some help. I need to create a database that I can share amongst users with all having full access to modify, edit, and delete records. I need to be able to share this with all the users on our small office nework and we don't have the funds to aford sql server. Is there anyway to do this? ... 2 11.08.2006 15:03:44 Error Message When Bringing Database Up... I have a split database that runs offs my server, and 5 computers that access the database off the server through a shortcut I placed on each computer. And it's been working for years (with little errors here and there; but overall running nicely). This morning when we try to access the database all of us get the following error: The database 'F:\Repomaster\RepoDB.mdb' needs to be repai... 4 09.08.2006 17:27:09 Sync Local DB across multiple locations over web What would be the best method of syncing a database, that is stored locally on three computers, that are not connected by a network, but by the Internet only. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200607/1... 8 07.08.2006 15:47:52 Looking for record locking documentation/primer Hi All, Can anyone point me to information as to how record locking is handled in Jet 4.0? I've downloaded JetUtils from Microsoft's web site but the contained documentation does not specifically address 4.0, only up to 3.5. Any help is appreciated. Ciao, Tony ... 3 07.08.2006 15:12:20 update data from another form hi all, I use MS Access 2003 and VBA I have a form with search feature, the result of searching is shown in a subform, when the user click the record on the subform or they choose the record with keyboard another form is opened with that record so user can edit information and update data after user close that form. I tried bookmark properties to get the current record but it not accept Any... 2 03.08.2006 13:27:08 Exclusive error I have a database, Trakker.mdb, that is on a server. Each user has Microsoft Access on their individual computers. Trakker.mdb is not split. If person A opens Trakker.mdb first, then person B gets an error message about Trakker.mdb being open exclusively. Person B has to hit the OK button 30 times to get the message to go away. [Yes, she counted 30.] On the other hand, if person B ope... 4 03.08.2006 02:13:01 Error 3734 and Passive Shutdown Hell I'm having continuing problems with Access 2003 databases and totally bogus error messages about exclusive access and what-not. I am the only user, all the other machines on my network are turned off, and I have only a single instance of a single database open. Previously, whenever my VBA code would hit an error, I could not save any changes until exiting both the database and the VBA edito... 7 01.08.2006 00:22:10 Multi User Locking errors Hi All, I'm seeking a little advice about how this should be handled in a multiuser access application. We have a split access 2003 database with each client having their own front end. In our current scheme of things it's likely that multiple clients would be editing the same record simultaneously thus we constantly receive the "Error 3167 This record has been deleted" or the "Write ... 2 27.07.2006 17:31:30 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13