Database Problem

SamuelMSr · October 24th, 2011, 03:02 PM

I am working on my own project site and still using the book as a reference as I go along and am working on building the database tables at the moment.

I have created a table called AnimalInfo and put in several colums so far, and when I click on save I get an error message box come up:

Code:

 
You cannot save changes that would result in one or more tables being re-created. You can override this behavior by changing your conviguration options. Open the Tools.......
 
Your pending changes require the following tables to be dropped and re-created:
AnimalInfo

I am not sure why it is doing this and if I should change this setting or not, this did not come up in the book so I am a bit stuck.

Thanks for any help!!!

Sam

Imar · October 29th, 2011, 11:11 AM

Hi Sam,

This setting is to prevent you from making changes to a table that requires a rebuild of the table. You would want to prevent this on large tables on a production server as it may take a lot of time to complete.

For a development machine, you can safely turn off the setting.

Cheers,

Imar