Database Access in limited user account

[Ranjeet_Singh]

I have made an application in which I am communicating with database. 

Let me explain about my application first.

1. Application starts and it asks for user name and password

2. After successful login data reading or writing from /to database.

All this information whether its data or user name or password, I am storing in same database but in different tables

Now If I login from limited user then I am able to login by entering user name and password but later I am not able to read/ write to database, but If I login from admin accout then everything runs smoothly.

This happened recently and I am sure this is permision issue..

[Ranjeet_Singh]

I am using datalink for accessing database. May be I need to change the permission in limited account

But if this is the case then why my login is working? It shouldn't work also 

[rolfk]

What database engine are you using? What Database driver and version? How is the security in the database server configured? Who maintains the database, yourself or an IT departement (who may have decided that the previous access configuration was way to insecure)?

[Ranjeet_Singh]

SQL. There is no security. In other PC this works fine in limited users.

There is no IT.

What else can be casued?

[rolfk]

SQL?? MySQL, MS SQL Server, Oracle SQL, PostgreSQL, SQLLite, .......

ADO driver you use?

versions of SQL server and ADO drivers?

There is obviously some security! If there wasn't any you would not get andy trouble to connect to your server with a normal user account.

[Ranjeet_Singh]

MS SQL, Server V 7.0. I am sure this is not a security and version issue. Becasue in same PC it was working before and now it doesnt