Book a Demo

Author Topic: Problem when deleting a package manualy  (Read 6865 times)

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Problem when deleting a package manualy
« on: December 05, 2013, 03:29:13 am »
I have an EA file which has a lot of diagrams from  my friend ,
 
I have got the following error message when I deleted some packages in EA Project, but the others work perfectly ..
the package I want to delete contains some old diagrams from previous work,, I do not know which version were generated.

the error message is "

DAO.Database [3343]
Unrecognized database format
--------------------------------------
also I can not open the model on MS Access 2010 ..
is it ADO or JIT or DAO problem .
also I can not use Repository.SqlQuery("select * from t_object") .. it  can not perform any thing it make the program to stuck .

I use  Version : 10.0.1006

Thanks

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Problem when deleting a package manualy
« Reply #1 on: December 05, 2013, 07:56:33 am »
Hello,

it looks as there is something with your Access Database.

I would:
  • Export your repository to *.xmi
  • Create a new Database on your local drive
  • Import repository from *.xmi
  • Tools, DataManagement, Project Integrity check

May be ask your friend to send an export in *.xmi format to you. Sometimes it's a problem with JET4 (Tools, Options, General, Use JET4.)

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Problem when deleting a package manualy
« Reply #2 on: December 05, 2013, 08:47:09 am »
I go with Helmut. Your repository is most likely corrupt. That happens every now and then with MS Access databases (and thus with EAP). Unless you are a MS wizard your only chances are backups or XMI exports from backups.

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Problem when deleting a package manualy
« Reply #3 on: December 05, 2013, 08:52:19 am »
The other thing that can help is Tools | Data Management | Manage .EAP File | Repair/Compact .EAP File.

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: Problem when deleting a package manualy
« Reply #4 on: December 05, 2013, 11:11:12 pm »
Quote
The other thing that can help is Tools | Data Management | Manage .EAP File | Repair/Compact .EAP File.

I did that ,,, but still have a problems

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: Problem when deleting a package manualy
« Reply #5 on: December 06, 2013, 12:24:52 am »
I can not make REPAIR
I did compact
but the problem still..

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Problem when deleting a package manualy
« Reply #6 on: December 06, 2013, 06:04:59 am »
Hi Michael,

what was exactly the problem with the repair? It's no good idea to repair an open Repository.

In my opinion you have the following options:
  • Repair with EA
  • Repair with Access
  • Export if possible

If this don't work: I hope you have a backup.

Always keep in mind: *.eap files are easy to use but have some problems. In my personal opinion nothing for professional work.

Good luck,

Helmut



Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: Problem when deleting a package manualy
« Reply #7 on: December 13, 2013, 10:35:02 pm »
How can  I repair with access

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Problem when deleting a package manualy
« Reply #8 on: December 13, 2013, 10:54:22 pm »
Hello,

open Access. I think the entry is database tools. I can't say which Access release is able to repair the EA *.eap database.

Don't worry about the extension eap. It's an Access DB.

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Problem when deleting a package manualy
« Reply #9 on: December 13, 2013, 10:59:59 pm »
Don't put too much hope in it. When an Access DB is damaged you can repair it in 0,01% with Access tools. A hacker digging in the guts might be able in some cases. It's like a damaged disk. You can only trust in backups.

q.

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: Problem when deleting a package manualy
« Reply #10 on: December 13, 2013, 11:09:19 pm »
when I tried to open it with MS Access 2010
I got the following error msg :