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******@btinte rnet.com