UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Only 1st 10 Recs Show #deleted Error With Access F/e And Mysql B/e    
 
   
withallthymind
post Jan 9 2020, 09:18 AM
Post#1



Posts: 13
Joined: 15-April 08



Hi all, I'm using an Access f/e with a MySQL remote b/e. I've read a lot about the #Deleted issues and BIGINT. I'm not using BIGINT and the #Deleted errors are occuring for only the first 10 records of simple queries or when I open the table from the MSAccess Objects list. iconfused.gif Pressing the F5 key updates the query/table and the errors go away. Is this the same issue that has plagued Access/MySQL for years? Why would only the first ten records error out? Is this a "timing" thing between MySQL and Access?

How do I resolve this or work around it?

Here is what I'm using:

MySQL version: 5.6.41-84.1
MS Access Version: Office 365
ODBC Connector Version: 10.0.18362.1
MySQL ODBC 8.0
Unicode Driver: 8.00.18.00


Here is a link with a couple of screen shots. First ss is of the query results with errors and the second is of the table structure. <<removed link to external images>>

If this can't get resolved, I am thinking of moving the b/e to a Microsoft SQL server instead.

Appreciate any help on this.

Tim
This post has been edited by GroverParkGeorge: Jan 9 2020, 09:50 AM
Attached File(s)
Attached File  tbl_company_record1_TABLE.png ( 144.44K )Number of downloads: 1
Attached File  tbl_company_record1_STRUCTURE.png ( 161.1K )Number of downloads: 1
Attached File  tbl_company_record1_ACCESS_STRUCTURE.png ( 34.51K )Number of downloads: 1
 
Go to the top of the page
 
GroverParkGeorge
post Jan 9 2020, 09:50 AM
Post#2


UA Admin
Posts: 36,562
Joined: 20-June 02
From: Newcastle, WA


I'm going to remove the link to the external images (it's in our guidelines).

Please upload the images HERE as part of your post.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
withallthymind
post Jan 9 2020, 10:23 AM
Post#3



Posts: 13
Joined: 15-April 08



Hi George, I tried to add the images and it bounced me out . . . and I can no longer edit the post. ??
Go to the top of the page
 
GroverParkGeorge
post Jan 9 2020, 10:29 AM
Post#4


UA Admin
Posts: 36,562
Joined: 20-June 02
From: Newcastle, WA


There are limits on the ability to edit posts. IIRC, it is after 20 posts (we don't like to give spammers a head start).

Create a new post. Then use the Attachments feature to upload the images.

Attached File  attachments.png ( 68.92K )Number of downloads: 1



--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    27th January 2020 - 01:19 AM