user 'null' error

[vbjohn]

I get a user 'null' error. When I do this...

* = Errors on this line.

sSql = "DELETE FROM dbo_MemberMaxNonMetro"
* CurrentDb.Execute (sSql)

When I run the app. it works fine. But when I run it on the end users comp. It errors out. We have the same DSN Setup and everything else. What is going on?


John-

 

[John.Woody]

Shouldn't it be

sSql = "DELETE* FROM dbo_MemberMaxNonMetro"
CurrentDb.Execute (sSql)

You have to tel it whether to delete everything or just a couple of fields.

 

[vbjohn]

nope...

That option did not work. This is what the error said.

Connection Failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection.

To view the error please look at the attachment.

I think that the reason is bull because on the end users computer the connection is fine.


John-

 

[John.Woody]

You could try

sSql = "DELETE* FROM dbo_MemberMaxNonMetro"

Docmd.setwarnings false
Docmd.Runsql sSQL
Docmd.setwarnings false

 

[ghudson]

I do not use SQL but it sounds like your user does not have access rights to the table for deleting records.

Why not be more direct with your code and only use this one line to delete your records?
Currentdb().Execute "DELETE * FROM dbo_MemberMaxNonMetro"

Can the user create a new delete query and delete the records from their computer? That should test if they have rights to the dbo_MemberMaxNonMetro table?

use John's setwarnings suggestion to suppress the warning messages about deleting records.

HTH

 

[vbjohn]

ARGH!!!!

Since last Thursday, I had no problem running any linked table in Access from my computer.

Now I am getting this RETARDED ERROR:

Connection Failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection.

I have full Administrator Rights to connect to the database. How can I get the administrator signon and login without having to keep on signing in all the time? In my last version of Access I could do that but now I can not.


ARGH!!!!!! I am starting to hate access....