Access 2k bugs?

[Paul T. Rong]

Dear all,

It is very close to the end of finishing a database, the last report I am
making is kaput, what I want to do is while the report is opening, a dialog
form will open first for the user to input the [StartDate] and the
[EndDate], something I copied from Northwind. Ok, it worked as long as I
didn't exit Access 2k, the report refuses to open and there is a error,
saying the module (to the report) can not be found. And it is true, I can
not go in to view any codes attached to the report that I wrote a minute
ago.

I tried all day, it just didn't work, I checked from the internet, nope. I
almost decided to give up to try some new solution, when I happen to run the
database in Access XP, no problem, fast, accurate.

I was shocked and very much puzzeled.

Is there anything I can do? Like a upgrade or something? Any help is very
much appreciated.
Paul

[Paul T. Rong]

Man, it is weird.

I reinstalled Access 2k, and tried the database. When I click on the
"problematic" report, an error says,"the project of Visual Basic for
Application in the database has been damaged" (I translated from Slovak).
And then Access 2k stopped responding. I had to use ctrl + alt+ del keys to
end the program.

Immediately I started again, but this time it worked perfect.

THen I tried more 10 times. NO PROBLEM!

I am worried if the database could function normally afterwards....

Man, I am considering giving up Access, giving up programming at all, that
is something too irreliable, too complicated and difficult to grasp.

Paul

"Paul T. Rong" <et***@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:ou******************@news.chello.at...

Dear all,

It is very close to the end of finishing a database, the last report I am
making is kaput, what I want to do is while the report is opening, a dialog form will open first for the user to input the [StartDate] and the
[EndDate], something I copied from Northwind. Ok, it worked as long as I
didn't exit Access 2k, the report refuses to open and there is a error,
saying the module (to the report) can not be found. And it is true, I can
not go in to view any codes attached to the report that I wrote a minute
ago.

I tried all day, it just didn't work, I checked from the internet, nope. I
almost decided to give up to try some new solution, when I happen to run the database in Access XP, no problem, fast, accurate.

I was shocked and very much puzzeled.

Is there anything I can do? Like a upgrade or something? Any help is very
much appreciated.
Paul

[Paul T. Rong]

Maybe I made some mistakes on naming reports and forms etc. will check them
totally tomorrow.

Paul
"Paul T. Rong" <et***@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:gM*******************@news.chello.at...

Man, it is weird.

I reinstalled Access 2k, and tried the database. When I click on the
"problematic" report, an error says,"the project of Visual Basic for
Application in the database has been damaged" (I translated from Slovak).
And then Access 2k stopped responding. I had to use ctrl + alt+ del keys to end the program.

Immediately I started again, but this time it worked perfect.

THen I tried more 10 times. NO PROBLEM!

I am worried if the database could function normally afterwards....

Man, I am considering giving up Access, giving up programming at all, that
is something too irreliable, too complicated and difficult to grasp.

Paul

"Paul T. Rong" <et***@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:ou******************@news.chello.at...

Dear all,

It is very close to the end of finishing a database, the last report I am making is kaput, what I want to do is while the report is opening, a

dialog

form will open first for the user to input the [StartDate] and the
[EndDate], something I copied from Northwind. Ok, it worked as long as I
didn't exit Access 2k, the report refuses to open and there is a error,
saying the module (to the report) can not be found. And it is true, I can not go in to view any codes attached to the report that I wrote a minute
ago.

I tried all day, it just didn't work, I checked from the internet, nope. I almost decided to give up to try some new solution, when I happen to run

the

database in Access XP, no problem, fast, accurate.

I was shocked and very much puzzeled.

Is there anything I can do? Like a upgrade or something? Any help is very much appreciated.
Paul

[Alan Webb]

Paul,
Do the usual maintenance things, compact & repair to a new file, etc. Then
thoroughly debug your code. And make sure you preserve the knarly .mdb in
case further changes make things worse and you have to return to a known
starting point.

"Paul T. Rong" <et***@hotmail.com> wrote in message
news:_T*******************@news.chello.at...

Maybe I made some mistakes on naming reports and forms etc. will check
them
totally tomorrow.

Paul
"Paul T. Rong" <et***@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:gM*******************@news.chello.at...

Man, it is weird.

I reinstalled Access 2k, and tried the database. When I click on the
"problematic" report, an error says,"the project of Visual Basic for
Application in the database has been damaged" (I translated from Slovak).
And then Access 2k stopped responding. I had to use ctrl + alt+ del keys

to

end the program.

Immediately I started again, but this time it worked perfect.

THen I tried more 10 times. NO PROBLEM!

I am worried if the database could function normally afterwards....

Man, I am considering giving up Access, giving up programming at all,
that
is something too irreliable, too complicated and difficult to grasp.

Paul

"Paul T. Rong" <et***@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:ou******************@news.chello.at...

> Dear all,
>
> It is very close to the end of finishing a database, the last report I am > making is kaput, what I want to do is while the report is opening, a

dialog

