Unknown Error When trying to Execute App

[vacunita]

I created an app that does a query to an MsAccess DataBase, and then i use those values to do some calculations. The App seems to work fine in the Development environment, but as soon as i take it to the test machine or any other machine for that matter, Windows comes up and sais that the App has generated errors and will have to be closed. I think it might have something to do with de database but i am not sure.
Has any body encountered a similar problem?
andy help would be appreciated.
by the way, the machines in wich it has been tested, are running Windows 2000 or WindowsXP. the Development machine is running Windows 2000.
thanx again

 

[svanels]

How are you communicating with the database? bde, odbc or other? Can you establish a link from another program to the database? Try SQL-Explorer to browse in the database. Use the same settings as on your development computer. Does ther database run without problems on the test machine? Steven van Els
SAvanEls@cq-link.sr

 

[LucieLastic]

Are you logging in under different usernames? Are the usernames in the DB's access group with appropriate privileges?

If you log in as you on another machine, does it still error?

 

[vacunita]

I'm accessing it by ODBC.
The Database is logged in a appuser1, password:=app. The settings are the same in all machines.
The data base is the same on all machines, its just a copy, of the .mdb file that access generates.

Thanx to all

 

[bbegley]

Did you set up the ODBC connection on the client machines? I don't know how to do that progamatically, but you can go to a machine and manually set up the connection to test it.

If it's not too difficult (and you think this is even vaguely related to your problem), you might want to switch to ADO. We found that it's much faster for connecting to access than ODBC, and if the clients are Win98 or better you don't need to distribute anything with it.

 

[vacunita]

Do i have to distribute any extra files with my appif i use the BDE components of Delphi, cause i think thats the problem.

 

[svanels]

Just install the BDE on the target machines. Steven van Els
SAvanEls@cq-link.sr

 

[LucieLastic]

Does your company have a Terminal Server?