Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Multi-user db with lots of bound forms I apologize in advance for the long background. I would appreciate any advice related to bound vs. unbound forms, or generally avoiding corruption. I have read previous topics on bound vs. unbound... It appears that there are very strong opinions for both sides, but no real explanation as to why. Situation: I am now the owner of a very form-heavy multi-user .mdb. By "form-heavy" I m... 3 03.02.2006 14:41:06 VB6 code to Lock access table Hi guys, I'm having problem locking a table in Ms Access using VB6 code. Actually I have 3 tables. Assume table names is A, B, C. Following is the process. 1. Open table A and update table A. (Must Lock the table A) 2. Open table B and update table B. 3. Open table C and update table C. 4. Open table A and update table A again.(After update...Release the lock) Once I open... 1 03.02.2006 07:52:56 Problem with Tony's Auto FE Updater too I am also having trouble with Tony's updater and the encrypted password. The only way I can get this to work is by making the ini file read-only to prevent it from adding the additional line and encrypting the password, which I do not want to do because the only user account that it will work with is some type of administrator account. If anyone has gotten this to work, I would appreci... 17 03.02.2006 23:30:35 data missing The staff use MS Access 2000 and XP Home edition The databases are shared over a Windows 2003 server. Each database is from 6 to 11 MBs. Just in the last several months a strange thing is happing. Staff will enter a date in a date field and several days later they notice the date is gone. They might enter a date on several records and a couple of days later all dates they entered on that da... 7 03.02.2006 19:59:31 Network performance Hi I have an 2000Access application which run in several network installations. One of my customers claims that the application is very slow in his network. On the server he has the table database (containing all his recorded data) and the .mdw-file. On the client he has the object database (containing forms, reports, code etc) and the Access 2000 runtime. The path to the table ... 3 02.02.2006 04:31:08 Database Crashing I'm encountering a crashing problem (database inconsistency) with a shared Access 2002 database. I've split a DB into a front-end (sales.mdb) and back-end (sales_be.mdb) and there are approximately 5 users logged into the DB at any given time. The problem is that I have one user who has to continually update the BE to push sales orders (every 15-20 minutes) and it at least 2-3 times a ... 2 02.02.2006 04:29:30 Lock Database? I am running an Access 2002 database (split front-end and back-end) and would like to LOCK the database on command (to update tables and avoid crashes for inconsistency). Is this possible? Please let me know, thanks. G... 2 01.02.2006 23:56:01 Multi user design gaffe Wondering if anyone can suggest a solution to my dilemma. (VB6, ADO, Access 200). The situation: Because I had pre-existing data inquiry modules that relied on database records, as well as a complex central data entry form that uses a recordset with a number of underlying tables, I decided to implement the form's cancel function via transaction rollback. Probably not a great idea, but it w... 5 01.02.2006 03:56:47 Strange network share experiences... Dear All, I'm a new member of this forum, so as well as asking a question in my first post, I'd better say hello to you all. I've been developing databases and applications in MS Access for 10 years now, and have experienced every version since Access 2.0. Fortunately we're not stuck in the dark ages any more, and life is relatively easy. I would like to tell you about a situation I ha... 6 30.01.2006 22:50:16 DB Suggestions please Hi Guys, Just wondering if anyone can help me with this problem, maybe provide some suggestions? 12 months ago we started using a field sales contact database for a team of 8 salesmen, this has worked very well the primary key for the contacts is contactID (autonumber)with notes being notesID (autonumber) Each of these will have started from 1 The issue I have now is that as it ... 3 30.01.2006 22:43:36 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 2 29.01.2006 02:47:12 automatic update of app over the internet I have a split, secured db in a multiuser setting with ca. 20 users and I use the AutoFEupdater for distribution to the workstations. I've been working on making an automatic update utility for the app and would like some input from others, who've attempted something like this. I'd like to have the app automatically check for updates in a folder on my website and download and install them... 1 26.01.2006 11:49:25 How to Identifier Users I have a shared db on the network. How can I determine if anyone is in the db, and their Network ID. When I need to perform maintenance on the db, I want to make sure that noone is in it. And if someone is it, I need to identify who they are so that I can contact them. Thanks... 15 25.01.2006 23:17:38 EOF or BOF Error in access (back end is on SQL server) Used a database without anyproblems. But when Database Backend was migrated to SQL 2000, then everytime I try to append records or insert records ot a table, I get this error. ANy idea how ot get a permenant solution. All help appreciated (See Below) sorry for the lengthy code: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++ Private Sub cmdCreate_Cl... 2 25.01.2006 21:33:03 Datasheet appears after requery I am creating a database to be used on a multiuser environment. New records will be added and records will be updated with several users. I have a form that displays all the records - kind of like a datasheet view. I understand that I must have some type of requery. Currently, I have a requery command button that goes to a macro OnClick. The macro performs the function of the requery. I... 1 22.01.2006 22:24:54 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:13:31 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:13:24 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 15:35:15 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 15:35:03 multi user Dear friends, I have a very simple access database: It only has three column: sales person ID, invoice number, invoice amount What I want to do is: We have 5 sales person, and they have their own unique ID, and when they open the database, they can use their own ID and password to open the database file, and enter their own invoice number and the invoice amount. Could anyone tell me h... 2 20.01.2006 22:48:12 Litmus test for Network Multiuser Database suitability? Hi All, Is there a general checklist to ascertain whether an office pc network is 'up to' having an Access split multi-user database running on it? Are there any specific points about a Windows XP Pro network that need attention? Regards, Penny. ... 4 20.01.2006 21:20:03 Access 2.0 db on Windows 2003 server and Access 2003 Hi! Till now i have Access 2.0 db xxx.mdb on Novell server and Access 2.0 clients on XP workstations. Also I have Access 2003 client with db yyy.mdb on local workstation, where are the linked tables from xxx.mdb, reports and queries whoes take the date from linked tables. Everything works fine until migrate from Novell server to Windows 2003 server (all permitions are taken from Novell - and n... 4 19.01.2006 21:29:44 Help - can;t open db on one PC only Hi, I have an access database (97) running in a Windows 2003 system. All my users can open the database no problem except for this one PC that has recently been built with Windows XP SP2. When I try to open it I get the following error; The Microsoft JET database engine stopped the process because you and another user are attempting to change the same data at the same time. can ... 2 19.01.2006 12:25:02 Multi User Queries taking forever.... We have 10 users using access XP 2002, accessing an access database with about 300,000 records. currently it is taking about 6-8 minutes per lookup on the database which resides on a windows 2003 server with 2 gigs of Ram. Is this normal or is there something I can do to speed the lookups? My systems are running windows XP SP2 with at least 512 megs ram with most close to a gig a ram loc... 6 18.01.2006 17:55:07 Free mp3's <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>And much more that that!</P> <P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P> <P>This site offers free and legal mp3's, software, movies, games.<BR>They also have a l... 1 18.01.2006 05:03:33 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13