Access 2003 Developer Extension

[Guest]

Hello,
We have Microsoft Office 2003 Standard version running in our windows 2000
terminal server, we have a license per user for this standard version of
office (no Access 2003 is included) . Now, we developed an Access 2003
applications and want to get people run it in the terminal server. We bought
Access 2003 Developer Extension to be able to get user run Access 2003
runtime version and not buying license for Access 2003.

The problem is: When I try to install Access 2003 Developer Extension, it
seems it requires Access 2003, is that the case? If I have Access 2003
installed in the terminal server I need to get a license per user, what is
the point of Access 2003 Developer Extension, I am a little bit confused. Any
help will be greatly appreciated.
Thanks,
Jim.

 

[Paul Overway]

ADE allows you to build a distributable package for your database
application, and include the Access runtime (if needed). So, you really
shouldn't be installing ADE on the server....it needs to be installed on the
PC where you're developing the application. Obviously, you DO need to have
Access installed on the PC you're developing the application on also.

 

[Guest]

Paul,
Thanks for the reply.
If that is the case, how should I build my mde so that it can run on the
terminal server which does not have an Access installed.

Right now, I am creating mde in Access and getting user call it through a
batch file (like START msaccess.exe <mde-file-name> with some other startup
parameters ) I need to use batch file the same way I am suing, because there
are other settings I have there. Can you give me a site that talks about this?
Thanks,
Jim.

 

[Paul Overway]

If the terminal server doesn't have Access installed, you obviously need to
install it (or the Access runtime). Your database needs Access, either
retail or runtime, in order for it to run. As far as a site, I'd suggest
reading the documentation for ADE for starters. I'm not really sure what
you're looking for here...you do realize that Access (retail or runtime) is
required for your application, don't you?

 

[Guest]

Thanks Paul,
I am new on this issue. I thought runtime version is Access 2003 Developer
Extension and I was trying to install it to a Terminal Sever. But it
requires Access installed there.

On the terminal server, I can not install full access since it requires more
license to buy, however I think I can install runtime, does Access 2003
Developer Extension provide runtime for Access 2003 I can install? If not,
where can I get it?
Thanks,
Jim.

 

[Paul Overway]

No....ADE allows you to package and distribute your application and the
Access runtime. That is what it is for. After you package your application
and include the runtime in the package you can install THAT package on
terminal server or whatever. You can't just install ADE on the terminal
server....and it wouldn't do you any good if you did. ADE is for packaging
Access applications....not running them.

 

[Guest]

Thank Paul,
I see there is a package wizard. Let say I used package wizard and create
the package and installed it into terminal server, I would assume it will
take mdb or mde and put into somewhere in the terminal server. How can I run
mde in the command line? Can you give me command line example?
Jim.

 

[Douglas J. Steele]

<full path to msaccess.exe> <full path to mde file>

Like:

"C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe"
"C:\Database\MyApp.mde"

 

[Guest]

Thanks Douglas,

I installed the package I created with ADE 2003 and I do not see
msaccess.exe in the path you gave. Am I doing something wrong?
Thanks,
Jim.

 

[Douglas J. Steele]

I never meant that's exactly where the file is going to exist. Do a search
for msaccess.exe on the hard drive.

 

[Guest]

Thanks Douglas,
Think I had a problem with my package, I recreated it and did installation
again, it is working fine now, thanks for your help.
Jim.