Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-14-2018, 01:12 PM   #1
CedarTree
Newly Registered User
 
Join Date: Mar 2018
Posts: 58
Thanks: 22
Thanked 1 Time in 1 Post
CedarTree is on a distinguished road
#Delete in tables?

I'm getting the dreaded #Delete in rows in a table that is linked from SQL server to Access. Primary Key is clearly defined. No nulls in that. Not using BigInt (googling suggests this may be a problem). It's just crazy. Here's my table design in SQL server... Please help!

PlanCode int Unchecked
TermDate nvarchar(30) Unchecked
IntRate nvarchar(30) Checked
Mortality nvarchar(30) Checked
MidYear nvarchar(30) Checked
Interpolation nvarchar(30) Checked
NormalForm nvarchar(30) Checked
ERPSupplement nvarchar(30) Checked
PlanReference nvarchar(255) Checked

CedarTree is offline   Reply With Quote
Old 04-14-2018, 01:27 PM   #2
CedarTree
Newly Registered User
 
Join Date: Mar 2018
Posts: 58
Thanks: 22
Thanked 1 Time in 1 Post
CedarTree is on a distinguished road
Re: #Delete in tables?

Ha! I think I figured it out. The person filling in the table was using the greater than or equal (single) character rather than >=

The field in question was a text field). So it seems Access freaked out about that character. Lesson learned.

Last edited by CedarTree; 04-14-2018 at 01:54 PM.
CedarTree is offline   Reply With Quote
Old 04-14-2018, 01:41 PM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,382
Thanks: 92
Thanked 1,820 Times in 1,693 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: #Delete in tables?

Quote:
Originally Posted by CedarTree View Post
Ha! I think I figured it out. The person filling in the table was using the greater than or equal (single) character rather than >=. So it seems Access freaked out about that character. Lesson learned.
How did they manage that - its not a standard keyboard character!

The latest version of Access 2016 using office 365 CAN handle BigInt. Any Access 2016 versions prior to about last August or previous versions can't do so.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 04-14-2018, 01:53 PM   #4
CedarTree
Newly Registered User
 
Join Date: Mar 2018
Posts: 58
Thanks: 22
Thanked 1 Time in 1 Post
CedarTree is on a distinguished road
Re: #Delete in tables?

It was a copy/paste from Excel and Excel allows that character of course.

CedarTree is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete query error could not delete from specified tables sivani_007 Queries 3 03-10-2015 12:00 AM
Delete Query error: "Could not delete from specified tables" mba1942 Queries 4 12-02-2014 11:15 AM
Delete Query (Specify the tables containing the rows you want to delete) elitehass Queries 3 04-11-2013 02:17 AM
Duplicate Records Delete Query "Could Not Delete From Specified Tables" 1cekream Queries 3 07-21-2011 02:18 AM
Delete Query Problem (Cannot delete from specified tables) bc9999 Queries 3 10-26-2008 09:57 AM




All times are GMT -8. The time now is 07:39 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World