Accessing Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

only maybe.
If you split your database, the likelyhood of data corruption is reduced.
In my experience, it is ususally the front end or application that becomes
corrupt. The data or backend becoming corrupt is more rare.
You can try a compact and repair and see how that works.
You can try using the TransferDatabase from a new mdb and see if you get
your data.
But, ulimately, there is nothing like regular backups to protect you.
 
If your Acess Database becomes corrupt for whatever reason. Is there a
way to still access the info in the tables. Also I thought of backing
up my access tables as CSV files is this wise? Is it a good idea? My
database will be split as well.
Thanks
DS
 
Klatuu said:
only maybe.
If you split your database, the likelyhood of data corruption is reduced.
In my experience, it is ususally the front end or application that becomes
corrupt. The data or backend becoming corrupt is more rare.
You can try a compact and repair and see how that works.
You can try using the TransferDatabase from a new mdb and see if you get
your data.
But, ulimately, there is nothing like regular backups to protect you.
Click to expand...
True backups are good. ButI was just wondering.

BTW how about the CSV files? Is that a good idea or not?
Thanks
DS
 
BTW how about the CSV files? Is that a good idea or not?
Click to expand...

It's a lot of extra work to get something that's no better than a good,
verified backup of the backend database.

John W. Vinson [MVP]
 
John said:
It's a lot of extra work to get something that's no better than a good,
verified backup of the backend database.

John W. Vinson [MVP]
Click to expand...
OK, point taken. I was also wondering about the different types of
back-up. For instance, instead of backing up,or copying the whole
Database can I just copy the records from the tables in one database
into another? This way I wouldn't need to close the database. Also is
it better to compact and repair then backup or...backup and the compact
and repair?
Thanks
DS
 
Klatuu said:
I don't see any real value. Backups are still be best bet.
Click to expand...
I just thought that I would have the data in an easy to read basic
format so that if all else fails, key input could be used.
DS
 
Back
Top