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: 44
Thanks: 17
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: 44
Thanks: 17
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
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,806
Thanks: 79
Thanked 1,430 Times in 1,335 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
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.

New example databases:

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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
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.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 04-14-2018, 01:53 PM   #4
CedarTree
Newly Registered User
 
Join Date: Mar 2018
Posts: 44
Thanks: 17
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 03:32 AM.


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

Sponsored Links

How to advertise

Media Kit


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