I have been given a task to synchronize issues that have been logged into two different Access 2000 databases. Both databases have got an Issues Table, so my plan is to open a recordset and find all issues that exist in Issue Table A which do not exist in Issue Table B. The issues which exist in Table A but not Table B will then be added to Table B, so both tables will contain the same issues. However, one of the field names in Table B contains spaces (IL Issue Number) and I know that you cannot refer to an object in VBA which contains spaces.
Does anybody know a way round this, or is it a matter of having to rename this field so that it doesn't contain spaces? Any help would be greatly appreciated.
Does anybody know a way round this, or is it a matter of having to rename this field so that it doesn't contain spaces? Any help would be greatly appreciated.
