AccessXP and Access2000 on the same terminal server

  • Thread starter Per Ove Steinsland
  • Start date
P

Per Ove Steinsland

Hi.
I have a Problem with one of my AccessXP applictions when it is installed on
a win2000 terminal server sp3

The server has Access2000 (full version) also installed.
I have installed a AccessXP runtime to make my program to run.

I have made a small "test.mdb" to narrow down the problem.
Test.mdb just contains two forms.
Form1 and Form2.
Form1 is the startup form and Form1 has one button.

The code on form1 is just :
*****
Private Sub Command1_Click()
DoCmd.OpenForm "Form2", , , stLinkCriteria
End Sub

Private Sub Form_Load()
MsgBox Access.Version
MsgBox "hello world"
End Sub
*****
It is just a Sub when the form loads and one when the button is clicked....
pure and simple


When I start my Test.mdb I do it trough a shortcut like this:
C:\Program Files\Microsoft Access 2002 Runtime\Office10\Msaccess.exe /
runtime C:\Myprog.MDB
(to be sure that I start the app. in the correct version of access. )

So the first time I start Test.mdb, Form1 is loaded and I get everything
correct from my msgbox'es
10.0
Hello World

Then I close down the app.

When I start Access2000 (start->program->access2000), and then close it
again, My application "test.mdb" starts to behave strange when I start it
again :
It starts to install something (a "installing components" window comes up)
and the msgboxes does not come up at all. And when I click on the button
nothing happens.
So the code on the form does not work!

I have to re-install the runtime to make it work properly again.

BTW.
This is not the normal "you start your application in the wrong version of
access" problem. (Remember that Form1 does indeed loads . It is just the
code on the form that stopped working after I start/stop access2000.

And... BTW BTW
I Did indeed install the runtime using the:
CHANGE USER /INSTALL & CHANGE USER /EXECUTE (also did it trough add remove
programs)

anyone..??
.. WHY does not code on form work after I start/stop access2000

perove
 
P

Per Ove Steinsland

Yes. Thanks. Seem like Tony's contain more info hon how to orgainze this
within Access. My problem is multiple office version on the same machine..
perove
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top