[Wilfred1]

This is a godsend and would like to do some testing firstly on the "mySQL Views" option so does anyone have any idea what the source_db syntax would be in the following code for the user table located in a separate db with a different IP Address, db name, dba_username and password but both db's on the same server?

CREATE VIEW user as
     SELECT * FROM source_db.user;

Secondly with the table prefix concept here would the addition of this mod:
https://vborg.vbsupport.ru/showthread.php?t=211100
help so a user doesn't have to login at both domains?

I can see a couple more vb license costs coming up if this works ok