Is it safe to ignore ~sq_ queries when using LoadfromText

Question

I'm working on some VBA to do exporting and importing (using SaveAsText and LoadFromText) of MS-Access objects in an application I'm supporting. I'm hoping to be able to start storing my code in SVN so that more than one developer can work on this application at once.

I keep getting the following error when I bring in queries that start with ~sq_

2285 - Microsoft Access can't create the output file.

Anecdotally, when I skip the ~sq_ files, my forms and reports seem to work. Is this safe to do long term?

Answer 1

When you use a SELECT statement as the RecordSource for a form, Access creates a hidden query. When you SaveAsText for the form, the file includes that same SELECT statement as its RecordSource property. So when you LoadFromText, Access can recreate the hidden query. I suspect the same thing happens for report RecordSources, but I haven't actually checked. I skip those ~sq queries for SaveAsText.