Jump to content
  • 0

Sharing Caspio with Access


dblake
 Share

Question

I'd like to have Access 2003 use a Caspio table or view (principally for generating calculations).

It would need to be dynamic. In other words, importing the table into Access wouldn't do it. I'd like for Access to be able to regularly use the Caspio table.

Am I dreaming?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Thanks for the tip. I've made a lot of progress. I'm successfully calling the Caspio table with PHP and MySQL. (I've ditched Access).

Problem I'm running into is that Caspio stores dates as mm/dd/yyyy and sql wants yyyymmdd.

Any workaround ideas?

Link to comment
Share on other sites

  • 0

I would think the most important step in using this program, perhaps, may be to import an existing Access database, and this would be an easy topic to find a solution for if it doesn't work, however, I simply can not (find a solution), at least not here.  No support on weekends? Really? So for those of us who have other jobs (other than computer related) we simply have to decide which is most important, trying to figure out how to make this program work during the week when I should be working on my work job, or taking time to call back after 11:00 a.m. Mon-Fri.  I suppose my "approval" for this post won't be possible until Monday, or since Monday is a holiday(MLK), Tuesday?  Gee, that's 3 days of my free trial and my time completely wasted.  Oh well.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...