--------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E2W00000Date: 02/24/97 From: BONNO BLOKSMA Time: 06:54pm \/To: ALL (Read 4 times) Subj: Problems with large tables Hello All! At work we have an application in Acces 2.0 Up until recently we didn't have a lot of problems but lately..... When the database files are on the local harddisk there's no problem however as this is supposed to be a multiuser application the files are on the network. That's where the problem is. The database has a total size of 5MB, that's all the tables and code in the whole database. When we try to delete about 3000 records in a table by selecting them and simply deleting them Access manages to generate over 100MB of trafic across the network and then crash because it tries to set to many locks on the Novell server. With 3000 records I can set the number of locks per session to 10000 and we can delete 3000 records but some temporary tables allready have 16000 records and those need to be deleted too. :-( With several queries that query the database we have similar problems. Access generates an enormous amount of network trafic and it takes hours to do a simple query that takes seconds if the database is on the local drive. Like I said, with the databse on the local harddrive there is no problem, not even with the 16000 record table. But on the network....... Anybody else familiar with these problems? See ya on/off-line |] |] |_]onno |_]loksma --- * Origin: Point of Big Hole BBS, Enschede, Netherlands (2:283/7.32) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3B00000Date: 03/06/97 From: RONNIE TOTH Time: 12:54am \/To: ALL (Read 3 times) Subj: V1.0 to v2.0 Hello. I am installing v2.0 on a separate drive and wish to keep v1.0 intact on another drive. Is there a way to import the database file to v2.0? What file/s do I look for to move to where? This is the start of the database and I am still new to the program having only the one database. Thanks, Ronnie --- Blue Wave/386 v2.30 * Origin: Sox! (305) 821-3317 Live from Hialeah_FL_USA (1:135/71) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3D00000Date: 03/08/97 From: PETER ORTNER Time: 05:04am \/To: THOM KIRBY (Read 3 times) Subj: Re: Reference Book? Hi Tom. -=> Quoting Thom Kirby to All on 11 Feb 97 16:35:09<=- -=> Subject "Reference Book?" <=- TK> What's a good reference book for Access? Where I work, they TK> bought a Site license and I can't find the book(s) on Access. I'm at TK> the point where I'm beyond "Mr. Wizard" and need something more. TK> Does anyone have any sugguestions for a good all around reference TK> book that also covers the actual code. Aparently the MLP's come with redemption coupons for the manuals, and if you can track them down... I personally quite like the Sybex title MS Access 2 Developers Handbook. The code samples are quite handy, and the book is written in a no-BS way. Regards, Peter. --- http://www.pcug.org.au/~port (Web Page) port@pcug.org.au (Internet E-mail) Peter Ortner, 3:620/243 (FidoNet) ... A real fast ant does things in an instANT. --- GEcho 1.12/beta+ * Origin: The InterACTive BBS - Canberra ACT - (06) 253-4933 (3:620/243) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3D00001Date: 03/08/97 From: PETER ORTNER Time: 05:04am \/To: GERRIT BERKOUWER (Read 3 times) Subj: Re: scrollable date fields? Hi Gerrit, -=> Quoting Gerrit Berkouwer to All on 13 Feb 97 12:15:52<=- -=> Subject "scrollable date fields?" <=- GB> Probably a very basic question: how can I get a "date field" e.g. GB> tue 12-02-97 with the possibility to scroll through the dates with the GB> cursor? GB> I use Access 7.0. There may be a calendar control which you need to manually register with Access, that comes in the box. I know for a fact that Office 97 definitely comes with it, but I'm not sure about Office 95. Regards, Peter. --- http://www.pcug.org.au/~port (Web Page) port@pcug.org.au (Internet E-mail) Peter Ortner, 3:620/243 (FidoNet) ... Grandad, We got the disk out, but we bent the screwdriver! --- GEcho 1.12/beta+ * Origin: The InterACTive BBS - Canberra ACT - (06) 253-4933 (3:620/243) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3E00000Date: 03/09/97 From: LILA GODEL Time: 05:05pm \/To: ALL (Read 3 times) Subj: Solution to Database Prob When I first created my Access data base with version 2 (now in version 7) I set up a table, form, and report to track the songs on my favorite songs tapes. Later I split it into one table, one form, and one report for each tape. This allowed me to have a heading for each tape on the printed output to find the tape number for songs instead of a song number field. It also kept me from having to reprint the entire output after making changes to one tape. During the split I set up item number fields in place of the song number field which do not print. These fields are used order the records. Each song on each tape is assigned and number according to its location on the tape. Queries for each tape sort the records by these numbers. With this setup I can view and print the songs in the order they are on the tapes even after re recording the tapes to re order or remove songs. The problem with this initially was that each time I added a song after the last one on a tape I had to enter an item number for it automatically even though it was one higher than the last. Just recently I solved this problem. Following are the steps I created to have the value of a field for a new record be one higher than the value for the last record. How to Make the Value of a Numeric Access 7.0 Field for a New Record Be One Higher Than That of the Previous Record * 1. Open the form used to enter data into the field in design view. 2. Make the label and text box for the field invisible. 3. Create a new unbound invisible text box with an invisible label. 4. With the new text box active click on the Control Source text box on the data tab in the properties sheet. 5. Enter =Count([Field Name])+1 replacing Field Name with the name of the field that is the control source for the first text box that appears on the form in form view. 6. From the View menu select Code. 7. From the object list select the name of the first text box that appears on the form in form view. 8. From the procedure list select AfterUpdate. 9. In the code window enter Me.Refresh 10. From the procedure list select GotFocus 11. In the code window enter Me![Field Name].DefaultValue = Me![Text Box Name].Value replacing Field Name with the name of the field to be incremented by 1 with each record addition and Text Box Name with the name of the newly created text box. 12. Save and compile all modules. 13. Correct any syntax errors and save the form. * Please note that this will only work if the highest existing value for the field is equal to the number of records in the table containing the field and a query that sorts in ascending order on the field is used as the record source for the data entry form. --- OLXWin 1.00b Humbled again by overlooking the obvious * Origin: Riverdale, Ga (1:133/9024) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3F00000Date: 03/09/97 From: DON BOMER Time: 09:21pm \/To: RONNIE TOTH (Read 3 times) Subj: V1.0 to v2.0 Hi Ronnie, RTI am installing v2.0 on a separate drive and wish to keep v1.0 intact on another drive. Is there a way to import the database file to v2.0? What file/s do I look for to move to where? This is the start of the database and I am still new to the program having only the one database. If you open the V1 MDB file with V2 it will ask if you want to convert it. If you do not, mak a copy to another filename first. I STRONGLY recommend that you trashcan V1. It is a real dog in comparison. I have upgraded to /95 and soon to /97 but must still program with / use V2 at work daily due to our ancient machines. You will LOVE V2... All my BEST, Don, W5MML InterNet: sysop@camellot.usbbs.com Jeddah, Saudi Arabia Fido: 2:542/700 AKA: 9:500/91 239:105/30 * 1st 2.00 #281 * Are you using Windows or is that just an XT? --- PCBoard (R) v15.3/2 * Origin: FIDO Net: Camel-Lot II BBS Jeddah, Saudi Arabia (2:542/700) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3G00000Date: 03/11/97 From: RONNIE TOTH Time: 10:40pm \/To: DON BOMER (Read 3 times) Subj: V1.0 to v2.0 DB> Hi Ronnie, Hi! DB> RTI am installing v2.0 on a separate drive and wish to keep v1.0 DB> intact on another drive. Is there a way to import the database DB> file to v2.0? What file/s do I look for to move to where? This is DB> the start of the database and I am still new to the program having DB> only the one database. DB> If you open the V1 MDB file with V2 it will ask if you want to convert DB> it. If you do not, mak a copy to another filename first. I STRONGLY DB> recommend that you trashcan V1. It is a real dog in comparison. I DB> have upgraded to /95 and soon to /97 but must still program with / use DB> V2 at work daily due to our ancient machines. You will LOVE V2... Being somewhat paranoid, I made a copy of the MDB file. Then I moved it to the new V2.0 directory. Then I opened it and yes, saw the message about converting after the warning. I did the convert. All appears to be ok and if I panic, I still have v1.0 on another drive but it will probably be history real soon. Everyone I know says what you have said. Dump v1.0. Since you are using 95 now, how is this different from v2.0 since I am using the 2.0 on a Windows 95 system. What will 97 add to the program? I have heard that 97, if purchased by itself, has some problems. Thanks for your input. Ronnie --- Blue Wave/386 v2.30 * Origin: Sox! (305) 821-3317 Live from Hialeah_FL_USA (1:135/71) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3H00000Date: 03/11/97 From: KEITH SAYERS Time: 11:49pm \/To: RONNIE TOTH (Read 3 times) Subj: V1.0 to v2.0 -=> Quoting Ronnie Toth to All <=- RT> I am installing v2.0 on a separate drive and wish to keep v1.0 RT> intact on another drive. Is there a way to import the database file RT> to v2.0? What file/s do I look for to move to where? This is the RT> start of the database and I am still new to the program having only the RT> one database. Having got V2.0 installed, start it up, got to 'Select Database' and search for the original V1.0 database. It should open automatically into V2.0. Having got it open, close it, and you will be asked if you want to ave it in current format (or some such question). Say Yes and it will now be saved as a V2.0 database, with the original V1.0 database still intact. I forget the exact steps - I do not have Access here at home to verify - but I recently had a contract in which I had to do just that. It was airly straight forward. If you have difficulty, post another message saying what you get on screen and I will try to help from memory. Alternatively - an afterthought - search your V1.0 drive for a file with suffix .MDB and copy that into your V2.0 drive, that may make it a bit easier. Good luck! ... !!!!hctiws esever eht dnuof I... --- GEcho 1.12/beta+ * Origin: The InterACTive BBS - Canberra ACT - (06) 253-4933 (3:620/243) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3J00000Date: 03/14/97 From: RONNIE TOTH Time: 10:05pm \/To: KEITH SAYERS (Read 3 times) Subj: V1.0 to v2.0 KS> Having got V2.0 installed, start it up, got to 'Select KS> Database' and search for the original V1.0 database. It should open KS> automatically into V2.0. Having got it open, close it, and you will be KS> asked if you want to save it in current format (or some such question). KS> Say Yes and it will now be saved as a V2.0 database, with the original KS> V1.0 database still intact. KS> I forget the exact steps - I do not have Access here at home to KS> verify - but I recently had a contract in which I had to do just that. KS> It was fairly straight forward. If you have difficulty, post another KS> message saying what you get on screen and I will try to help from KS> memory. KS> Alternatively - an afterthought - search your V1.0 drive for a KS> file with suffix .MDB and copy that into your V2.0 drive, that may make KS> it a bit easier. Good luck! Hi Keith, I did the alternative and copied the .mdb into the v2.0 directory. Had to convert it but all went well. I'm having another minor problem but need to figure out how to describe it well before I post for help. Thanks for your suggestions, Ronnie --- Blue Wave/386 v2.30 * Origin: Sox! (305) 821-3317 Live from Hialeah_FL_USA (1:135/71) --------------- FIDO MESSAGE AREA==> TOPIC: 226 WINDOWS ACCESS Ref: E3L00000Date: 03/16/97 From: LEE GERBER Time: 01:51pm \/To: ALL (Read 3 times) Subj: Old & New Hi All, Can anyone tell me if Access 2.0 and Access 95 are able to co-exist on the same hard drive, same partition? Any special set-up tips if they are? I would like to use both versions, as I have found that running some of my 2.0 creations under Access 95 has corrupted portions of the 2.0 database. Any other tips or suggestions would be appreciated. Just recently purchased Visual Basic 4.0, but have not really had a chance to play or learn. Thanks, Lee --- QMPro 1.53 E-mail to lee.gerber@neopc.org or leeg@en.com * Origin: NEOPC BBS Cleveland, Ohio USR V.34+(216)835-5763 (1:157/427)