Help!!!!!!!!!

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

I am designing a database using Access 2000.

The file was running very well until a moment ago. An
error message appeared like "can't access data file,
network connection may be lost." something like that. I
then created another empty DB and imported all
table/query/form to this new one. Another error message
like "name conflict". Some clicks for nevagating to
another form can't work now. For those forms, I can't
even open VB window.

I don't think I didn't something "illegal". But somehow
the DB is corrupted...

Any help is greatly appreciated!!!

Thanks,

Shirley
 
Shirley said:
I am designing a database using Access 2000.

The file was running very well until a moment ago. An
error message appeared like "can't access data file,
network connection may be lost." something like that. I
then created another empty DB and imported all
table/query/form to this new one. Another error message
like "name conflict". Some clicks for nevagating to
another form can't work now. For those forms, I can't
even open VB window.

I don't think I didn't something "illegal". But somehow
the DB is corrupted...

See this KB article describing the nasty bug that has bitten you:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Office 2000 SP3 fixes the bug, but that won't repair your corrupted
database. You'll have to resort to a backup, or else try importing all
objects to a new database -- some objects probably won't import, and
you'll have to recreate them from scratch. When you do import the
objects, unless you've applied the service pack, it is *crucial* that
you compile and save the project before closing the database. This may
well be where you went wrong in your first attempt to fix it by
importing.
 
hi, i hope this problem occured when you copied some forms
instead of creating new forms. Duplication of cammand
buttons which running eventprocedures will make this
problem, there could be more event procedures with same
command button name existing in your application. Try to
locate each command button and eventprocedure,, remane
all.. will work,, good luck
 
Back
Top