errror 2467 on comouters where my app is deployed

put a break point at line:

Me.sbf_listaMilitantesSeleccionados.Form.Filter = strSetSQL

Select allOpen in new window

and then doing:

debug.print strSetSQL

Select allOpen in new window

in the Immediate Window (Ctrl + G) to start the debugging...

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.

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)

Try with:

strSetSQL = "CodMilitante = 'BlaBlaBla'"

Select allOpen in new window

nope... same error
the situation is weird... why does it work on my system and not in others?

But you shouldn't have to filter a subform this way during load.
Adjust the Master/ChildLinkFields to filter the childrecords.

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?anchorAnswerId=42450823#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)

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.

well.. on my machine things do work. the question is, is "is the connection working on the other computers?

and sql server manager works alright!

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.

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.

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?

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

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

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?

Hi... Shall I close this one and open a  related question to get help on the sql/server?

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

OK. I would start with 2. - but study the links first to get hold on the general concept and terms.

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)