By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,326 Members | 1,682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,326 IT Pros & Developers. It's quick & easy.

Linking tables to SQL Server 2000 causing strange results

P: n/a

Hello everyone,

I have a Access database (2000) that has several tables that are links
to SQL Server 2000 databases.

One of these tables has the following fields (plus others):

Name
Agency

Each Agency can have multiple names. So one record might show:

Tom Smith 3A (3A being the agency code)

Then you could also have

Bob Jones (3A)

Is is the weird thing. When I open this linked SQL table in design
view, I see Tom Smith twice and Bob doesnt show up at all. However,
if I do a refresh, it appears fine. Also, if I import this table
directly into Access, this behavior does not happen.

Any ideas how to correct this? I need to be able to maintain the link
and see the correct data.

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
bd*****@yahoo.com wrote:
Hello everyone,

I have a Access database (2000) that has several tables that are links
to SQL Server 2000 databases.

One of these tables has the following fields (plus others):

Name
Agency

Each Agency can have multiple names. So one record might show:

Tom Smith 3A (3A being the agency code)

Then you could also have

Bob Jones (3A)

Is is the weird thing. When I open this linked SQL table in design
view, I see Tom Smith twice and Bob doesnt show up at all. However,
if I do a refresh, it appears fine. Also, if I import this table
directly into Access, this behavior does not happen.

Any ideas how to correct this? I need to be able to maintain the link
and see the correct data.

Thanks


Your table needs a Primary Key or a TimeStamp (aka RowVersion) data type
column. These things are how Access identifies which row is which.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.