errror 2467 on comouters where my app is deployed

Hi
I am getting the error "runtime error 2467" whenever I start my app on a computer different from mine. In all computers, the crash statement is the same:

    Me.sbf_listaMilitantesSeleccionados.Form.Filter = strSetSQL
    Me.sbf_listaMilitantesSeleccionados.Form.FilterOn = True

(on the first statement on the Load event -sbf is a subforms)

can anyone help?
João serras-pereiraAsked:
Who is Participating?
 
Gustav BrockCIOCommented:
Then set connection up identical to that on your machine.
0
 
Ryan ChongCommented:
put a break point at line:

Me.sbf_listaMilitantesSeleccionados.Form.Filter = strSetSQL

Open in new window


and then doing:

debug.print strSetSQL

Open in new window


in the Immediate Window (Ctrl + G) to start the debugging...
0
 
Gustav BrockCIOCommented:
Also, go to menu Tools, References, and check if any reference is marked as MISSING.
If so, correct that.

It would typically be caused by running older versions of software on the users' machines than on yours.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
João serras-pereiraAuthor Commented:
Nope... All the same references on the machines. I have one additional reference on my machine because I also tried csxImage (but not using in this app)

The (almost) full code is:

    strSetSQL = "qryMMRfilter_prep.CodMilitante = 'BlaBlaBla'"
    Me.sbf_listaMilitantesSeleccionados.Form.Filter = strSetSQL
    Me.sbf_listaMilitantesSeleccionados.Form.FilterOn = True
    Me.Repaint

(it is to provoque en empty output on form load)
0
 
Gustav BrockCIOCommented:
Try with:

strSetSQL = "CodMilitante = 'BlaBlaBla'"

Open in new window

0
 
João serras-pereiraAuthor Commented:
nope... same error
the situation is weird... why does it work on my system and not in others?
0
 
Gustav BrockCIOCommented:
But you shouldn't have to filter a subform this way during load.
Adjust the Master/ChildLinkFields to filter the childrecords.
0
 
João serras-pereiraAuthor Commented:
Couldn't this be due to the fact that now I am using sql server (just installed on those computers?)

I 'got this advice when my colleagues stalled on the installation:

https://www.experts-exchange.com/questions/29081083/connecting-to-db-instance.html#a42450823

(but did not follow advice because I found the server name. One other weird thing is that many times my data now is "read only"!

I would like to avoid, if possible, start modifying my code in a strong manner. It is working on my comouter! (and it is a VM on a mac)
0
 
Gustav BrockCIOCommented:
I don't recall any scenario using Named Pipes since the days of Windows NT and Windows 95/98 ...

There are many potential error sources here. I would suggest setting up connection via TCP/IP to your server.
If you don't want this, walk through all settings - there will be some difference between yours VM and the users' machines.
0
 
João serras-pereiraAuthor Commented:
well.. on my machine things do work. the question is, is "is the connection working on the other computers?
0
 
João serras-pereiraAuthor Commented:
and sql server manager works alright!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have one additional reference on my machine because I also tried csxImage (but not using in this app)
If you have this reference, and you deployed the application with that reference, then your target machines would require it, regardless if you're using it in your application or not.

If you are NOT using it, remove the reference and redeploy.

If you ARE using it, then you'll have to deploy that reference to your target machines. You'd have to consult with the makers of csxImage to determine the best way to do that.
0
 
Dale FyeCommented:
also, if you are using SQL as your backend, every table that you want to be able to edit must have a primary key, and I also add a timestamp (rowversion) field to every table in SQL Server.
0
 
João serras-pereiraAuthor Commented:
Hi -
All my tables are like ta (having a primary key. (but not the timestamp) - but anyway, everything wis working fine on my computer, and none on the other computers.

Further more, I do have another, extremely light app that yields a similar error on the other computer, but not on mine. So, definitely, something must be dead wrong when I try to open the DB, although no errors are present. As I do not have the seam Load_Form logic, I am getting the error 3151 - ODBC connection error when I try to set open its first recordset.

So I am scratching my head on how to actually connect to a specific database - I think that the other computers must be missing the link to the instance - there must be somehow a way of doing it in vba. Can you provide me a simple walkthrough, or shall I pose another question?
0
 
João serras-pereiraAuthor Commented:
a PS.
I tried to directly open all the linked tables and all of them yield he same error: ODBC - failure to connect to "bddPlusLink, so this is is.

I just do not know how to make it work in vba, so the problems goes away
0
 
Gustav BrockCIOCommented:
Create a DSN connection with the ODBC Manager on one of the users' machines.
This deals directly with the ODBC driver and let you test and adjust the connection to the SQL Server.
Start using the default SQL Server driver. It has to work.
0
 
João serras-pereiraAuthor Commented:
Ok. I'll need a few hours before I can do that as right now I do not have access to the "problem" computers
/joao
0
 
João serras-pereiraAuthor Commented:
Hi.
After a few tries I am lost. I could not find, in the server PC, the ODBC data manager. But I tried to reconnect the linked tables  and a sqlserver dqtq source does not show as it does on my computer

So I have the option to create a new data source, which I do and test. But this new data source is never stored. any ideas?
0
 
João serras-pereiraAuthor Commented:
Hi... Shall I close this one and open a  related question to get help on the sql/server?
0
 
Gustav BrockCIOCommented:
0
 
João serras-pereiraAuthor Commented:
Hi Gustav -
thanks for the help; I really went through the docs, but the problem persists. I am absolutely sure that I the problem relies on me not being able to correctly set up users for the db computer. I now know that I need to set up. So I did set up a new database user.

I reckon that I have 2 courses of action:

1. I request help from EE expert such as you ($1.15 per minute) and start a session with teamviewer so you may unlock me, hopefully in a few minutes
2. start a specific related question just to get help on the specifics of my problem

but this question needs to be closed as both of us know the issue.

Right now I am preparing info for both options

just let me know what is preferable -


/joao
0
 
Gustav BrockCIOCommented:
OK. I would start with 2. - but study the links first to get hold on the general concept and terms.
0
 
João serras-pereiraAuthor Commented:
Ok. I am preparing it but the old link to "ask a related question" disappeared in outer space...

So I am preparing a brand new question starting with the link to this one (sigh)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.