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 1: Line 1:
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.....  
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.....  


*Instruction: How to manually replace local laptop C:\ [[Ccmbd program\ccmdb.mdb]] in the Program folder on local laptop C drive.
*Instruction: How to replace local laptop C:\ [[Ccmbd program\ccmdb.mdb]]
#Close out of Access program on laptop.
#Close out of Access program on laptop.
#*Go to: the [[Regional Server]]/Program/Master and '''manually copy''' ccmdb.mdb from this folder.
#*Go to:[[Regional Server]]
#*Go to: local laptop, find C:\ [[Ccmbd program\ccmdb.mdb]] folder and '''paste''' in copy.  
#*find:  '''Program''' folder
#*run news and backup
#*then find: '''Master''' folder
#on local laptop C: drive, go to ccmdb_'''data''' folder. [[Ccmdb data\ccmdb.mdb]]
#*double click to enter into the Master folder and see ccmdb.mdb
#*open ccmdb.mdb with usual password.  IMPORTANT NOTE: will only see L_files.  
#*right click and select '''COPY''' ccmdb.mdb from this folder.
#*at the topof the screen tab, click on '''TOOLS'''
#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'''
#Go to the Desktop on laptop.
#*Click on '''[[News and Backup]]'''
#on local laptop, go to C:\ ccmdb_'''data''' folder. [[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 '''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 Access by clicking the "X" in the top right corner.
#on local laptop C:drive, go to [[Ccmbd program\ccmdb.mdb]] folder.   
#on local laptop, go to:  C:\[[Ccmbd program\ccmdb.mdb]] folder.   
#*log back into ccmdb.mdb with usual password. Problem should be resolved.
#*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.





Revision as of 17:17, 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 folder. 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 TOOLSmenu.
    • select Database Utilities
    • select Compact and Repair Database
    • close out of Access 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 your Access data file.


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