By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,617 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,617 IT Pros & Developers. It's quick & easy.

Access 2k bugs?

P: n/a
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


Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

P: n/a
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
>
>
>
>



Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

P: n/a

"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


Nov 13 '05 #6

P: n/a
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

Nov 13 '05 #7

P: n/a
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

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.