OneSource System Administration

1	Access How To's (2003, 2010, 2013, 2016, 2019, Office365 / Office 365 and Microsoft Office ) Updates, Version Info, How To's, HotFixes, Etc Getting More Information About Access (Bugs & Bug Fixes) Access Forever bugs, tools, events How to Compact / Repair / Decompile How to Decompile Open Start > Run > then type: msaccess.exe "...full path name\database name.mdb" /decompile Then press…
2	Access How To's (for Administrators) To Create a Trust Center for Microsoft Access: Open access and from the File menu click Options. Then Click Trust Center Then click Trusted Locations Then click Add new Location and browse to the folder OneSource folder. Select it and then check Sub Folders…
3	Access How To's (for Users) How to Customize the Look and Feel of Access 2010/2013 HIDE or UNHIDE Ribbon Tabs Option 1: File > Options > Customize Ribbon (Check or Uncheck the tabs you want). SHRINK the Ribbon tabs (when not in use) Click on the small DOWN Arrow (in the top right…
4	Browser How To's ( Internet Explorer , Chrome , Firefox ) How to Disable (Non Admin) Users from Using a Browser on your Server Note: This is a simple method, but it does require that you think of and find all possible browsers on your server. Login to the Server with Admin rights. Make sure all your normal (non…
5	Bullzip Print Driver - Development Notes How the Bullzip driver is integrated with OneSource and what steps the process goes through when printing. OneSource Setting: Select 'Global' Preference Type in 'Company Setup and Preference' form. Select 'Default PDF Printer' as 'BullZip' (In 'General' tab)…
6	Excel How To's List of Excel Keyboard Shortcuts: http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx Charting Training: https://www.udemy.com/course/advanced-excel-charts-graphs/?utm_source=youtube&moon=IAPETUS1470&utm_medium=udemyads&utm_campaign=NEW-YT-PROS-PROF&
7	General Information About Zebra Printers Selecting the Right Zebra Printer This article explains a lot about the various types of barcode printers and some of the pros/cons of each 'type': http://www.zebra.com/id/zebra/na/en/index/resource_library/white_papers_abstracts.abstract.L2NvbnRlbnQvemVicmEvbmEvZW4vZG9jdW1lbnRsaWJyYXJ5L3doaXRlcGFwZXJzL&
8	Gmail How To's Gmail Mail Server Settings SMTP Host: smtp.gmail.com. SMTP Port: 587. SSL Protocol: OFF. TLS Protocol: ON. SMTP Username: (your Gmail username) ... POP3 Host: pop.gmail.com. POP3 Port: 995. TLS Protocol: ON. POP3 Username: (your Gmail username) ... POP3 Host:…
9	How do I check to see if any users are still in any files on my file server before rebooting? The OneSource company data file is typically located on a file server. To prevent loss of data or file corruption, it is important that the server not be shut down or rebooted while other users are connected to the server. To double check which users are…
10	How do I tell who is logged into my server? Right-click on the My Computer Icon and select Manage . ( Note : You can also click Start , Run , and then type CompMgmt.msc in the field and press OK ). In the left hand pane, click on the + sign next to the Shared Folders icon. In the left hand pane, click…

...