Linked SQL Server Table Won't Open

I have a linked SQL Server 2005 table in an Access 2007 front end accdb and when I try to open the table, the system just hangs up with the hourglass and the table does not open. This is a new tale that I recently upsized after creating it in Access 2007. My other SQL Server linked tables open fine.
paulmcneilAsked:
Who is Participating?
 
paulmcneilAuthor Commented:
I'm all set. Just had to set the Primary Key in the table design. Thanks!
0
 
datAdrenalineCommented:
You are not really giving us much to go on :-s ...

How large is the SQL Server table?  Does the table have a Primary Key index?  Is the source object a true base table, or is it a View?  Does the Connect property of the troublesome table differ from that of the Connect property of a working linked table object?
0
 
paulmcneilAuthor Commented:
Thanks datAdrenaline. The table has 40 records. It has an identity field. Connect string is identical to other tables that open fine. It is a table, not a view.
Does setting a field Identity property to Yes take care of the primary key?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
datAdrenalineCommented:
I am not a point monger and I am cool with whatever is decided, however, it seems as though from the progression of posts, it was my commentary that lead to the solution.  At with the way EE works, points should be awarded accordingly.

My comment:
>> Does the table have a Primary Key index? <<

paulmcneil comment:
>> Does setting a field Identity property to Yes take care of the primary key?  <<

paulmcneil reason for deletion:
>> Just had to set the Primary Key in the table design. Thanks!  <<

----

Again, I am cool with whatever is decided, so while I did click the "object" button, its more of a "yellow flag" with comment of, "I don't think EE is supposed to work this way".

Regards,
Brent
0
 
datAdrenalineCommented:
By the way ... I am glad to here of the success! <thumbup>
0
 
Robert MarleySinger / SongwriterCommented:
I am starting the Auto-Close procedure on behalf of the question asker, to close this question, after the 'Objection' by datAdrenaline stopped the procedure. The course of action selected seems the most equitable action to take in this instance.


-----
Everyt'ing is everyt'ing,

Mod_MarlEE
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.