-------------------------------------------------------------- T.C.M. F.A.Q. -------------------------------------------------------------- QUESTIONS --------- 1. How do I properly setup TCM over a network? 2. TCM works on most computers, but on one computer it errors out indicating that common VBA commands such as RIGHT(), or MID() are not recognized. How do I fix this problem on that computer. 3. When I run TCM, the TCM_Loader.mdb file errors out indicating "File not found: 'C:\Program.mdb". 4. Why do I get record locking errors when I have several concurrent users? How do I fix this? 5. Why does TCM 1.04 Bld 1 cause a bug where no reports show up on the computer that ran the upgrade patch (on the TCM_Data.mdb file), and more importantly, how do I fix it? -------------------------------------------------------------- ANSWERS ------- 1. How do I properly setup TCM over a network? TCM is like any application in that it should be installed on every client computer on which it will be run. Do *not* install TCM one time on a network and then point shortcuts from several client computers. This is slow, leads to confusion because preferences are not properly saved, etc. Here are the proper setup steps for TCM: 1) Run the TCM.exe setup file and install all TCM files onto a client computer. 2) Run TCM, answering that you want to create a new Bug Project Database. 3) Save this new project database to a centrally located server and path. Be sure that this path has full permissions for all users. 4) Login as "Admin" with no password. 5) Go in and setup the Project Properties via the Admin Utilities subform. 6) Go in and setup all relevent Reference tables such as the users table, and the app locations table via Admin Utilities forms. Be sure to set yourself up as the administrator (check the box). 7) Once the project database is setup, now you can go around to all client computers and install the Buggit application (TCM_Loader.mdb, TCM_App.mdb, TCM_Data.mdb template, all supporting help files, etc.). 8) Run TCM from each client computer, selecting the "Open Existing TCM Database" option the first time on each. Hereafter, TCM will remember the default project database. -------------------------------------------------------------- 2. TCM works on most computers, but on one computer it errors out indicating that common VBA commands such as RIGHT(), or MID() are not recognized. How do I fix this problem on that computer. This confusing problem occurs when Microsoft Access loses a reference. To fix the problem, do the following: 1) You have loaded TCM onto this trouble machined, and you got the error above. 2) Go to this machine, and open the TCM_App.mdb; but be sure to hold down the shift-key while opening the file. This will prevent the Startup Form from firing off. 3) Once open, click the Modules tab. 4) Double-click and open any code module. 5) While in the module, click the menu item Tools | References. 6) In the dialog that pops up, you will right away see one of the items labeled in all caps: "MISSING: " and then the reference object's name. 7) Uncheck the MISSING object. 8) Click Ok button. 9) Re-run Buggit; MS-Access is now fixed. -------------------------------------------------------------- 3. When I run TCM, the TCM_Loader.mdb file errors out indicating "File not found: 'C:\Program.mdb". a) Ahh, Version 2.X Build X fixed this for NT4 computers. b) I have had this problem occur many times when I install multiple versions of Access on a machine and I change the file associations in View->Option->File Types of Explorer, etc. It turns out that this inadvertently removes parameters so that what gets passed to msaccess.exe is incorrect. Here is the fix that has worked in our office: 1) Open Windows Explorer. 2) Click View->Folder Options menu item. 3) Click the File Types tab of the dialog. 4) Scroll down and highlight "Microsoft Access Database" -- should be extension of MDB. 5) Click Edit button. 6) Highlight Open option, and click second Edit button on this dialog. 7) Be sure that it looks something like this (path different, I put in the \...\ to make it fit in email window): C:\Program Files\...\Office\MSACCESS.EXE /NOSTARTUP "%1" Notice the /NOSTARTUP, and the "%1". Be sure to include them exactly as is, including the quotes. Somehow, missing these will make mdb's passed to Access fail when the path to the mdb has spaces. -------------------------------------------------------------- 4. Why do I get record locking errors when I have several concurrent users? How do I fix this? Be sure that every form has its Data | Record Locking property set to "No Locks". At one point, I set the forms to Record Lock = "Edited Record", but this caused all kinds of locking to occur for users. So, reset back to MS-Access default setting of "No Locks". -------------------------------------------------------------- 5. Why does TCM 1.04 Bld 1 cause a bug where no reports show up on the computer that ran the upgrade patch (on the TCM_Data.mdb file), and more importantly, how do I fix it? This occurred because I moved the REF_Reports table over to the TCM_App.mdb from the TCM_Data.mdb file. Unfortun- ately, the user is asked to pick an existing database before the patch is run. This results in the new REF_Reports table being overwritten by a linked table of the same name just before the patch deletes the old one to which the link points. The fix is to re-run the TCM Setup.exe to reinstall the same build of TCM onto the machine. This will overwrite the bad TCM_App.mdb (with correct version of table REF_Reports). Sorry about this hassle. --------------------------------------------------------------