Zakraket's latest activity
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.I haven't tested (yet), but it must be this, tnx! A new driver is an option, but it would require testing of the whole system, no time...
-
ZZakraket reacted to Minty's post in the thread SQL table linked in MSAccess, insert yes, update/delete no with
Like.
Check the SQL Server compatibility level on the two servers. -
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.That's it! I changed the compatilitylevel of the database because I needed to use some function (can't remember what), but I changed the...
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.The plot "thickens". When I reconnect the Accessclient to a copy of the database, the problem isn't there. MS Access is still the same...
-
ZZakraket reacted to Minty's post in the thread SQL table linked in MSAccess, insert yes, update/delete no with Like.
@GPGeorge it's a normal DateTime field - as per the SQL table def in post #1 @Zakraket Okay I have done a little more digging. On a...
-
ZZakraket reacted to Minty's post in the thread SQL table linked in MSAccess, insert yes, update/delete no with Like.
@Pat Hartman - This is definitely a issue, I've seen it myself, I just can't replicate it at the moment. The SmallDateTIme is another...
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.I know it works that way, but I'm only working in the newly created table so far, there are no forms in the picture thusfar (as the...
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.I've tried ODBC Driver 17 and 18 for SQL server but that doesn't make a difference, the issue also seems to be in every table that has a...
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.Looking a bit further; I know I never had issues to enter/update records in the table un untill a few weeks. My MSAccess build changed...
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.The table in SQL, some records updatebla, some not When I UPDATE the date to not include milliseconds, I can update the other records...
-
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.I don't have the extended DateTime option (if you refer to the tickbox from your first sceenshot), so that's an issue I could try what...
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.Thanks for your input. It's Access version 1808 (9 jan 2024) but I don't have this specific option. But the field is a DateTime as you...
-
-
ZZakraket replied to the thread SQL table linked in MSAccess, insert yes, update/delete no.Now I've narrowed it down to the constraint on the CreatedOn field (getdate()) When I leave the constraint out I do not have this...
-
-
ZI have a fairly large ERP-system that I'm maintaining for a company. It's a MS Access front end with a SQL database. No issues so far...
-
