Strange behavior

[Cory J. Laidlaw, Beyond01.com]

I have been using Access 2003 with SQL Server 2000 (SP4) Standard edition.

In multiple envirnoments, access appears to behave very strangely.

When clicking on a table, it does not open, but instead returns the message
"the stored procedure didn't retrun any records" even though I am in the
Table tab.

It also does not allow me to open tables in design view. no error message,
just ignores the click. I have rebooted both my workstation and the server.
no help.

Anyone else experiencing this? Any help would be appreciated!

Thanks!!

Cory

 

[Belu33fr]

Hi,
I had this on one worskstation, this desappeared when I reinstalled Access
(not repair) and put all SP.
Hope it will be the solution
Luc

 

[Cory J. Laidlaw, Beyond01.com]

Hello Luc,

Thanks for the advice. I found the answer to the problem.

I was scripting from the 2005 SQL Server management studio on a SQL 2000
server. It looks like it doesn't like all of the extended properties it can
create. By using the sql 2000 enterprise manager, the problem appears to have
subsided.

Thanks

Cory

 

[Guest]

Not experiencing the issue.

<Cory J. Laidlaw>; "Beyond01.com"