Interesting Problem

[Fenrir]

I've recently upsized a clients backend to SQL. It went fairly well and I've work through all the problems except the one I'm about to explain to you. I have a situation in which the deletion of records causes an ODBC call failed error on XP and 2000 machines but the deletion works perfectly on Windows NT workstation boxes. The application is running fine in all other cases on all operating systems. Now I did make the .mde files for the front end distribution on an NT workstation machine. Then figured the problem was because I compiled it on NT but I moved the .mdb to an XP box and remade the .mde and encountered the same problem. Has anyone had this issue before and, more importantly, has anyone solved this problem before?

Frontend Access 2002 Backend SQL 2000

I will be happy to post the code involved, etc if we need it to figure out the problem. I'm hoping someone else has experienced this and can simply tell me where to look or what to do.

Thanks in advance for any help you may have with this issue!

Fen
-----------------------
Beer is proof God loves us and wants us to be happy.
-- Ben Franklin

 

[The_Doc_Man]

There is at least a potential domain problem here. Domain structures in Windows changed significantly in Win2K from WinNT. You need to clarify the properties of your account on the WinNT system vs. the Win2K/XP systems; specifically, group membership differences.

Work with your local domain administrator to see what kind of domain security s/he has set up.

The application is running fine in all other cases on all operating systems.

As in, Win95, Win98, WinME ? They have the same domain structure limits as WinNT. Win2K was the dividing line. That's why I'm suggested that you have your domain admin person work with you.

 

[Fenrir]

Thanks for the reply Doc_man!

For the last two days I have been having the sys admin check things like that. I've had the users that have XP os move to the NT boxes and login to rule that out. What I've found is that it is operating system specific. User accounts that get the ODBC call failed on XP work perfectly when they and their acounts move to NT boxes.

Quote:
The application is running fine in all other cases on all operating systems.


As in, Win95, Win98, WinME ? They have the same domain structure limits as WinNT. Win2K was the dividing line. That's why I'm suggested that you have your domain admin person work with you.

The office has NT, 2000, and XP workstations. Everything in the program with the exception of this deletion works fine on all the machines. The deletion only works on the NT workstation machines whereas the XP and 2000 machines receive the ODBC call failed message and no deletion occurs.

Again thanks for the reply and keep them comming!

Fen
----------------
Beer is proof God loves us and wants us to be happy.
--Ben Franklin