Changing the connection string
Ok, so if you connect with connection string 1, with the user "steve", and you've used that to do all your development...
Then lets say you move servers and the login is now "sa"....so you update the details
OpenAccess regenerates ALL the tables again, so my DB is 1/2 DBO.TABLE1, STEVE.TABLE1
I am afraid this is related to the standard SQL server behavior. The whole db structure is created from scratch when sitefinity initializes for the first time. If the user that you used to connect and create the database wasn't a db owner, all the tables are automatically created with this user schema. If the initial user was dbowner they would have been with DBO schema. I guess your current option is to either somehow convert back to this initial user for the connection, or migrate the existing tables to the DBO schema, using ALTER SCHEMA statements. We are going to consider the option of forcing the tables to be created always in the DBO schema to avoid such problems.
the Telerik team