Windows Forum

Ask something
Discussion Locked

NT4/ODBC/Access problem

0 helpful
3 replies

by afarcas

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi,
i made a web site a while ago. it is hosted on an nt4 server, uses asp for scripting, and an access97 database.
recently i made some changes, including the database. i used win2k and access2000 for development, then converted the database backto access97. everything is ok on the 2000 server. it crashes on nt4. the server that hosts the site returns HTTP500. i tried another nt4 server too, i got on that one 'could not find file unknown' - referring to the mdb file, or 'someone is using the file exclusively' or so. the dsn is ok, the scripts are ok, the database can be read, modified, etc.
ocasionally it works on both nt servers, and then it starts sending error messages, i wonder if it would be possible that the connections i am opening in the scripts get hung.

3 replies

by mackem

If I were you I would concentrate on opening the database using Access 97 and doing a repair, as saving from Access 2000 as 97 does not work too well.
I would also convert the .mdb to a .mde file as soon as possible. Having a .mdb file on the webbis just asking for trouble.
Besst of luck

by afarcas

thanks, i converted it to mde, it doesn't crash that often anymore - still does, but i suppose i can't hope of more:(

This discussion is closed to new replies.