Troubleshooting: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 14: Line 14:
#Go to the Desktop on laptop.
#Go to the Desktop on laptop.
#*Click on '''[[News and Backup]]'''
#*Click on '''[[News and Backup]]'''
#on local laptop, go to C:\ ccmdb_'''data''' folder. [[Ccmdb data\ccmdb.mdb]]
#on local laptop, go to C:\ [[Ccmdb_data\ccmdb.mdb]]
#*double click to open ccmdb.mdb with usual password.  IMPORTANT NOTE: will only see [[L_files]].  
#*double click to open ccmdb.mdb with usual password.  IMPORTANT NOTE: will only see [[L_files]].  
#*at the very top of the Access program screen, click on '''TOOLS'''menu.
#*at the very top of the Access program screen, click on '''TOOLS''' menu.
#*select '''Database Utilities'''
#*select '''Database Utilities'''
#*select '''Compact and Repair Database'''
#*select '''Compact and Repair Database'''
#*close out of Access by clicking the "X" in the top right corner.
#*close out of C:\ [[Ccmdb_data\ccmdb.mdb]] by clicking the "X" in the top right corner.
#on local laptop, go to:  C:\[[Ccmbd program\ccmdb.mdb]] folder.   
#on local laptop, go to:  C:\[[Ccmbd program\ccmdb.mdb]] folder.   
#*double click to log into ccmdb.mdb with usual password.  
#*double click to log into ccmdb.mdb with usual password.  
#*Problem should be resolved.  The Access program file should now be realigned with your Access data file.
#*Problem should be resolved.  The '''Access program''' file should now be realigned with '''Access data''' file.





Revision as of 17:21, 2010 October 13

when opening Access CCMDB.mdb, cannot view dropdown list in labs, or pharm or even the DX codes. Weird things in note section......to name a few things. Access has seized up on local laptop for reason unclear.....

  1. Close out of Access program on laptop.
    • Go to:Regional Server
    • find: Program folder
    • then find: Master folder
    • double click to enter into the Master folder and see ccmdb.mdb
    • right click and select COPY ccmdb.mdb from this folder.
  2. On the Regional Server go back to Program folder
    • find the specific Hosp_Loc PROGRAM folder that needs the update
    • double click to enter into the file folder
    • right click and select PASTE
  3. Go to the Desktop on laptop.
  4. on local laptop, go to C:\ Ccmdb_data\ccmdb.mdb
    • double click to open ccmdb.mdb with usual password. IMPORTANT NOTE: will only see L_files.
    • at the very top of the Access program screen, click on TOOLS menu.
    • select Database Utilities
    • select Compact and Repair Database
    • close out of C:\ Ccmdb_data\ccmdb.mdb by clicking the "X" in the top right corner.
  5. on local laptop, go to: C:\Ccmbd program\ccmdb.mdb folder.
    • double click to log into ccmdb.mdb with usual password.
    • Problem should be resolved. The Access program file should now be realigned with Access data file.


--TOstryzniuk 17:08, 13 October 2010 (CDT)