Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access #Deleted

Status
Not open for further replies.
TrustMe2

TrustMe2

Programmer
Aug 30, 2006
3
US
I linked from MS access 2000 to SQL Server tables with ODBC, and every column in every table says #Delete.
 
Sort by date Sort by votes
This is more of an Access problem. It has to do with the key value or values that you defined when you linked the table.

Google "ms access #deleted SQL Server" for suggestions. Your situation may vary.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
I'll have the roast duck with the mango salsa.
 
Upvote 0 Downvote
If you have a bigint in SQL server it may cause a problem in Access. You should change it to an int.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
539
Chris Miller
Chris Miller
new_to_sql
  • Locked
  • Question
Access SQL Query Error
Replies
5
Views
370
dhookom
dhookom
tn_sudheer
  • Locked
  • Question
Acessing MS SQL Data through vb script
Replies
6
Views
1K
Andrzejek
Andrzejek
Bomac8
  • Locked
  • Question
Convert Ms Access IIF to SQL Server Version 3
Replies
9
Views
458
Bomac8
Bomac8
Auguy
  • Locked
  • Question
Move SQL DB to the Cloud and Access it From a .Net Program
Replies
0
Views
191
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top