Creating Table For Memo Field
Posted on 2014-01-20
I've got a Memo field in the main table of my database.
About 10% of records have data stored in this field.
I'm having frequent recording locking problem with the memo field even though it's a single user database. This is despite much restarting, repairing, decompiling, recreation of entire records and of memo records with all html stripped out (using notepad) etc.
I also recreated the front/backends by importing into blank databases.
I'm going to run a make table query with only the RecordID and the memo field in the new table (Let's call it the memo table). I will have a one-to-one relationship between the two tables.
Do I need a corresponding record in the memo table for each record in the main table, or just those with data in the memo field? (The former seems the most likely to me).
When I create a new record in the main table, will a corresponding record be automatically created in the memo table?
Finally, a little help with the code that opens a popup form with the memo info.
This works a present where the memo field is in the main table.
DoCmd.OpenForm "MEMOpopup", , , "RECORDid = " & Me.RECORDid
Will it work when the MEMOpopup Form is based on the new memo table?
Thank you for your time in reading through this longish question
and any help that you may provide.