• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2592
  • Last Modified:

Run-time error 2683

I have an Access 97 polling database that I split and made changes to.  It all seems to work fine from my PC which has the entire access package loaded.  However any pc with the run-time version is giving me the following errors when I try to poll.  I can view things and run reports, just not poll on the run-time PC's.  Any suggestions?
Run-time error 2683
Execution of this application has stopped due to run-time error
Field lock Trans.Patron can't be zero length string.
Index on primary key can't contain null value.
0
BobRosas
Asked:
BobRosas
  • 6
  • 2
  • 2
  • +1
1 Solution
 
ImoutwestCommented:
Error 2683 - There is no object in this control.

Seems that you have created an index on a field/control that has empty data in that control.

Open your backend and look at your table and see if this is true and correct the Null values.
0
 
BobRosasAuthor Commented:
I only changed two tables and can't find a problem in either one but I'll keep looking.  However, I forgot something else important.  The database I split was polling and working daily before I split it.  After I split it I added my front end with the new code to the old backend with the current data.  Because of that I noticed that the references didn't match so I fixed that but I'm still getting the same errors.

I did add several new fields in my code but I also updated the split backend with those fields and populated them with zeros.
0
 
ImoutwestCommented:
Front-End is your queries, forms, reports, etc.?
Back_End is just your tables?

Is it possible that the tables are not linked correctly between the backend and front end? Re-Link or delete the linked table in your front-end and then re-link the table from scratch. Other than that this is beyond my experience, hopefully one-of the experts will jump in. Sorry I couldn't help more, Imoutwest
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
rockiroadsCommented:
to me this message

Field lock Trans.Patron can't be zero length string.

is saying that the field Patron in the table  lock Trans  has the setting of Allow Zero Length to False (open up table in design view in backend)
If u set this to True, what happens?

this is also what Imoutwest has said
0
 
rockiroadsCommented:
If u change the table definition, check the frontend, though u cant make changes u can see the field properties. U may need to relink this table
0
 
nico5038Commented:
Hmm, did you check the references on those other PC's ?

Add this (slightly modified) function cactus_data wrote and activate it from e.g. an additional button:

Public Function ReferencesClean() As Boolean

' Remove all missing references.
' Return True if no reference was broken.
'
' 2001-08-20. Cactus Data ApS, CPH.

  Dim ref         As Reference
  Dim lngItem     As Long
  Dim booMissing  As Boolean
 
  With References
    For lngItem = .Count To 1 Step -1
      Set ref = .Item(lngItem)
      If ref.BuiltIn = True Then
        ' No need to check built in reference.
      ElseIf ref.IsBroken Then
         MsgBox "Missing ref: " & ref.Name
      End If
    Next
  End With
 
  Set ref = Nothing
 
  ReferencesClean = Not booMissing
 
End Function


Also make sure no code is executed before this.

Nic;o)
0
 
BobRosasAuthor Commented:
The code did not find any missing references.  

I would like to add that I was mistaken in saying all the full versions work.  It appears only mine is working.  When I tried the code on another full version machine I got...
Run-time error '-2147024890(80070006)' Method 'WriteString' of object 'lPortCtl' failed
Debug goes to the code
Sub SendMsg(PXstr As String)
    InfoMsg "Send: " & StrDump(PXstr)
      PortObj.WriteString PXstr
End Sub
FYI - This is not my program.  I've only made a few changes.  I'm trying to go thru the code now and figure out where 'WriteString' comes from.
0
 
BobRosasAuthor Commented:
rockiroads
I didn't see your comments earlier.  I am checking that out as well.
Thanks
0
 
BobRosasAuthor Commented:
rockiroads
I tried changing Allow zero Length to true and it didn't make any difference.
I also tried re-linking all the tables, nothing there either.
followed by
Run-time error '-2147024890(80070006)' Method 'WriteString' of object 'lPortCtl' failed
Debug goes to the code
Sub SendMsg(PXstr As String)
    InfoMsg "Send: " & StrDump(PXstr)
      PortObj.WriteString PXstr
End Sub
0
 
BobRosasAuthor Commented:
I just found that in the above code PXstr = AT&F in both machines but in my machine it is followed with a box for the carriage and in one of the PC's not working it's a vertical solid bar.  Could that be the problem?   Is there a way to change the bar to a box?
0
 
BobRosasAuthor Commented:
I think the references fixed it.  What happened is the software for the modem on the machine I was testing wasn't working.  The other run-time machines work fine now.
Thanks
0
 
nico5038Commented:
Glad it's solved, success with the application !

Nic;o)
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 6
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now