> form will open first for the user to input the [StartDate] and the
> [EndDate], something I copied from Northwind. Ok, it worked as long as
> I
> didn't exit Access 2k, the report refuses to open and there is a error,
> saying the module (to the report) can not be found. And it is true, I can > not go in to view any codes attached to the report that I wrote a
> minute
> ago.
>
> I tried all day, it just didn't work, I checked from the internet,
> nope. I > almost decided to give up to try some new solution, when I happen to
> run

the

> database in Access XP, no problem, fast, accurate.
>
> I was shocked and very much puzzeled.
>
> Is there anything I can do? Like a upgrade or something? Any help is very > much appreciated.
>
>
> Paul
>
>
>
>

[Allen Browne]

As a general guide, see:
Preventing Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-25.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Paul T. Rong" <et***@hotmail.com> wrote in message
news:_T*******************@news.chello.at...

Maybe I made some mistakes on naming reports and forms etc. will check
them
totally tomorrow.

Paul
"Paul T. Rong" <et***@hotmail.com> P4HkO{O"PBNE
:gM*******************@news.chello.at...

Man, it is weird.

I reinstalled Access 2k, and tried the database. When I click on the
"problematic" report, an error says,"the project of Visual Basic for
Application in the database has been damaged" (I translated from Slovak).
And then Access 2k stopped responding. I had to use ctrl + alt+ del keys

to

end the program.

Immediately I started again, but this time it worked perfect.

THen I tried more 10 times. NO PROBLEM!

I am worried if the database could function normally afterwards....

Man, I am considering giving up Access, giving up programming at all,
that
is something too irreliable, too complicated and difficult to grasp.

Paul

"Paul T. Rong" <et***@hotmail.com> P4HkO{O"PBNE
:ou******************@news.chello.at...

> Dear all,
>
> It is very close to the end of finishing a database, the last report I am > making is kaput, what I want to do is while the report is opening, a

dialog

> form will open first for the user to input the [StartDate] and the
> [EndDate], something I copied from Northwind. Ok, it worked as long as
> I
> didn't exit Access 2k, the report refuses to open and there is a error,
> saying the module (to the report) can not be found. And it is true, I can > not go in to view any codes attached to the report that I wrote a
> minute
> ago.
>
> I tried all day, it just didn't work, I checked from the internet,
> nope. I > almost decided to give up to try some new solution, when I happen to
> run

the

> database in Access XP, no problem, fast, accurate.
>
> I was shocked and very much puzzeled.
>
> Is there anything I can do? Like a upgrade or something? Any help is very > much appreciated.
>
>
> Paul

[Darryl Kerkeslager]

"Allen Browne" <Al*********@SeeSig.Invalid> wrote:

As a general guide, see:
Preventing Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-25.html

I would add two items to your list when developing the front end mdb:

1. Always manually compile after making changes, before closing, rather than
just closing the database and testing.

2. Never import a form or report from a newer version of Access into an
older version.
Darryl Kerkeslager

[Paul T. Rong]

Thank you very much for your advise. I tried that. Very good.

Today, I checked all the names of the control and object, just to be sure
that there is not any naming conflict in the project.

Till now the database works without abnormality.

But what happened to me yesterday remains a puzzel.

Maybe the Access 2k was corrupt? Because after reinstalling Access the db
works fine (except the first time).

Paul
"Darryl Kerkeslager" <Ke*********@comcast.net> дÈëÏûÏ¢ÐÂÎÅ
:xo********************@comcast.com...

"Allen Browne" <Al*********@SeeSig.Invalid> wrote:

As a general guide, see:
Preventing Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-25.html
I would add two items to your list when developing the front end mdb:

1. Always manually compile after making changes, before closing, rather

than just closing the database and testing.

2. Never import a form or report from a newer version of Access into an
older version.
Darryl Kerkeslager

[david epsom dot com dot au]

Access 2K and Access XP both create binary versions of the code,
and run the binary version when you open the report. The binary
version for 2K is SEPERATE and DIFFERENT from the XP version, so
you can have a report where the binary version of the code is
damaged in one version, but not in the other.

To clean out damaged binary ('compiled') code, you should use
the /Decompile command line option. Make a backup copy of the
database, then create a new shortcut to MSACCESS.EXE On the
command line of the shortcut, after MSACCESS.EXE", put the
full path to the database (use "quotes" around the full path),
then put /decompile /compact.

....msaccess.exe" "c:\mydb.mdd" /decompile /compact

(david)

"Paul T. Rong" <et***@hotmail.com> wrote in message
news:ou******************@news.chello.at...

Dear all,

It is very close to the end of finishing a database, the last report I am
making is kaput, what I want to do is while the report is opening, a dialog form will open first for the user to input the [StartDate] and the
[EndDate], something I copied from Northwind. Ok, it worked as long as I
didn't exit Access 2k, the report refuses to open and there is a error,
saying the module (to the report) can not be found. And it is true, I can
not go in to view any codes attached to the report that I wrote a minute
ago.

I tried all day, it just didn't work, I checked from the internet, nope. I
almost decided to give up to try some new solution, when I happen to run the database in Access XP, no problem, fast, accurate.

I was shocked and very much puzzeled.

Is there anything I can do? Like a upgrade or something? Any help is very
much appreciated.
Paul