Link Servoy with Access Accounts

Classic Servoy
1

Has anybody any experience with linking Servoy to data held within Access Accounts (http://www.access-accounts.com)

Access Accounts is a UK based company providing accounts software which runs on MS SQL server as a backend.

I know that the connection to MS SQL Server is not an issue - I am more interested in whether Access themselves are open to allowing appropriate permissions to get at the data ?

Cheers
Harry

2

Hi Harry,

Have you asked Chaim Bacon? I know he was investigating this a while ago.

3

You may want to try locating Servoy user “bubba”. I believe he is listed as one of the Access North American Partners.

4

Thanks for the input, chaps

I have had a PM from another forum member who is actually using Access Accounts w/Servoy :D

I’ll take it up with that person as my first stop…

Cheers
Harry

5

Hi Harry,
I know it was a while ago, but what was the outcome of this, as I might have a client that is using Access that might want Servoy to link to it?

Thanks,
Rafi

6

Hi Rafi

Client did not go ahead in the end

It is doable and will work but I got as far as the theory and not the practice !

You may want to try Ed though as I recall that they did have it set up

Cheers
Harry

7

Harry Catharell:
Hi Rafi

Client did not go ahead in the end

It is doable and will work but I got as far as the theory and not the practice !

You may want to try Ed though as I recall that they did have it set up

Cheers
Harry

Thanks.
I assume you mean Ed Callaghan…

Cheers

8

Hi Harry

Yes I did this a while back.

From memory there were 2 ways:

  1. Get the Transaction Broker application from Access - this basically allows you to synch data between access and another SQL database. We used to use this with Access based on the MS SQL database (rather than the cheaper Omnis option) and also we had Servoy running of MS SQL database. You can do lots of cool stuff with this, including auto updating records in Access from your Servoy solution and writing logs of success/failure transactions which can be read by your Servoy solution.

  2. I have not tried this, but if you get Access based on MS SQL, you can probably connect directly to the Access tables - although if you do anything other than read these tables (i.e. if you write to them) then you will bypass any validation procedures and could screw up your Access data.

Hope this helps

Chris

9

Hi Chris,
it was me asking again about this.

I thought one might be able to access the Accounts systems tables directly if they are using the MS SQL version, but obviously wouldn’t want to bypass Access’ validation etc.
The ‘Transaction Broker’ program sounds useful.

Thanks
Rafi

10

Hi Rafi

I am not sure if they still offer TB or if it has moved on over the last few years.

The version I used was not too bad though - you could schedule automated updates from Access MS SQL tables into other MSSQL tables within your Servoy solution. But of course you have to make sure the Servoy UI gets updated so it knows about these updates too.

Talk later
Chris

11

Thanks Chris.
I’ll look more into it if/when things progress…

Rafi