N/APosted on - 02/23/2012
There are a number of problems we are experiencing with our database since splitting it and having all the tables relocated to the back end and generating links to the tables located at the front end.
This was due to the increasing number of people using it which led some users to being unable to access the database.
Please help me figure out what might be the cause of these errors.
Problems after splitting database and relocating tables
DB of your server site is not working properly due to population of your site right this is why some peoples have no access to the DB and the tables right so you need to do:
1. First of all go to the DB and see all the table and get them together if all are scattered and then copy all the tables in that DB. Copy means export all the tables and then delete that DB and create the new DB with the same name and then import the tables on the DB and it will working and you will find that over loaded site does not affect the DB this time and the tables will not scattered and will not cause any problem.
Hope this solution will get you out of trouble.