Micros 3700 SQL Database

[Microsuser]

Hi All,

I am trying to change some datas in the Micros SQL database.
I connected via the DBISQL and logged in with the custom/custom password.

uisng micros.chk_dtl, I found the check I would like to change the amount in it.

The problem is, it tells me Sybase ODBC driver permission denied. you do not have permission to update "chk_dtl"

Can anyone help me to get around it, as I need to change the amount in the check?

Looking forward to hear from the Guru's

 

[MikeRose]

You need to sign in as dba

 

[Microsuser]

Hi Mike,

thank you.

Any idea how I get the login details as dba?

Thanks

 

[pmegan]

Why would you want to change check detail through SQL? It will throw your reports out of balance.

 

[MikeRose]

I began by typing that very question but resisted.