473,378 Members | 1,354 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Opening database with text editor

I opened an mdb file with a text editor, deleted random chunks of data from
it and then saved it. Now it won't open. Fortunately, it wasn't one of
mine - it was from the accounts department, but can it be repaired?

Steve
Nov 13 '05 #1
8 1965
Rog
That was not a smart move... I don't see how any utility would be able
to repair the "gaps" that you made. I hope your friend has a backup.

Nov 13 '05 #2
I would try opening a new access database and doing an import. Then
import everything from the other mdb.

ps never open an MDB with a text editor. If you need to work with the
raw data at the least, export the table and open that in an editor.

Nov 13 '05 #3
You should NEVER manipulate a file unless you know what program(s) you can
use to do so safely!

An MDB file should only be used with MS-Access, or another program that is
designed to work with MDB files.

I hope the data wasn't too importatnt, because unless you or the accounts
department has a backup of that file, it's gone!

Ruben baumann

"Steve Mills" <s@m.com> wrote in message
news:ct**********@titan.btinternet.com...
I opened an mdb file with a text editor, deleted random chunks of data from
it and then saved it. Now it won't open. Fortunately, it wasn't one of
mine - it was from the accounts department, but can it be repaired?

Steve

Nov 13 '05 #4
On Wed, 26 Jan 2005 15:47:46 +0000 (UTC), "Steve Mills" <s@m.com>
wrote:
I opened an mdb file with a text editor, deleted random chunks of data from
it and then saved it. Now it won't open. Fortunately, it wasn't one of
mine - it was from the accounts department, but can it be repaired?

Steve

I opened my laptop harddrive with a can opener and I'm having trouble
puttting it back together. Will it still work? Fortunately it belongs
to the IT department. Will they mind?
Sorry
David

Nov 13 '05 #5
I presume this is a joke post? Delete reandom chunks of a file, and wonder
why it won't open?

On 26 Jan 2005 15:55:06 -0600, d.***************@blueyonder.co.uk (David
Schofield) wrote:
On Wed, 26 Jan 2005 15:47:46 +0000 (UTC), "Steve Mills" <s@m.com>
wrote:
I opened an mdb file with a text editor, deleted random chunks of data from
it and then saved it. Now it won't open. Fortunately, it wasn't one of
mine - it was from the accounts department, but can it be repaired?

Steve

I opened my laptop harddrive with a can opener and I'm having trouble
puttting it back together. Will it still work? Fortunately it belongs
to the IT department. Will they mind?
Sorry
David


Nov 13 '05 #6
Steve
You are better at recognising jokes than people give you credit for.
Tom

Nov 13 '05 #7
Last year I went skiing in France and broke a leg.
Fortunately it wasn't one of mine.

Tom

Nov 13 '05 #8
"Steve Mills" <s@m.com> wrote in
news:ct**********@titan.btinternet.com:
I opened an mdb file with a text editor, deleted random chunks
of data from it and then saved it. Now it won't open.
Fortunately, it wasn't one of mine - it was from the accounts
department, but can it be repaired?

Steve


Oh my God, I hibernated through the end of January, all of February
and March, and just woke up to realize it must be April first.
..
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Douglas Buchanan | last post by:
I can't seem to open SQLS2k Stored Procedures in the IDE I am running MDE 2003 Version 7.1.3088 I have a MSDN professional subscription and did a complete install of vs.net Help explains how...
4
by: Marcus | last post by:
I am using the following command to open a query in Excel: DoCmd.OutputTo acOutputQuery, "qryTest", acFormatXLS, , True The problem is that the code creates an Excel 97 file. Is there a way...
2
by: Suma | last post by:
Hi To open a notepad file, right now I am using Process.start. But this does not ensure that the file is opened in readonly mode How can I make a notepad file open in Readonly mode I do not...
6
by: tactics40 | last post by:
I'm writing a GUI application in Jython which takes a database text file and performs some operations on the data, finally spitting out a group of CSV files. I generate a log file and several...
18
by: mollyf | last post by:
I just installed SQL Server 2005 on my PC (the developer's edition) yesterday. I have some scripts written by one of my coworkers to create some tables and stored procedures in a database that...
8
by: chaossliver | last post by:
I'm a brand new scripter, and as such, I have very poor experience in coding. I have been looking around at some open source codes written in pure C and was wondering if anyone knew of a program...
8
by: John | last post by:
hi Everybody, I just made a simple web site using Frontpage 2003 with a simple MS Accesss database. IF I try to open the asp page in a browser by typing http://localhost/mysite/db.asp it...
4
by: Ben | last post by:
Hi! Just recently, I received complaints from users that every now and then the VBA script editor pops out for no reason. I made sure that the breakpoints have all been cleared before...
2
by: John | last post by:
Hi I have a number of forms which open like this; Dim frm1 As frmForm1 = New frmForm1 Dim frm2 As frmForm2 = New frmForm2 Dim frm3 As frmForm3 = New frmForm3 Dim frm4 As frmForm4 = New...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.