search

joyfullservice / msaccess-vcs-addin

Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
Other
203 stars 40 forks source link

Apostrophe in table name #83

Closed effjot closed 3 years ago

effjot commented 3 years ago

Export of tables fails if the name contains apostrophes.

I‘ve addded a fix to export and TDF table data import (https://github.com/effjot/msaccess-vcs-integration/tree/export-import-tablename-with-apostrophe), which seems to work. Such names are a bit deep in Bobby Tables land… Other quoting issues still may lurk somewhere else. Probably it’s better to not allow apostrophes at all.

I only stumbled across it after forgetting to delete an “import failures” table Access puts in the DB when import from Excel etc. fails.

joyfullservice commented 3 years ago

Thanks for pointing this out! I have updated several places in the code, and tested some interesting table and field names... 😄

image

Let me know if you encounter any further issues of this kind.

effjot commented 3 years ago

You’ve missed 1 place I had fixed (importing tdf data). I’m preparing a pull request