| Author |
 Topic  |
|
|
dssww
Junior Member
USA
182 Posts |
 Posted - 11 July 2001 : 19:13:35
|
I can't seem to find the drop PM table file. Does anyone have it available?
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 July 2001 : 19:30:20
|
you want to completely drop that table?
You can make a .dbs file that will work with mod_dbsetup.asp
just create a new file and name it something like droppmtable.dbs (or dbs_droppmtable.asp depending on what version of mod_dbsetup.asp you are using)
Here is what to put in the file:
Drop PM Table
[DROP]
PM
[END] |
 |
|
|
dssww
Junior Member
USA
182 Posts |
Posted - 11 July 2001 : 20:31:42
|
I already tried that and it didn't work, I thought I missed something, not even an error. I really only need to get autonumber on the M_ID field. I didn't care about loosing the PM's I already lost 2 weeks of posts & 30 members. 
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 July 2001 : 20:36:00
|
Do you have access to your database? What are you using? Access? MS SQL?
If Access, Access97 or Access2000? |
|
|
|
dssww
Junior Member
USA
182 Posts |
Posted - 12 July 2001 : 06:16:23
|
Richard,
I have access to my DB it is access2k. I am back up on my SQL now but would like to know for future ref if you can fix the field to autonumber or you have to drop the table & start over
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 12 July 2001 : 07:00:44
|
If you have Microsoft Access, you can open the database and set it to autonumber.
Also, you can use something like TableEditor as well.
Other than that, dropping the table and readding it is the only other way I know of. |
|
|
|
dssww
Junior Member
USA
182 Posts |
Posted - 12 July 2001 : 09:17:51
|
quote:
If you have Microsoft Access, you can open the database and set it to autonumber.
Also, you can use something like TableEditor as well.
Other than that, dropping the table and readding it is the only other way I know of.
Access will not let you autonumber a field if it contains data.
|
|
|
| |
Topic |
|
Topic Locked
