- RT @alevit Working Extended Hours? You're Not Alone: http://t.co/Fl1OFWJq via @intuitquickbase #worklifebalance
QuickBase Desktop Simplification…
QuickBase Desktop is a Microsoft Access database that can synchronize data between QuickBase and a computer that has Microsoft Access installed. Today it is used by those that want to…
- Integrate QuickBase data with data in other systems
- Consolidate data for centralized reporting using other business intelligence technologies (e.g. Crystal Reports)
- Backup QuickBase data onto local computers
But sometimes QuickBase Desktop can be hard to manage when applications are large because the synchronization can take a long time. Here’s a “best practice” that Claude von Roesgen, the father of “QBDesktop”, came up with…
- Create a new role that can only see those fields that you must synch.
- Share the applications with a new user using the new role.
- Rebuild the QBDesktop database using that user’s credentials and the new role. This will reset which fields QBDesktop syncs.
- Setup the daily synch using the new user account.
By using this technique we were able to take an application that had ~300 fields and over 100K records and we cut the time it took to complete the daily synch dramatically while also improving reliability. We did this by creating a role that didn’t have access to about 90% of the fields (we took out the built-in fields, formula fields, lookup fields, summary fields and report link fields) because we only needed to backup the raw information in the table. Claude realized that most people don’t need to backup the vast majority of the fields in a QuickBase and he came up with a great way to easily implement it…thanks Claude!
I hope you find this helpful…
Peter F
About Peter Fearey
Related Articles
-
http://www.tower-defense-game.com/ Tower Defense
-
http://www.tower-defense-game.com/ Tower Defense
Alexandra Levit’s goal is to help people find meaningful jobs - quickly and simply - and to succeed beyond measure once they get there. Follow her @alevit.
Alison Green writes the popular Ask a Manager blog where she dispenses advice on career, job search, and management issues. She's also the co-author of Managing to Change the World: The Nonprofit Leader's Guide to Getting Results and former chief of staff of a successful nonprofit organization, where she oversaw day-to-day staff management, hiring, firing, and employee development.
Anita Bruzzese is a syndicated columnist for Gannett/USA Today on workplace issues and the author of “45 Things You Do That Drive Your Boss Crazy.” She has been on the Today show, and quoted in publications such as O, The Oprah Magazine, Glamour, Self.com and BusinessWeek.com. Her website, 45things.com, is listed on the Forbes top 100 websites for women.
- Alison Green - Ask a Manager:
Ugh, yes, nail clipping! And calling unnecessary meetings! - CPAlady:
Also nail clipping
- Sbelcourt:
Is there a way you can set your ipad app for Quickbase to open in Full Site screen versus the mobile... - Anonymous:
@Chase: I don’t know what’s worse – a ridiculous comment like that or the standard... - Anonymous:
@Tom S, is that you? I actually quote you in my chapter on passion in my book, New Job, New You. Thank...
