access 2007 error in 64 bits environments

February 09th, 2011 - 05:33 pm ET by Alain Bourgeois | Report spam
Hi,

I can't make an application run on win7/64 bits with access run-time (ok for
32 bits).
I can reproduce the problem as this:
from my 32 bits pc:
* take access 2003, file/new database=> dbEmpty.mdb
* take access 2003, file/new database=> db1Tab.mdb, import 1 table from
an existing application

=> Copy these 2 files on a computer with win 7 64bits (or vista 64 bits),
and access rutime, in my documents.
Double click dbEmpty.mdb=> OK
Double click db1Tab.mdb=> Error (although there is only one table and no
code is run). I get the same error when opening any application.
I have the same error trying to open applications (that run with win 7 /32
bits/ a2k7 runtime).

Can someone help? The mdb's can be retrieved at
http://www.self-mail.com/buga2k7r/db1Tab.mdb and
http://www.self-mail.com/buga2k7r/dbEmpty.mdb
Is there something to do to "trust" or "convert" applications in 64 bits?

Regards,
Alain
email Follow the discussionReplies 9 repliesReplies Make a reply

Replies

#1 Alain Bourgeois
February 10th, 2011 - 05:13 pm ET | Report spam
If other people are searching for this issue, I found the solution (lots of
forum say this problem occurs but none gave a solution):

1. From the 64-bits computer access run-time 2007 is installed: share the
folder holding the mdb file.

2. From another computer in the same network with access 2007 (in my case
win xp pro xp3 with access 2007): explore to share and open the database
with access 2007 UK. Close the database.

3. Double-clic the mdb file on 64 bits computer, no error anymore...
Great.



Subsidiary question for MS guys: more and more computers will be 64 bits. As
developer, I would like to avoid having to build one installshield for 64
bits computers and another for 32 bits computers.

Isn't there a better solution? The problem is very easy to reproduce!



Regards,
Alain

"Alain Bourgeois" wrote in message
news:4d531651$0$14263$
Hi,

I can't make an application run on win7/64 bits with access run-time (ok
for 32 bits).
I can reproduce the problem as this:
from my 32 bits pc:
* take access 2003, file/new database=> dbEmpty.mdb
* take access 2003, file/new database=> db1Tab.mdb, import 1 table from
an existing application

=> Copy these 2 files on a computer with win 7 64bits (or vista 64 bits),
and access rutime, in my documents.
Double click dbEmpty.mdb=> OK
Double click db1Tab.mdb=> Error (although there is only one table and no
code is run). I get the same error when opening any application.
I have the same error trying to open applications (that run with win 7 /32
bits/ a2k7 runtime).

Can someone help? The mdb's can be retrieved at
http://www.self-mail.com/buga2k7r/db1Tab.mdb and
http://www.self-mail.com/buga2k7r/dbEmpty.mdb
Is there something to do to "trust" or "convert" applications in 64 bits?

Regards,
Alain

Similar topics