By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,676 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,676 IT Pros & Developers. It's quick & easy.

Importing Sage Payroll Database into Access

P: n/a
Hi all,

Wondering whether you can anyone help me. We have Sage Payroll (and
accounting/payroll software), which has a MS Access database where the data
is stored.

Now I want to access the data in this database but whenever I do (without
using the Sage payroll client application) I get a permission problem. Now
I have the correct username and password, and I tried importing it in a new
Access database, but with no luck. Maybe I'm doing something wrong?

I even tried setting up an ODBC connection in Windows to the Sage Payroll
database, with the correct login credentials, but still no luck.

The reason I want to have read only access to the Sage Payroll database is
that the reporting tools are a little limited, I want to write some
applications which can generate more complex and flexible reports, but using
the Payroll database as the source of data.

Any advice/help will be great! Thanks in advance!

Steve.

ch******@btinternet.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 12 Jan 2005 22:22:53 +0000 (UTC), "cheungs7"
<ch******@btopenworld.com> wrote:

What did Sage have to say when you asked them? It seems they are
making an effort to keep you out.

The username/password to logon to Sage is not necessarily the same as
is needed to link to the tables.

-Tom.
Hi all,

Wondering whether you can anyone help me. We have Sage Payroll (and
accounting/payroll software), which has a MS Access database where the data
is stored.

Now I want to access the data in this database but whenever I do (without
using the Sage payroll client application) I get a permission problem. Now
I have the correct username and password, and I tried importing it in a new
Access database, but with no luck. Maybe I'm doing something wrong?

I even tried setting up an ODBC connection in Windows to the Sage Payroll
database, with the correct login credentials, but still no luck.

The reason I want to have read only access to the Sage Payroll database is
that the reporting tools are a little limited, I want to write some
applications which can generate more complex and flexible reports, but using
the Payroll database as the source of data.

Any advice/help will be great! Thanks in advance!

Steve.

ch******@btinternet.com


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.