Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MirandaJ
Starting Member
35 Posts |
 Posted - 2006-02-06 : 13:10:09
|
| We recently upgraded a number of databases from MS Access 2000 to SQL Server 2000. I need to make it so that users can display the data from the SQL Server so I created some link tables in Access for them to view the data without using SQL Server Enterprise Manager. This works fine in tables with only a few thousand rows of data. However some of the tables have 100K+ rows of data, and these are not displaying the data. When someone tries to view the data in one of these tables all they see is #Deleted in every column. Is it possible to link to tables in SQL Server with large numbers of rows and view this info in Access?Miranda |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-06 : 13:29:39
|
I guess access (being a file database) is not capable of handling, an enterprise system  Why not use query analyzer ??? |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-02-06 : 14:14:15
|
| Do all of your tables in your SQL Server database have primary keys? |
|
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2006-02-06 : 14:24:49
|
quote:
Originally posted by jsmith8858
Do all of your tables in your SQL Server database have primary keys?
Yes, they all have a primary keyMiranda |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-07 : 03:55:22
|
| We have around 100K rows linked to Access 97 from SQL Server with no problem. Have you looked at the timeout settings on the options | advanced tab in Access. We have had to tweak some of the options in there in the past. steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
|
|
|
Linking to SQL Server in Access