Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe there’s a cleaner fix, in the past I’ve just changed the table to a tinyint with a check constraint. Bits are useful things, should just work.
Read more "Access Annoyance – Bit Columns"Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables, like so: Note the save password box is checked. Click ok, and then you get this fun dialog after you enter your password, once for each table/view you selected. Seriously, we couldn’t get an intern […]
Read more "MS Access Annoyance: Yes, Save the Password, Again"I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data in smaller projects. Linked tables work reasonably well, just have to create a DSN first. Except…it doesn’t seem to work (at least obviously) for synonyms. Here’s one I created (viewing as sysadmin): And the view […]
Read more "MS Access Annoyance: Doesn’t Link Synonyms"Access is actually pretty good at importing files, and doesn’t on the surface work much different that import/export from Management Studio. I wrote this up after a friend had asked for assistance, I remembered the import specification part but couldn’t find at the time how to drive it from code. Finally dug through (it’s been […]
Read more "Automating Imports from Access"
SQLAndy 