Results 1 to 2 of 2
Thread: Corrupts on network (97 SR1)
2001-11-08, 18:39 #1
- Join Date
- Feb 2001
- Thanked 0 Times in 0 Posts
Corrupts on network (97 SR1)
How do you run your Access 97 (SR1) databases - from your local hard drive, LAN or WAN (NT 4). There must be many databases in the company where I work (but I have no idea how many).
Every now and then I hear about a db becoming corrupted. MS discourages db from being run on the WAN (of course, that doesn't stop the users).
So what have your experinces been with running Access from HD, LAN or WAN? We get more requests for Access for new projects.
But dealing with the corruptions has been a nightmare.
2001-11-08, 23:03 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 33 Times in 33 Posts
Re: Corrupts on network (97 SR1)
I always run a split database schema (frontend and backend databases) whether the data will reside on the server or locally. The frontend will always be local.
Anything that can cause the server to go down will probably leave the database corrupted, if it was open at the time. You'd be surprised how many small, peer-to-peer networks don't have the "server" on a UPS.
And while Access works fine on a LAN, the overwhelming sentiment I've heard is "Don't use Access on a WAN!".