|
| |
|
|
Rizzo
Posts: 42
Joined: 12/7/2001
From:
Status: offline
 |
Using a compact script with autonumbers in db - 12/9/2001 13:27:27
Anyone know if this is true?
I've heard that using compact scripts could mess up your database if you use autonumbers. That true? I want to use this script I found:
<%
oldDB = Server.MapPath("my.mdb")
bakDB = Server.MapPath("my_bak.mdb")
newDB = Server.MapPath("my.mdb")
Set FSO = Server.CreateObject("Scripting.FileSystemObject")
FSO.CopyFile oldDB, bakDB, true
Set Engine = Server.CreateObject("JRO.JetEngine")
prov = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Engine.CompactDatabase prov & OldDB, prov & newDB
set Engine = nothing
FSO.DeleteFile oldDB
FSO.MoveFile newDB, oldDB
set FSO = nothing
%>
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using a compact script with autonumbers in db - 12/9/2001 15:12:46
I havent heard it?
If you compact a 97 database that has had records deleted, then the autonumber will reset to the last highest
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
