Access Project Connection

G

gmead7

I have an Access Project .adp front end and SQL Server 2000 back end with
about 15 users scattered throughout the US. All have been able to connect
except 1. This user has Windows 2000 and Office 2000.

I checked her connection in Access Project by going to the Data Link
Properties box and Clicking Test Connection - The result gives you the happy
"Test Connection Succeeded".

Then, I leave and try to look at some tables, views or stored procedures and
nothing. I double checked (even deleted and re-did) the user permissions in
SQL Server to make sure that is not the problem so I'm relatively confidant
that it's not a permissions problem.

I'm stumped as to why I can connect, but am unable to access anything from
SQL Server. It seems like it allows a brief connection (like is done for the
test), but for any type of load, it poops out (for lack of a better tech
term). (You will set in the database window in Access "Name do
database(Disconnected):Database" after trying to look at something linked in
SQL. When you run a report or form, you get a report or form does not exist
response.

Could this be a firewall issue? Is there some component that needs to be
installed in Office 2000? Any leads and suggestions are appreciated.

thanks, George
 
Top