Quote:Did you remember to change "@FN" to the proper path?
Carl, I am aware of that. It is placed with full path even though partial should work. such as
"Data\Medical.db"
To be certain, I have also placed a full path.
"C:\Sesame\Data\Medical.db"
I have also used hard coded lookup through MassUpdate using one record and that even does not work, so I know it is security, as for example
var vTest as String
vTest = @xlookup ("Data\Medical.db", "012345678", "Index!RecNumber", "Name")
WriteLn ("Name is: " + vTest, "", "")
I know positively that RecNumber 012345678 exists with my own name. Writeln window only displays, Name is:
I think I might have located the problem. After having merged the different databases with the same security setting might have duplicated and re-duplicated the security setting. Normally it would not let you put the same user twice, I see the same users multiple times. The same group also several time. After making proper backup, I will remove all security setting and put one group, that is the same as the external application from which I want to lookup into this database.
I will let you know what happens.