| Author |
 Topic  |
|
|
SpankyP45
Starting Member
2 Posts |
 Posted - 05 October 2004 : 13:54:30
|
I'm applying mods to my database, for example the Poll Mod...
When I run the script that changes the database to include the new fields and tables, the new fields in existing tables are created properly, but the new tables are not, even though they are reported as being created. If I run the script again, it reports errors as it thinks the tables as already existing. But the tables aren't being created in the database.
Now, I can take the script file and create the table & it's fields manually in Access, but this is hardly the way to go, is it?
Any suggestions folks? |
Edited by - ruirib on 05 October 2004 17:25:46 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 05 October 2004 : 16:20:05
|
quote:
it reports errors as it thinks the tables as already existing
It doesn't "think", the SQL statement returns the error because the tables DO exist. How do you know that new tables aren't created properly ?
Also, there's no need to manually add in Access, try the Alt mod setup but it sounds like what you're doing is fine. |
 |
|
|
SpankyP45
Starting Member
2 Posts |
Posted - 06 October 2004 : 04:14:47
|
quote:
Originally posted by laser
How do you know that new tables aren't created properly ?
Because when I use a page that makes use of the new tables I get an error saying the tables don't exist and when I open the database with Access, I can see that the new tables don't exist while the new fields in existing tables created by the MOD script have been added. |
|
|
| |
Topic |
|
Topic Locked
