DB Anywhere Database

• by Tiny Pocket Software
• 
• • Read all reviews (25)»
  • [+]Add your own review

« Back to Overview

Want a compact, powerful, easy-to-use database software? You got one!

DB Anywhere

Features

• Load large tables very quickly
• Easily create and view forms
• Forms can contain Text, Combo or Check Boxes, Labels, Buttons, Images and List Boxes
• Create shortcuts to your tables/queries/forms which make it possible to load DB Anywhere to a specific table query or form when the shortcut is launched
• Program your own event code that is executed when specific events occur. This allows you to create your own database application
• Query Editor and Query Builder (similar to MS-Access query designer)
• Support for variables in queries and form source (allows you to run queries with different values in conditions each time you run the query. Eg. "...where [DateField] =#!day!/!month!/2001#" or "...where [Salary]>!value!")
• In-cell editing, entry-bar edit, large-cell edit as well as Single Record View
• Import/Export to/from CSV
• Quickly and easily filter your data to find what you need
• Quickly access your tables, queries and forms by allowing DB Anywhere to create shortcuts for you
• Auto size column to column data (also, manual resizing of columns)
• Quickly edit time/date fields from date/time selection window
• Find/Replace values in tables
• Zoom in/out of table
• Advanced filter/sorting on table
• Determine Sum/Average/Min/Max values of column data
• Non-destructive field type changes
• Sample databases and help file/manual installed on your desktop computer
• Quick and helpful customer support

You can now create new databases or use your MS Access databases right on your Pocket PC!

Note: DB Anywhere is a standalone database software and does not require Microsoft Access. However if you wish to edit your database data on a desktop computer too, you can use MS Access..

Converting a Microsoft Access Database to Pocket Access Database

• Make sure your .mdb file has one Primary Key. This is required to keep the database synchronized.
• Establish a connection between ActiveSync and your device (for most devices, this would mean to place the device in the cradle and then turning it on).
• On your desktop, click the Start button, and click "My Computer".
• Navigate to the folder containing the database you would like to transfer to your device.
• Select the database file and copy the database file to the clipboard. There are two ways of doing this:
  • Right-click the file and select Copy from the popup menu.
  • Select the file and press the keys Control + C on the keyboard.
• Open the ActiveSync window. From the File menu, select Explore.
• A window will pop up, showing the files on your Pocket PC. In this window, navigate to the Edit menu and select Paste (alternatively, press CTRL + V).
• You will be presented with the tables in the database. Select the tables you would like to transfer to (and/or keep synchronized with) your device.
• If you would like to keep the database synchronized with your device, place a check in the Keep tables synchronized checkbox.
• In the field at the top of the window (Copy the *.CDB file to this location...), type the location on your device where the database should be placed. Note that DB Anywhere will only find databases in the "\My Documents" folder on the device, or the "My Documents" folder on your storage card(s).
• Click OK and ActiveSync will convert and transfer the database.
• Open the Database with DB Anywhere!
• NOTE: If you want to remove the synchronization, Open ActiveSync on your desktop, select Options from the Tools menu, select Pocket Access from the list and click "Settings". From here, you can remove any databases being synchronized.

• Read all reviews (25) »
• [+]Add your own review

Latest Reviews

Limited Query Functions

by Bart Blake   from Gainesville, Florida
on Mar 11, 2007

I have a Laundry service and I use Access to record the weights of the laundry in the container, subtract the weight of the containers, sum the net weights for each customer over a certian time period, and multiply the net weight by the price. This software will not import my Access queries and the query function, as far as I can tell, only allows you to select certian records. It doesn't allow you to perform calculations on them.

Great Program - Easy To Learn

by Bob Murry   from Hannibal, MO
on May 17, 2006

I tried several database programs and this is by far the easiest and fastest to set up a quick form and database. It was also the easiest to use with existing Access database files. The only extra I'd like to see is a desktop companion program to go alonf with it.

Best PPC database out there.

by Britt Park   from Scotts Valley, CA
on Nov 6, 2005

I''ve pretty much tried every available ppc database. DB Anywhere comes out on top. It has first, the best forms designer, beating out abcDB for a close second. It''s db engine provides as good a set of features as any competing product. It''s stable and reliable. The scripting language, though it''s weakest feature, allows you to get pretty much anything you''d want done. I''ve been using it intensively with a fairly complex app with a number of hairy joins and it just keeps working. Highly recommended, if you need a competent well thought out portable relational db.

Read all reviews (25)»