Re: Access ADP, filter lookup & SQL Server 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What exactly do you mean by 'stepping through'? I've followed the events
through the trace that is output by SQL Profiler. That is how I know a User
account does not insert records into the temporary table whereas my account
does.

Originally all our users were mistakenly set up with Active Directory
accounts that belonged to a group that had administrator rights and they
could do the filter by form no problem. Once we discovered our error and
removed the Users from the administrative group the problem with the filter
by form rose it's ugly head.

If you use XP_LOGINFO on SQL Server it shows the Users privileges as 'user'
whereas it was 'admin' before they were removed from the erroneous Active
Directory group.

AkAlan wrote:
Have you tried stepping through the event to see exactly where the error
occurs?

Hi - I have an Access ADP front ending a SQL Server 2000 database. This has
been working fine for some time but I now have a problem that I have spent
[quoted text clipped - 26 lines]

Anyone got any ideas??

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Access ADP, filter lookup & SQL Server 2000
    ... your text and combo boxes and make sure all users have rights to them. ... account does not insert records into the temporary table whereas my account ... could do the filter by form no problem. ... by form rose it's ugly head. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Receive Error: 17805 Invalid buffer received from client
    ... You get capture exceptions using the ... What you filter on depends more on your system. ... least filter out the applications SQL Profiler and SQLAgent% ... >to specify in the trace to identify the transaction that is causing this ...
    (microsoft.public.sqlserver.clients)
  • Re: Profiler logging SP:Starting hundreds of times for one SP
    ... However, when we trace it using SQL Profiler, it reports ... >> I realise that we can filter out the duplicates by only capturing ... > It looks like you have a function on a column in the query. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Insert that return Identity, any samples
    ... Turn on the SQL profiler and look for object access denied to see what ... account is running and what it is getting denied on. ... >I check by biztalk app service, and it is associated to my user account ... This account already has permissions on my sql ...
    (microsoft.public.biztalk.general)
  • SQL Profiler doesnt filter
    ... Using SQL Profiler, I can not filter events by criterias which use "Like"! ... For example if I put "rpt" as "application name like" filter, ...
    (microsoft.public.sqlserver.programming)