Integrating online payment system to Ms access. (1 Viewer)

[pekajo]

Hi,
Has anyone been able to Integrating online payment system to Ms access?
Regards
Peter

 

[CJ_London]

Suggest explain in a more detail what you are wanting to do

 

[GPGeorge]

Perhaps include a bit of info on what you've already tried.

 

[sonic8]

Has anyone been able to Integrating online payment system to Ms access?

It's the third time you ask this question without providing much detail.
Without you providing further detail on your requirements and intentions, it is unlikely that you will get a more substantial and suitable reply this time.
Your previous posts got some short pointers to possible approaches. - What do you think about those?

 

[The_Doc_Man]

Peter, your problem will be that unless you are using an active SQL engine (SQL Server, SQL Server Express, ORACLE, SYBASE, etc) as the back-end for your activity, you will not succeed. The native Access back-end file doesn't integrate well with web transactions. This is because of TCP/IP protocol sub-sets. Access uses SMB protocol (Server Message Block) which is a TCP-sub-set protocols that include the concept of continuous sessions with sequentially numbered individual update transactions. Web online services start from the UDP-sub-set protocols where a session is more tenuous and relies on the use of cookies to maintain context. I know of no cases where someone has successfully used Web protocols on an Access back-end file. However, you COULD write something that used an Access front-end to talk to an active SQL back-end, and web apps also can talk to active back-ends, both through some variant of ODBC protocols. The part that web users see would not be the part that Access users would see.

 

[Pat Hartman]

To put it simply, the Access FE runs inside the the security perimeter of your LAN and the web app runs outside of it so usually the interaction is batch. If you want a live interaction, the web app has to be able to write to a file inside the security perimeter or the Access FE has to be able to periodically read the database outside the security perimeter AND the Access FE has to be running constantly using a timer so that it is constantly checking for data from the web app in the file the web app will have to post to.

 

[Gasman]

O/P has a history of posting this question and never responding to any replies?.

Integrate online payments

Hi, Has anyone managed to integrate and online payment site with MS Access or will I have to just download. The data base is local. Thanks for any help Peter

www.access-programmers.co.uk

Making payments online

Hi, Is Ms Access able to connect to an online payment platform that will integrate with MS access, which is not online, and if so can you give me some leads on how it works Thanks Peter

www.access-programmers.co.uk