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
> Unrecognized Format After Entering Email Address Into Text Field, Access 2010    
 
   
redpenner
post Mar 11 2019, 11:05 AM
Post#1



Posts: 199
Joined: 16-July 10
From: Shelton, WA


Hello - we are running Access 2010 on Windows 10 computers, although the FE were created on a Windows 7 computer and the BE resides on a Windows 7 computer. Users have .accde on their hard drives; I have the back end on my hard drive.

A user entering an email address into a text field in a datasheet (query, not form) receives an immediate message stating "unrecognized format" and the full file address of the BE. I have usually been able to open the BE, it declares itself in an inconsistent state then repairs itself, but today I had to copy the BE file before it would do that (it hung at "not responding" when I tried to open the original BE).

I have reproduced this on the user's computer, so can verify it's just a plain ordinary email address being entered with no stray key presses or other weird data entry going on. The query just pulls from the single table and the table field is just plain text limited to 100 characters. I can't reproduce it entering into the .accdb on my Windows 7 computer.

Is this a known problem, and if so is there a fix? Could it be with Windows 10 or using .accde for data entry?
Go to the top of the page
 
DanielPineault
post Mar 11 2019, 12:58 PM
Post#2


UtterAccess VIP
Posts: 6,848
Joined: 30-June 11



See: http://www.devhut.net/2018/06/13/access-bu...ognized-format/

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
redpenner
post Mar 11 2019, 01:43 PM
Post#3



Posts: 199
Joined: 16-July 10
From: Shelton, WA


Thanks - sounds like that may be what's going on. frown.gif

I'm currently fighting to keep this database going; admin wants us to abandon it for a pre-fab online cloud-based platform that really isn't working as well. I've been running both simultaneously but this isn't going to help my cause any!

Thanks again for the help!
Go to the top of the page
 
DanielPineault
post Mar 11 2019, 01:45 PM
Post#4


UtterAccess VIP
Posts: 6,848
Joined: 30-June 11



I hear you. Sadly, anything Win10 or O2016/2019/365 isn't going to help your cause, they are all plagued with update bugs and problems. It's a nightmare IMNSHO. The problem you are currently facing, if it is this bug and not outright corruption, is over 9 months old now and still nothing from MS. All I can say is good luck.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
DT_madness
post Mar 12 2019, 07:23 AM
Post#5



Posts: 628
Joined: 25-July 07
From: Georgia, USA


Hi, Daniel.

I found that link yesterday while trying to research what's going on. You've been quite helpful in sticking with it in communication. My issue just started last week when we upgraded to O365 and most others came online with Win 10. It's been a nightmare with the unrecognized format. I followed the steps with the SMBCacheFix.reg and by using the Command Prompt to type " REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f"

I had a crash this morning and it looks like I might have been the only one hitting the BE so I don't know if this workaround helped or not. Do I need to reboot after doing?


--------------------
I'm very optimistic about my pessimism.
Go to the top of the page
 
DanielPineault
post Mar 12 2019, 07:32 AM
Post#6


UtterAccess VIP
Posts: 6,848
Joined: 30-June 11



From my understanding you're not supposed to need to reboot, but I know I did need to (and that's when I had issues - lost all my mapped drives, but the db worked though)

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
DT_madness
post Mar 19 2019, 11:45 AM
Post#7



Posts: 628
Joined: 25-July 07
From: Georgia, USA


Daniel, I've got another question. We're still having issues after the SMBCache was ran on people's pcs. Have you heard anything about this still being an issue is items are in SQLServer instead of an Access back end?

--------------------
I'm very optimistic about my pessimism.
Go to the top of the page
 
DanielPineault
post Mar 19 2019, 02:44 PM
Post#8


UtterAccess VIP
Posts: 6,848
Joined: 30-June 11



To my understanding, others can always correct me, but this solely impacts Access. So I do believe that SQL Server back-end are not impacted by this issue.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
gemmathehusky
post Apr 25 2019, 09:42 AM
Post#9


UtterAccess VIP
Posts: 4,725
Joined: 5-June 07
From: UK


out of interest, does the locking file (ldb, laccdb) max out at 16Kb
I wondered if this was caused by repeated failed attempts to add a new session, ultimately showing as a database needing a C&R to repair a non-existent problem.

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th September 2019 - 11:12 AM