God Morning,
I did a little digging and a lot of google searching and came up with what I think is the solution. I say think, because it’s working now. The SSMA_Timestamp field had lost its setting between import and exports to get the data in the way we wanted. Once I set the time-stamp correctly, the error did not reappear. I did wonder why “check” the time-stamp[ field isn’t one of the top 10 reasons for a write error. Maybe because I am a nubie and self-taught, it was a most would not make, but it seems like it should go along with “check the permissions”, etc. anyway, I am glad this forum exists and you might see more “silly” questions.
Marybeth
Original Message
Write error on SQL be-Access fe
Thu Oct 11, 2018 2:16 pm (PDT) . Posted by:
mstomka
Afternoon,
Can someone help me identify and solve an issue I am having with one table in a fe-be database? The table has a primary key and we don't get the write error all the time, so it’s got to be something that is being triggered, but I can't find the problem. Sometimes it occurs when you move to add another record and sometimes it won't let you edit an already existing record. I rebuilt it at least twice. Not sure what to do next.
Thanks in advance,
Marybeth
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
2b
Re: Write error on SQL be-Access fe
Fri Oct 12, 2018 7:57 am (PDT) . Posted by:
wrmosca
Marybeth
Maybe the problems is with the FE and not the table. Does this happen with all FEs? Have you tried importing everything into a new, blank FE?
Is the table being edited directly or are you using a form?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <marybeth.tomka@austin.utexas.edu> wrote :
Afternoon,
Can someone help me identify and solve an issue I am having with one table in a fe-be database? The table has a primary key and we don't get the write error all the time, so it’s got to be something that is being triggered, but I can't find the problem. Sometimes it occurs when you move to add another record and sometimes it won't let you edit an already existing record. I rebuilt it at least twice. Not sure what to do next.
Thanks in advance,
Marybeth
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
Posted by: Marybeth S Tomka <marybeth.tomka@austin.utexas.edu>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar