I have a huge .accdb file that is being created from a now unsupported .adp file.
So far, I have imported all objects and my tables are now linked tables, which I have renamed to remove the automatic prefix 'dbo_'.
The next step is to remove all the schema qualifications, dbo. from data-source queries from all reports and forms.
I have thousands of controls on forms and reports with data-sources that need the " dbo." and " [dbo]." removing their queries.
Example
A form contains a combobox control, and the data-source is set to the following:
SELECT name FROM dbo.person WHERE building = 'reception'
I need some code that will change this data-source (along with all the others in all other forms) to:
SELECT name FROM person WHERE building = 'reception'
Does anybody know how to do this programatically?