|
 |
access thread: How to unreplicate a database or recover from a .bak file?
Message #1 by <odempsey@b...> on Thu, 29 Aug 2002 12:23:48 +0100
|
|
Hi folks
does anybody know how to unreplicate a database? I replicated a database for Internet
synchronisation but discovered that it was too awkward with the need to install software on the
Internet Server. The replication is now proving to be a nuisance as the ID numbers are just too
long and cumbersome when coding in ASP.
If there is no way of un-replicating the database, how do you recover the old database from the
*.bak backup copy that access made before it was replicated?
Kind Regards
Oliver Dempsey
00353 (0)502 26263
00353 (0)86 8219430
Message #2 by "Haslett, Andrew" <andrew.haslett@i...> on Fri, 30 Aug 2002 08:38:09 +0930
|
|
www.trigeminal.com will have tips on how to do this.
BTW, Bit confused at your ASP statement. Whatever the platform, Primary Keys
shouldn't generally be seen, so it shouldn't matter what the figure is...
And with ASP you don't even have to worry about overflow errors (ie,
assigning a key of 32000+ to an Int variables) as your data types are all
variants...
Cheers,
Andrew
-----Original Message-----
From: odempsey@b... [mailto:odempsey@b...]
Sent: Thursday, 29 August 2002 8:54 PM
To: Access
Subject: [access] How to unreplicate a database or recover from a .bak
file?
Hi folks
does anybody know how to unreplicate a database? I replicated a database
for Internet
synchronisation but discovered that it was too awkward with the need to
install software on the
Internet Server. The replication is now proving to be a nuisance as the ID
numbers are just too
long and cumbersome when coding in ASP.
If there is no way of un-replicating the database, how do you recover the
old database from the
*.bak backup copy that access made before it was replicated?
Kind Regards
Oliver Dempsey
00353 (0)502 26263
00353 (0)86 8219430
Message #3 by "George Oro" <george@c...> on Sat, 31 Aug 2002 09:32:17 +0400
|
|
Oliver,
Just change the extion (.bak) to .mdb in windows explorer.
HTH
George
-----Original Message-----
From: odempsey@b... [mailto:odempsey@b...]
Sent: Thursday, August 29, 2002 3:24 PM
To: Access
Subject: [access] How to unreplicate a database or recover from a .bak
file?
Hi folks
does anybody know how to unreplicate a database? I replicated a database for Internet
synchronisation but discovered that it was too awkward with the need to install software on the
Internet Server. The replication is now proving to be a nuisance as the ID numbers are just too
long and cumbersome when coding in ASP.
If there is no way of un-replicating the database, how do you recover the old database from the
*.bak backup copy that access made before it was replicated?
Kind Regards
Oliver Dempsey
00353 (0)502 26263
00353 (0)86 8219430
|
|
|
View Cart
