4 replies to this topic

[Gros Blaireau]

Hello,

Imagine this case : We have a shop, a real shop, in the city. We have a stock. We use IP.Nexus to sell online.
We have the same stock for the real shop and the virtual shop.

How to connect IP.Nexus and the stock in Access ?

[Robulosity2]

I'd imagine that you could just export the database and assign values to the sql file in access so your accounting/billing application can understand it..  I do not think you can push info from access > nexus

[.Peter]

Yeah I'd imagine not.. especially because Access is Microsoft and .net based and Nexus is written in PHP... it'd be pretty tricky to get the two to talk... even MSSQL and MySQL-wise... big difference.

[Robulosity2]

.Peter, on 07 March 2011 - 05:34 AM, said:

Yeah I'd imagine not.. especially because Access is Microsoft and .net based and Nexus is written in PHP... it'd be pretty tricky to get the two to talk... even MSSQL and MySQL-wise... big difference.

Well, SQL/MySQL is still text based and what he'd need to do is on the Database level not the UI level, even than I'm sure a connector could be written

[Mat B]

I can think of several ways to do this - none of them are "out of the box" though, you would need to do some development.

Personally, I'd be dropping Access like hot potatoes (or at least migrating the data to SQL Server and setting up the Access DB to use linked tables to access the data).  What I think you could do, is as I mentioned migrate your data to SQL Server and linked tables, and create a basic web service to receive "orders" from IP.Nexus using custom actions.  Once an order is received, you could then push it to your simple web service which would merge it with your POS data.

As this is pre-sales, I'm not going to go into specifics, but suffice it to say that it, like much anything , is possible.