Windows Vista Tips

Windows Vista Tips > Newsgroups > ActiveSync > Pocket Access - Sync to Linked Table?

Reply
Thread Tools Display Modes

Pocket Access - Sync to Linked Table?

 
 
Jason Gyetko
Guest
Posts: n/a

 
      07-08-2004
Is it possible to sync to a linked table within access? I ask because I
have an Access database which has ODBC linked tables to a MySQL database. I
want to be able to sync Pocket Access through those linked tables to the
MySQL database. Any thoughts would be appreciated. Thanks.


 
Reply With Quote
 
 
 
 
Jason Gyetko
Guest
Posts: n/a

 
      07-08-2004
I'm not sure I follow. Right now I have an access database with tables,
forms, reports, etc. This is all fine and good. I then have a PDA which
through ActiveSync, syncronizes a Pocket Access database with my Access
database. I can then maintain my DB within Access and syncronize the PDA
with it so then I'm viewing current data with my eVB programs on the PDA.
This whole process works great for me the way I have it set up now.
Recently I've re-created my tables in MySQL, set up ODBC connections to them
from my Access database (this way nothing has changed except the DB engine),
I can still use my reports and forms within Access without any modifications
yet. My problem is on the PDA side now. I have no way to syncronize the
Pocket Access database through ActiveSync anymore because the linked tables
(within Access) do not show up when I try to configure the Pocket Access
Syncronization tables. I thought I would just be able to use Access (the
linked tables) as a bridge between my PDA and MySQL.

"Albert D. Kallal" <> wrote in message
news:%...
> Well, if you ever used Sql server, Or Oracle, or MySql, or Sybase, then

you
> will be equally disappointed with pocket access.
>
> In all of the above cases, we are talking about database systems. You can
> use sql-server to store data, but sql server, or Oracle, or MySql or any
> database engine DOES NOT have any ability to build forms, or reports.
>
> You can't build a form with Oracle, and you can't build a form with
> sql-server. You can't build a form with MySql, and you can't build a form
> with pocket access.
>
> So, access really is just a condutit, and you have to use embedded visual
> basic to build any forms etc, or use any of the data that is sent to the
> pocket access.
>
> So, really, while most, if not all mainstream database systems do not let
> you make forms, reports etc, using the pocket access "name" is kind of a
> poor choice. And, as far as I know..the product name has been dropped. (it
> should have been called pocket sql server). There is no pocket access
> in the same sense that we have pocket word for example.
>
> Anyway..there is number of good alternatives
>
> Pocket PC Access Database Alternatives
> http://www.oreillynet.com/pub/wlg/3358
>
> The "Missing" Pocket PC apps: Access & PowerPoint
> http://www.oreillynet.com/pub/wlg/3300
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
>
> http://www.attcanada.net/~kallal.msn
>
>

"Jason Gyetko" <> wrote in message
news:...
> Is it possible to sync to a linked table within access? I ask because I
> have an Access database which has ODBC linked tables to a MySQL database.

I
> want to be able to sync Pocket Access through those linked tables to the
> MySQL database. Any thoughts would be appreciated. Thanks.
>
>



 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dear Microsoft - UAC (.png & wmp) issues should be addressed. JSandPC Windows Vista Administration 120 12-02-2008 05:42 PM
Stop Error 0x0000007b Louis LeBrun Windows Vista Installation 17 07-05-2006 10:00 AM
Can't sync MSMoney to Pocket Money David W. Foster ActiveSync 4 07-10-2004 04:24 PM
Connect 2 Pocket PC's to 1 Computer? Scott ActiveSync 1 06-27-2004 04:12 AM
Re: Remote sync with Outlook via WiFi or other alternatives Rob ActiveSync 0 06-17-2004 06:46 PM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59