Hi there. We are experiencing a serious error on one of
our machines connecting via an MS Access 2000 ADP
database to SQL Server. The problem is that when I open
the Access project (as any user) the database shows as
disconnected. When the connection window is opened
clicking on 'Test' reveals a successful connection, and
clicking on OK closes the connection window with no error
but the database remains as disconnected.

What is very strange about this is that this affects all
users on that machine, including the domain administrator
account which I gave total permissions to everything for
testing this sort of error! It also only affects that
machine. No others are affected.

Where it gets stranger is that even though no tables,
views or sps are showing, if I open one of the forms that
is linked directly to a table I get at the data! But the
ones bound to stored procedures come up with "Runtime
Error 2580". This is unaffected between 2 versions of the
file I created - one with the sps just labelled with
their names, the other with the prefix dbo. in front of
them.

The machine in question is running Windows 2000 Pro SP2,
a proprietry Xerox product, which is based on Oracle and
Photoshop. You might think that Oracle was the problem,
but we have two of these machines and the other one works
fine. To make matters even odder, the database just
stopped working one day, having been fine before -
nothing was installed or uninstalled. We have reinstalled
office to no effect.

Any suggestions??!

Cheers,

James Griffith

Well ... what do you know. I've just come up with this same problem.
One thing I did was prefixed my properties with dbo eg. dbo.sp_Test.
The other thing I came across was this link which helped out in the
case I ran into where 1 user was okay and another had problems with the
Open Error.

http://support.microsoft.com:80/supp...8/24.asp&NoWe-
bContent=1


--
Posted via http://dbforums.com