473,320 Members | 1,940 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Linking tables to SQL Server 2000 causing strange results


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
1 1130
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dennis | last post by:
Hello, I am running SQL Server 7 on a Windows 2000 server, with aprox. 10 databases. The largest database is 1,5 Gb the smallest 10 MB. The databases are used as databases for various websites....
2
by: chudson007 | last post by:
I have two tables, TableA and TableB. Each has a date in smalldatetime format. TableA has a qty field in int format. TableB also has a nvarchar field in which the date is in the format YYYYMMDD ...
31
by: Neil | last post by:
I have an Access 2000 MDB with ODBC linked tables to a SQL Server 7 back end. I currently have a selections table in the front end file which the users use to make selections of records. The table...
3
by: John South | last post by:
I have an Access 2000 front end that I wish to work with a SQL Server 2000 database by means of Linked tables. Do I have to use an ODBC connection to SQL Server? It seems to be the only option...
14
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...
5
by: Christoph Sticksel | last post by:
Hi, I'm having problems with attaching two tables stored in an SQL Server 2000 to an Access 97 database. It worked well for all other tables except those two. This is what I did: Choose the...
3
by: mike | last post by:
I added a linked server successfully; but the only tables accessible are only the system tables! I do have all the rights on both servers (Windows & SQL server). All the non system tables are...
8
by: rbg | last post by:
I did use query plans to find out more. ( Please see the thread BELOW) I have a question on this, if someone can help me with that it will be great. In my SQL query that selects data from table,...
1
by: GatorDBA | last post by:
Hey Folks, Experiencing strange problem with SQL 2005 running on Windows Server 2008. When trying to connect via named pipes or tcp, it takes 25-45 seconds for the connection to be established....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.