jimhunterabdn

Many thanks.

Hi Peter

I take your point about Data Projects.

With regard to ‘Table access’ I now see what it’s for. Perhaps the wording ‘(reflects table access only)’ could be ‘(containing the tables used in Table Access below)’. Perhaps a bit wordy but …

Jim

Hi Peter

Many thanks for the prompt reply (and for your continuing support for the plugin!)

I’ve experimented with your two methods and both seem to work for me. Two comments

Export/import with Data Explorer. This seems to be the best solution as one can import and export all tables at the same time – cuts down effort and avoids mistakes. Just delete all existing tables before import.

Export/import from the tool menu. Also OK but a bit more laborious – if you want to make sure the schema names are consistent across all tables you have to import/export Data Projects, Project Templates, Data Designer separately.

Is this a fair summary?

Best wishes

Jim

PS I’m still a bit confused as to the meaning of the ‘Selected database … (reflects table access only)’ settings for both front- and back- ends (in WP Data Access Settings). What do these do?

Perfect – worked a treat. Very many thanks. Jim

Thanks Peter for your prompt reply.

I was hoping that some of the facilities that are available when defining pages using Data Publisher (e.g. specifying Column Names and Column Labels), would be available when defining pages using Data Projects. But I guess they are somewhat different beasts!

Best wishes

Jim