move an access 97 database to a Windows 2003 server



I am trying to move an access 97 database to a Windows 2003 server.
Ultimately this database will be published through citrix, but for now I
would be happy getting it to work in the 2003 environment.

The customer insist that the database stay as access 97. This is an SQL
front end connected with an ODBC connection. The database will run until I
open a form. The forms are running VB scripts. Once the form is open the
access process is shut down. It leaves the lbd file open with no other
remnant of the process. I can however run the VB code outside of access.

The database will run on any other OS I've tried including XP, NT, and 2000.
I have even tried to publish the DB from a file server (point the
access.exe, DB and working directory of the published app on a machine the
DB will run on locally).

I have tried all compatibility modes from 95 to XP. I ran filemon without
much indication of what killing the process. Nothing gets logged to the
event log. I get a Dr Watson dump every time I open one of the killer forms,
but have had no luck deciphering anything out of it.

Any Ideas.
--

dw

_______________________________
Don Wilwol
Distributed Application Technologies.
donwilwol(DELETE)@yahoo.com
http://spaces.msn.com/members/wilwol/
www.datbusieness.com
www.skyphere.com


.



Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Linking Access f/e to Access b/e via ODBC
    ... > My objective was to use an ODBC connection to connect a local f/e to a ... able to use your database. ... > and execute queries on the server. ... See http://www.Access.QBuilt.com for Microsoft Access tips. ...
    (microsoft.public.access.externaldata)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Access Front End Question
    ... I've given each user their own Front End (Access Database). ... as the others have posted each Citrix user must also get their ... I specifically created the Auto FE Updater utility so that I could ... In a Terminal Server or Citrix environment the Auto FE Updater now ...
    (microsoft.public.access.modulesdaovba)

Quantcast