Well, look at the system tables and see if anything looks amiss.(options/view/show)
You might also try importing just the table definitions. Run your app to see if everything opens like it should. Another suggestion is to import tables/forms/reports/queries separately and test as you go along. Has the app been compiled?
Try these, and let us know how it goes.
TJ
Ahmed Eltawil <[EMAIL PROTECTED]> wrote:
You might also try importing just the table definitions. Run your app to see if everything opens like it should. Another suggestion is to import tables/forms/reports/queries separately and test as you go along. Has the app been compiled?
Try these, and let us know how it goes.
TJ
Ahmed Eltawil <[EMAIL PROTECTED]> wrote:
All tables imported just fine, however I can't import, open, open
design any form, report, macro, seems that the problem is with a
system table, I tried Microsoft Jet Compact Utility but nothing
happened, any suggestions?
Tawtaw
--- In [email protected], Trent Johnsey <[EMAIL PROTECTED]>
wrote:
>
> Try importing all of the tables into a new database instance.
Depending on how bad the corruption is, the offending tables may or
may not come over to the new instance. If the process hangs on a
certain table (while trying to build indexes), then you have your
answer. If it doesn't hang, then your indexes will have been
rebuilt per original spec in the new instance.
>
> If a certain table fails, then you will have to remove the
indexes (including primary keys), and run a query to find the
records blowing up your indexes. if you remove the offending
records, then the table should reindex just fine. if the reindex
fails, then you haven't gotten all of the records. Records
offending the primary key are normally the offenders. I would still
import the now fixed table to the new instance. Hope this helps.
Not that i have ever had to rebuild a blown up table before ;).
> TJ
>
> Ahmed Eltawil <[EMAIL PROTECTED]> wrote: Thanks Cathy for
ur quick response, the problem is that the error
> message doesn't specify a table name the database have about
120
> tables how could I specify those tables causing the error.
> One of the suspected tables is a system table "MSysAccessStorage"
> which I can't change any thing in.
> Regards
> Tawtaw
>
>
> --- In [email protected], "Cathy Jupp"
> <[EMAIL PROTECTED]> wrote:
> >
> > I had this happen once. It turned out to be mild database
> corruption that had deleted several of my indices. Use deisgn
mode
> on the table that the message refers to and check that each index
you
> expect to be there still exists, and if not, recreate it.
> > A quick glace through your tables might be in order also - when
> this happened to me I also found a couple of spurious rows in the
> table that had lost its index.
> > Good luck.
> > cheers
> > Cathy
> >
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[EMAIL PROTECTED] Behalf Of Ahmed
Eltawil
> > Sent: 04 December 2005 12:11
> > To: [email protected]
> > Subject: [AccessDevelopers] Error 3800 is not an Index in this
table
> >
> >
> > Hello,
> >
> > I'm having a problem with Access 2003 SP1. Some forms couldn't
be
> > opened and when I repaired the DB this message popped up 3 or 4
> times:
> > 'id' is not an Index in this table
> > The message pops up every time I open the database and I can
still
> open
> > the tables and queries but not the Forms.
> > I have no idea of what could be causing this problem, and I'd
> > appreciate any help you could give.
> >
> > Tawtaw,
> > Access developer
> >
>
>
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "AccessDevelopers" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> ---------------------------------
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Personals
> Let fate take it's course directly to your email.
> See who's waiting for you Yahoo! Personals
>
> ---------------------------------
> Yahoo! Personals
> Skip the bars and set-ups and start using Yahoo! Personals for free
>
Yahoo! Personals
Skip the bars and set-ups and start using Yahoo! Personals for free
Yahoo! DSL Something to write home about. Just $16.99/mo. or less
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
