SageForum for UK versions of Sage 50- Help and support.

Oh ok, sorry - you're using Sage Payroll. Didn't realise.

I don't use Sage Payroll myself so don't know much about it but maybe this would be useful?

http://reset-passwords.yolasite.com/sage-payroll.php

So how do you normally log in to use Sage then? Have you forgotten your password or something?

Bruce -
Still waiting for an opportunity to upgrade the dll - will keep you posted.

leejayd -
You should just be able to use your username and password as you would if you were logging into the Sage application.

Hi Bruce
Sorry for the late reply, I've been away for a week.
Thanks for the suggestion, I'll give that a go today and see if it makes a difference.

Cheers!

Andy

Hi Bruce

I'm viewing Sage's audit trail in Access and I can see all the transactions that have been added today so I'm positive it's the correct data.

I did wonder about the DSN cached passwords too.
So I created a new user in Sage and created a new DSN on my PC from scratch and never typed the ...

Hi Bruce

Yeah, Sage lets me log in fine using the username and password, and it won't let me log in with a blank password.

But still the ODBC connector lets me connect to the data using only the username.

weird....

Hi Bruce

Thanks for the reply.

I can add a new user in Sage 50 and my ODBC connection recognises the new user, so I don't think it's pointing at a different data set - unless I've misunderstood what you mean.

I wondered whether it was a file permissions problem but if a new user can be created I ...

Hi, I'm building a utility for a customer that involves taking data out of Sage 50 using Sage ODBC. The customer has a single user account on Sage 50.

Here's the strange thing. I can connect to the Sage data files with no problem using, for example, MS Access and ODBC - but it lets me connect using ...