|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Is there any way this can be done? Have a reliable front-end/back-end setup
and all I want to do is create an exe from the front end so that the problems
of multiple platforms (Ac97, Ac2K, AcXP, Ac2K3) can be avoided. Having used
google and searched ms i tried to get hold of Office 2003 Developers but is
not available from microsoft any more - was redirected to Visual Studio 2005
which i duly (2.3Gb!!!) downloaded but still no further.
Help!
--
New Zealand
|
|
Hi,
there is no conversion to EXE, what you can do - is to create a setup with
Access runtime and install it together with your app.
For Access 2003 you have to purchase Visual Studio Tools for the Microsoft
Office System, I think you can find info on it here:
http://msdn.microsoft.com/office/default.aspx
Also you can look at www.sagekey.com, they offer very good solution to
create application setup with runtime
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Chris Wainwright" <ChrisWainwright[ at ]discussions.microsoft.com> wrote in
message news:5EEBF1F9-24C6-4C52-BF67-0E123734C529[ at ]microsoft.com...
[Quoted Text] > Is there any way this can be done? Have a reliable front-end/back-end
> setup
> and all I want to do is create an exe from the front end so that the
> problems
> of multiple platforms (Ac97, Ac2K, AcXP, Ac2K3) can be avoided. Having
> used
> google and searched ms i tried to get hold of Office 2003 Developers but
> is
> not available from microsoft any more - was redirected to Visual Studio
> 2005
> which i duly (2.3Gb!!!) downloaded but still no further.
>
> Help!
> --
> New Zealand
|
|
No.
Apart from anything else...
Access combines program and data into one file (whether separated into
Frontend/Backend or not). As you know, exe cannot support volatile data, only
fixed data. EXE Programs like (say, Paradox, VB) have the data in a separate
file or files for the table(s).
You could write your app in VisualBasic(say) as an exe, there are some
converters but all advice says the conversions are less-than-adequate.
You might solve Access-dependence, but your app will STILL not be independent
in the way that an MS-DOS exe nearly was. For instance, you will STILL be
dependent on Windows dll's, MDAC or JET dlls, or goodness knows what else.
It is just not that simple.
Developer will do nothing for you, beyond the ability to package and
distribute Access.
Also, you can't download saleable items, only upgrades to such. Otherwise none
of us would need to buy Office or Access!
It is basically ridiculous to imagine you can obtain "independence" by
"producing an exe".
Chris
[Quoted Text] > New Zealand
Oh. I just saw that after writing the above. Of course you can...<VBG>
"Chris Wainwright" <ChrisWainwright[ at ]discussions.microsoft.com> wrote in
message news:5EEBF1F9-24C6-4C52-BF67-0E123734C529[ at ]microsoft.com...
> Is there any way this can be done? Have a reliable front-end/back-end setup
> and all I want to do is create an exe from the front end so that the
problems
> of multiple platforms (Ac97, Ac2K, AcXP, Ac2K3) can be avoided. Having used
> google and searched ms i tried to get hold of Office 2003 Developers but is
> not available from microsoft any more - was redirected to Visual Studio 2005
> which i duly (2.3Gb!!!) downloaded but still no further.
>
> Help!
> --
> New Zealand
|
|
BTW,
I "test converted" one of my apps from Access97 to VB5 (ie "exe"). (I didn't
use any auto-converter)
The forms went quite well. There were installable dll's or ocx's to get much
the same behaviour from form fields (combo boxes or the like)(yes, basic VB
was DIFFERENT from Access)
I could implement Access Security (so far as I recall).
But where I came unstuck, was that VB has no Report equivalent at all! It
seemed to rely on using Crystal Reports for reports.
No problem! I'll just learn Crystal Reports! Let me just say that the end
result was that I thought it easier to distribute in Access!!!
I do not imagine I have the only opinion, others are as much of interest to
me.
HTH
Chris
|
|
Hi Alex - thanks for the prompt reply. The "real world" problem is that I
have users running 97, 2000, Xp and 2003 so I dont want to distribute the app
with runtime as this might stuff up their installs and will not win me any
friends. Is it possible to port the front end into Visual Studio in any way?
--
New Zealand
"Alex Dybenko" wrote:
[Quoted Text] > Hi, > there is no conversion to EXE, what you can do - is to create a setup with > Access runtime and install it together with your app. > > For Access 2003 you have to purchase Visual Studio Tools for the Microsoft > Office System, I think you can find info on it here: > http://msdn.microsoft.com/office/default.aspx> > > Also you can look at www.sagekey.com, they offer very good solution to > create application setup with runtime > > -- > Best regards, > ___________ > Alex Dybenko (MVP) > http://alexdyb.blogspot.com> http://www.PointLtd.com> > "Chris Wainwright" <ChrisWainwright[ at ]discussions.microsoft.com> wrote in > message news:5EEBF1F9-24C6-4C52-BF67-0E123734C529[ at ]microsoft.com... > > Is there any way this can be done? Have a reliable front-end/back-end > > setup > > and all I want to do is create an exe from the front end so that the > > problems > > of multiple platforms (Ac97, Ac2K, AcXP, Ac2K3) can be avoided. Having > > used > > google and searched ms i tried to get hold of Office 2003 Developers but > > is > > not available from microsoft any more - was redirected to Visual Studio > > 2005 > > which i duly (2.3Gb!!!) downloaded but still no further. > > > > Help! > > -- > > New Zealand > > |
|
I knew it wouldn't be simple (when is it ever!?).
As there is no data stored in the front end I thought I might be able to
convert this and leave the back-end as an mde file accessed by the new exe
front end. i dont mind being OS dependant, but would definitely rather be
end-user Access independant as I have, at present, to write 4 different code
versions (97,2000,XP, 2003!).
How did you do your "test conversion" - cut'n'paste or something (more
likely) more complicated :-)
--
New Zealand
"Chris Mills" wrote:
[Quoted Text] > No.
>
> Apart from anything else...
>
> Access combines program and data into one file (whether separated into
> Frontend/Backend or not). As you know, exe cannot support volatile data, only
> fixed data. EXE Programs like (say, Paradox, VB) have the data in a separate
> file or files for the table(s).
>
> You could write your app in VisualBasic(say) as an exe, there are some
> converters but all advice says the conversions are less-than-adequate.
>
> You might solve Access-dependence, but your app will STILL not be independent
> in the way that an MS-DOS exe nearly was. For instance, you will STILL be
> dependent on Windows dll's, MDAC or JET dlls, or goodness knows what else.
>
> It is just not that simple.
>
> Developer will do nothing for you, beyond the ability to package and
> distribute Access.
>
> Also, you can't download saleable items, only upgrades to such. Otherwise none
> of us would need to buy Office or Access!
>
> It is basically ridiculous to imagine you can obtain "independence" by
> "producing an exe".
> Chris
>
> > New Zealand
> Oh. I just saw that after writing the above. Of course you can...<VBG>
>
> "Chris Wainwright" <ChrisWainwright[ at ]discussions.microsoft.com> wrote in
> message news:5EEBF1F9-24C6-4C52-BF67-0E123734C529[ at ]microsoft.com...
> > Is there any way this can be done? Have a reliable front-end/back-end setup
> > and all I want to do is create an exe from the front end so that the
> problems
> > of multiple platforms (Ac97, Ac2K, AcXP, Ac2K3) can be avoided. Having used
> > google and searched ms i tried to get hold of Office 2003 Developers but is
> > not available from microsoft any more - was redirected to Visual Studio 2005
> > which i duly (2.3Gb!!!) downloaded but still no further.
> >
> > Help!
> > --
> > New Zealand
>
>
>
>
>
|
|
No, not sure you can do this. The simplest way could be to make 2
application versions - for access 97 and for 2000/xp/2003, I do the same
with several apps, and it works great. I make changes in 97 and then convert
it to 2000 version.
--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Chris Wainwright" <ChrisWainwright[ at ]discussions.microsoft.com> wrote in
message news:DDB4AF82-C26D-4B91-B66E-A1CC467FCE8A[ at ]microsoft.com...
[Quoted Text] > Hi Alex - thanks for the prompt reply. The "real world" problem is that I > have users running 97, 2000, Xp and 2003 so I dont want to distribute the > app > with runtime as this might stuff up their installs and will not win me any > friends. Is it possible to port the front end into Visual Studio in any > way? > -- > New Zealand > > > "Alex Dybenko" wrote: > >> Hi, >> there is no conversion to EXE, what you can do - is to create a setup >> with >> Access runtime and install it together with your app. >> >> For Access 2003 you have to purchase Visual Studio Tools for the >> Microsoft >> Office System, I think you can find info on it here: >> http://msdn.microsoft.com/office/default.aspx>> >> >> Also you can look at www.sagekey.com, they offer very good solution to >> create application setup with runtime >> >> -- >> Best regards, >> ___________ >> Alex Dybenko (MVP) >> http://alexdyb.blogspot.com>> http://www.PointLtd.com>> >> "Chris Wainwright" <ChrisWainwright[ at ]discussions.microsoft.com> wrote in >> message news:5EEBF1F9-24C6-4C52-BF67-0E123734C529[ at ]microsoft.com... >> > Is there any way this can be done? Have a reliable front-end/back-end >> > setup >> > and all I want to do is create an exe from the front end so that the >> > problems >> > of multiple platforms (Ac97, Ac2K, AcXP, Ac2K3) can be avoided. Having >> > used >> > google and searched ms i tried to get hold of Office 2003 Developers >> > but >> > is >> > not available from microsoft any more - was redirected to Visual Studio >> > 2005 >> > which i duly (2.3Gb!!!) downloaded but still no further. >> > >> > Help! >> > -- >> > New Zealand >> >>
|
|
Chris Wainwright wrote:
[Quoted Text] > I knew it wouldn't be simple (when is it ever!?).
>
> As there is no data stored in the front end I thought I might be able
> to convert this and leave the back-end as an mde file accessed by the
> new exe front end. i dont mind being OS dependant, but would
> definitely rather be end-user Access independant as I have, at
> present, to write 4 different code versions (97,2000,XP, 2003!).
>
> How did you do your "test conversion" - cut'n'paste or something (more
> likely) more complicated :-)
No, you need TWO versions, 97 and 2000. Access 2002 and 2003 will run a
2000 MDE just fine.
I distribute to several hundred users and my installer asks the user which
version of Access they have and installs the appropriate version files and
shortcuts. If they have no version of Access then there is an option to
install the 97 runtime. I have had no problems with this setup.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
|
|