Change references using Access 2000 on Windows 95/Citrix?

[joanl]

Hi all,

I'd inherited an Access 97 database. Our IT dept. will no longer support 97, so we were required to convert 97 databases to Access 2000, and this is done. There is one database giving problems.

I have users spread around the state, thus making it harder to see what the problem is with individual users. Some users are on the main server and have no problems at all using the database (using Windows 2000 or XP).

Other users are on the Citrix server and run Windows 95. These users are having problems. I have code behind forms and buttons that perform functions. When they use certain buttons, they receive the "Execution of this application has stopped due to a run-time error. The application can't continue and will shut down." Then they are booted out of the application. Removing the code lets them maneuver around, but they do need the functions.

Everything worked fine for those users before conversion. Is there an issue with Access 2000, Windows 95, and/or Citrix? I was wondering if there were any references that could be missing from the users computers? They are all using Runtime.

Sorry this is so long. Any ideas are really appreciated.

 

[abaldwin]

Removing the code lets them maneuver around, but they do need the functions.

Can you post the code that is giving them fits? Cant give any ideas without seeing the problem.

As for their end being Win95 .... 2 things come to mind.
1. In a citrix environment they are actually working on the server not their machines. Should not matter.

2. They really need to be off 95 anyway. Unsupported operating system from MS and the IT department should be more concerned with the version of the client OS then with the version of office.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[joanl]

Thank you for your response. Here's the code behind the problem button:

Private Sub cmdGetDocket_Click()
On Error GoTo Err_cmdGetDocket_Click
            
Dim db As DAO.Database, rs As DAO.Recordset, crit As String

Set db = CurrentDb()
Set rs = db.OpenRecordset("SELECT * FROM SROMainTable WHERE [myYear] = " & Forms!frmEntry![myYear] & " and  [myCounty] = " & Forms!frmEntry![myCounty] & " and [myType] " & " = '" & Forms!frmEntry![cboTYPE] & "'", dbOpenDynaset)
          
If rs.RecordCount = 0 Then
        Me.newSequence = 1
        Me.ADM_DOCKET = Format(Me.myCounty, "000") & Me.cboTYPE & Me.myYear & Format(Me.newSequence, "0000")
    Else
        Me.sfrmMaxDocket.Requery
        Me.txtSequence.Requery
        Me.newSequence = Me.txtSequence + 1
        Me.ADM_DOCKET = Format(Me.myCounty, "000") & Me.cboTYPE & Me.myYear & Format(Me.newSequence, "0000")
    End If
 
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    
Exit_cmdGetDocket_Click:
    Exit Sub

Err_cmdGetDocket_Click:
    MsgBox Err.Description
    Resume Exit_cmdGetDocket_Click
    
End Sub

 

[abaldwin]

What line is causing the error?

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[joanl]

Is there a way to tell from my machine? I can't replicate the error from my computer. The users with the problem have Runtime.

It works for the other users that aren't on Citrix and have W2k or XP.

I apologize if I seem dense... I've been beating my head over this for a couple of weeks now.

 

[abaldwin]

If they are only having the problem during citrix sessions then yes, as an administrator you can shadow their session and see the error by opening the code before they run it, put a break at the beginning and step through the code to see which line will through you down to the error routines.

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[joanl]

Thanks. Unfortunately, I don't have access to shadowing. I just maintain the database. It's a long story, but the IT person who can shadow is no longer part of our agency (he just hasn't been relocated yet), and a lot of red tape is involved in order to try and get him to help anyone here.

 

[abaldwin]

It sounds like you have bigger problems than this db not running inside your organization. My only other suggestion is that you connect through citrix with your machine and run the application to see if you can get it to fail. Your IT should be able to allow a developer the tools by which to test the application under the production environmnet.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[joanl]

There's also been another person involved in this who used to maintain the database at one time. He has Citrix and XP, but he couldn't replicate the error.

 

[joanl]

I was just told that this was probably a terminal server problem... not Citrix. (that's all I could get from the person I checked with) I'm still at a loss as where to pinpoint the problem.

I'm supposed to receive a machine with Windows 2000 and Citrix for testing purposes.

Any more ideas are welcome.