Install Ac95 On W2003 srv

[Lorenzo\(pyx_\)]

Hello,
Do anyone know if it's possible to install Access95 on W2003 server ?
The Ram size is over 512Mbyte, i know about *OutOfMemory* problem.
On W2000 srv i fix it with jet update, but this don't work on W2003 srv.

Thanks
Lorenzo

 

[Tony Toews]

Do anyone know if it's possible to install Access95 on W2003 server ?
The Ram size is over 512Mbyte, i know about *OutOfMemory* problem.
On W2000 srv i fix it with jet update, but this don't work on W2003 srv.

Our knowledge of A95 is very limited as we dumped it as soon as A97
was out. Also it's a general rule that you don't install client
software on a server.

So why would you want to?

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

 

[Lorenzo\(pyx_\)]

Our knowledge of A95 is very limited as we dumped it as soon as A97
was out. Also it's a general rule that you don't install client
software on a server.

So why would you want to?

Tony
--

Right question (!), but so long to explain, i try... sorry for my english,

Is a ten years old MRP program that receive data from a Host,
elaborate and give the final report. It's not possible to convert
it because is damaged in many object, it's not possible to export
some code or other object, more, it use the old vba sintax.
If it don't work, the company ( i ) replace this database with a backup
copy (the data is always refreshed from host).
I estimated about 1 week to rewrite this program in Ac2k3 because
the code is visible and i can make a copy-paste but the company
don't want to spend money, they say : it works .....

Now, i write ten years ago this MRP program, i write the actual
main-host program in Ac2k3 runtime and BE on SQL server and it's
about one year that i work by myself from home via T.S. with
this company.
So, for the moment i export data in MRP program and copy it via ftp
on a mine secondary workstation at home with W2000 and it work.

I put the ftp time on my weekly invoice and i hope that
the company decide about the program-upgrade ;-)

Thanks
Lorenzo

 

[Tony Toews]

Right question (!), but so long to explain, i try... sorry for my english,

Is a ten years old MRP program that receive data from a Host,
elaborate and give the final report. It's not possible to convert
it because is damaged in many object, it's not possible to export
some code or other object, more, it use the old vba sintax.

Using the old VBA syntax ought to be fine. At least to get it into
A97. As far as damaged objects go it might, and I do emphasize might,
be possible. I don't know if this works in A95.

The undocumented SaveAsText and LoadFromText may help if an object is
corrupted or otherwise behaving weirdly.
At the debug/immediate window type:
Application.SaveAsText acForm,"MyForm","c:\form.txt
You can load the file into a new MDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code at http://www.datastrat.com/Code/DocDatabase.txt

Have you tried converting the MDB using Access 97 or possible A2003?

But as far as your original problem, installing and running A95 on a
Win 2003 Server, I have no idea as to what the answer is. And the
chances of finding someone with the answer are very, very slim.

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

 

[Lorenzo\(pyx_\)]

Right question (!), but so long to explain, i try... sorry for my
english,

[...]

Using the old VBA syntax ought to be fine. At least to get it into
A97. As far as damaged objects go it might, and I do emphasize might,
be possible. I don't know if this works in A95.

May be, The factory have legal license for about 100user AC95, 1 Office Xp
Developer and, no so much months ago , receive from me a legal Ac2k3
runtime via Visual STudio Tools.

The undocumented SaveAsText and LoadFromText may help if an object is
corrupted or otherwise behaving weirdly.
At the debug/immediate window type:
Application.SaveAsText acForm,"MyForm","c:\form.txt
You can load the file into a new MDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code at http://www.datastrat.com/Code/DocDatabase.txt

Have you tried converting the MDB using Access 97 or possible A2003?

Oh ! Oh ! , I know that undocumented function, but forget they......

I test a direct conversion to Ac2k3 (!)

But as far as your original problem, installing and running A95 on a
Win 2003 Server, I have no idea as to what the answer is. And the
chances of finding someone with the answer are very, very slim.

Yes i know, but no problem about this. That server is "hardware"
spare parts, also test server separated from domain. This factory,
my client now, have enough main servers , for the web, exchange,
sql data, proxy and a dmz zone. I don't like vpn solution and so they
have an hardware firewall with nat that permit the connection only
to my public IP.

Anyway the last week all works fine because the actual server which
one i remoting work was with W2000srv, now upgraded to W2003 srv.
I look on NG only for immediate solution , if any.

I think that the right solution is to rewrite the code, now i'm able to
write better then "spaghetti-code" referring to ten years ago

Many Thanks for the attention !
Bye

Lorenzo