Access 2007 Runtime problem / ACCDE

[Olda]

I have created *.accde file and *.accdb (only data) from my application. When
I install this files (database and clinet) to new computer (with RunTime
Access 2007 only), I cannot open *.accde file. When i open this file, system
close imediatelly with error. Need to install some components for network
running to Access Runtime ?

 

[Tom Wickerath]

Hi Olda,

I would try repeating this experiment, using the Northwind 2007 database, to
see if the new computer has the same issue. Although I do not have any
experience with run-time installations, if my memory serves me correctly, you
need to ensure that you have proper error-handling for *ALL* VBA procedures
(functions and subroutines). Otherwise, run-time solutions will simply bomb
out to the operating system--that's how it has worked (or not worked) in the
past.

I'd also check the listing of references that you have included in your
application. Verify that any checked references are available, in the same
file path and with the same file version, as they are in your development
machine. Ensure that you do not have any extra references included, that are
not absolutely required. You can determine if a reference is required by
attempting to compile the VBA code after removing said reference (remove one
at a time, making a note of the name). If your code continues to compile
without any errors, then you simply did not need that reference.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Damon Heron]

The Access runtime version is accdr. If you installed the runtime on a pc
that does not have
Access installed, it will only run the accdr.

Damon

 

[emmanuelle longbois]

I have created *.accde file and *.accdb (only data) from my application.
When
I install this files (database and clinet) to new computer (with RunTime
Access 2007 only), I cannot open *.accde file. When i open this file,
system
close imediatelly with error. Need to install some components for network
running to Access Runtime ?

 

[Rick Brandt]

The Access runtime version is accdr. If you installed the runtime on a
pc that does not have
Access installed, it will only run the accdr.

Pretty sure that's incorrect. We have posters in here reporting use of
the 2007 runtime on MDE files. If it will run those then surely it will
run an AccDE.

I thought the AccDR extension was just a way to simulate the runtime on a
machine with the licensed version installed. Not any sort of requirement
of the runtime.

 

[Damon Heron]

I guess I misunderstood this from Microsoft's web page on the runtime:

Microsoft Office Access 2007 provides a rich platform for developing
database management solutions with easy-to-use customization tools. If no
end-user customization is required (including report modifications), you can
choose to distribute those Access 2007 solutions so that they run without
requiring a full installation of Access 2007. To do so, you must package and
distribute your application with the Access 2007 Runtime.

It's the last sentence that seems to suggest you need to package the app (
as a accdr)

Damon

 

[David W. Fenton]

I guess I misunderstood this from Microsoft's web page on the
runtime:

Microsoft Office Access 2007 provides a rich platform for
developing database management solutions with easy-to-use
customization tools. If no end-user customization is required
(including report modifications), you can choose to distribute
those Access 2007 solutions so that they run without requiring a
full installation of Access 2007. To do so, you must package and
distribute your application with the Access 2007 Runtime.

It's the last sentence that seems to suggest you need to package
the app ( as a accdr)

No such thing is suggested by the quote you provide. ACCDR is
nothing but a file extension -- it has nothing to do with packaging
up your ACCDB with the runtime.

 

[Tony Toews [MVP]]

I have created *.accde file and *.accdb (only data) from my application. When
I install this files (database and clinet) to new computer (with RunTime
Access 2007 only), I cannot open *.accde file. When i open this file, system
close imediatelly with error. Need to install some components for network
running to Access Runtime ?

What is the exact text of the error message?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/