Need a Database

[Avtek]

I am really new to the Axim community and the frist thing I need to get started is a database that I can use to exchange data from the desk top to the Axim 51. Can some one lead me in the right direction?

[Mahstah]

Files and data can be transferred to the Axim via Activesync. What type of information are you looking to sync? Are you writing software to sync SQL or Access data between a server and PPCs? Please elaborate.

[Avtek]

I want to set up a database to allow me to keep information I use at work. Ie time started, equipment #, Comments, parts used, time completed. Is there something out there I can do this with?

[Mahstah]

You are describing an Excel spreadsheet. Sheets of tables with cell referencing are essentially a database but without the hassle of programming.

[enquerir]

Hi Avtek,

The key to choosing a database application- is the number of records and $ too. Here is a simple guide:

1. How many records are you expecting?
If you're tracking "your info provided" DAILY, your records (dates) will be in rows. Your "time started, time completed, equipment #, Comments, parts used", will be in columns.

Pocket Excel
16384 rows (records) per sheet.
3 sheets per file (table).
Total 49152 records (need to deduct a few rows for column headings).
49152 / 365 days = 134 years

(134 years!!! You'll be in the Guinness Book of Records ... the oldest person on earth; quote from my professor)

Pocket Excel is handy for a small repair shop inventory tracking.
If you need to track more than 134 years, create another file.
E.g. You are repairing my Dell Axim X51V everyday.
Filename: MyName_x51v.xls
After 134 years, the file ran out of rows. So, create another file MyName_x51v_2.xls
PE can be customized w/ user interface ... buttons, menus, softkeys. You can cross-reference (link) files/tables, rows/records, or columns/items.
To track your changes & if you're not familiar w/ customizing Excel ("programming"), you can Cut & Paste (insert row) from Pocket Excel to desktop Excel. The desktop Excel will be your Master copy; it grows/expand as the no. of records increase. You can track (Cut & Paste) daily, weekly, or monthly.

Pocket Accesss
If you need more than 50,000 records, this is the next level up.

SQL: It is unlikely you've an IT dept otherwise you'll be talking to them ... (not an insult, you know what I mean)

Pocket Excel & Acess comes w/ WM5.

There are more than 1 way of getting it done depending on $, how comfortable you're w/ the application ...

If you need clarification, ask.

[enquerir]

EDIT:

I just realized that Pocket Access might not come with WM5. I don't remember how I got mine. It could've come with my (old) iPaq 3650 & 3850 package. It is good for small business app where reasonably complex DB structure is required.

[vicezilla]

Hi Avtek

If it is a true Database application that you are looking for, check out HanDBase for Pocket PC, by DDH Software. I've been using it for years on both my Palm and Pocket PC powered handhelds. It is extemely powerful and customizable, and personally in my opinion a lot more intuitive then MS Access. I work in an IT department, and use the application constantly everyday, it has never let me down.
Check them out, it may just be what you are looking for.