MS Access 2007 VBA Problem

[Nick]

Moved database from Access 2003 to Access 2007. Now every so often (too
often) I get a message saying "The database cannot be opened because the VBA
project contained in it cannot be read." It goes on to say that the VBA in
it needs to be deleted, ect. Does anyone have any solution for this problem
and why it is occurring? Help!!

 

[Mike Glen]

Hi Nick,

Try posting on the devloper newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[JulieS]

Hello Nick,

Try posting to a newsgroup for Access -- this is an outdated newsgroup
for Microsoft Project. Try the microsoft.public.access newsgroup.

Julie

 

[attivish]

As you are accessing later version access file on higher version tha
may be cause of error. For solution of this problem you must open thi
file in access 2003 or that may be the cause of error. For solution o
this problem you must open this file in access 2003 or that version i
which it was created. After opening this file go to toll menu an
convert it to newer version database file. Or you can re register th
dao360.dll file and the msrd3x40.dll.
Now Click Start and then click run
type regsvr32 followed by path to your DAO file. Enclose this path i
quotation marks.
Now repeat 2nd step for register the msrd3x40.dll file by using th
following command regsvr32 "c:\\windows\system32\msrd3x40.dll"

If you are still not able to access your database, use Stellar Phoeni
access recovery software fro
http://www.repair-access-file.com/access-mdb-recovery.php. I have use
it once, this software recover whole database in its original format.

Wish you luc

 

[Alan]

As you are accessing later version access file on higher version that
may be cause of error. For solution of this problem you must open this
file in access 2003 or that may be the cause of error. For solution of
this problem you must open this file in access 2003 or that version in
which it was created. After opening this file go to toll menu and
convert it to newer version database file. Or you can re register the
dao360.dll file and the msrd3x40.dll.
Now Click Start and then click run
type regsvr32 followed by path to your DAO file. Enclose this path in
quotation marks.
Now repeat 2nd step for register the msrd3x40.dll file by using the
following command regsvr32 "c:\\windows\system32\msrd3x40.dll"

If you are still not able to access your database, use Stellar Phoenix
access recovery software fromhttp://www.repair-access-file.com/access-mdb-recovery.php. I have used
it once, this softwarerecoverwhole database in its original format.

Wish you luck

--
attivish
------------------------------------------------------------------------
attivish's Profile:http://forums.techarena.in/member.php?userid=47662
View this thread:http://forums.techarena.in/showthread.php?t=926564

http://forums.techarena.in

Hi,

You may also try Advanced Access Repair at http://www.datanumen.com/aar/
This tool is rather useful in salvaging damaged Access MDB files.