The ODBC connections are setup as Systems DSNs. Yep, I don't like to use Access. All new development is on SQL Server or DB2. Unfortunatly these sites where setup using Access and it had not been a priority to move them to SQL Server. It may have just moved up the project list if we are unable to find a solution.
Brian -----Original Message----- From: Scott Cadillac [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 11:40 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Tango 2000 MS Access Issue Hi Hamrin, Did you recreate your ODBC connection to Access using a "System DSN" and not a File or User DSN? Also, this is one the main reasons NOT to use MS Access for Web applications. If the Server crashes in the middle of certain interactions with an Access database - the Access data can become corrupt. Hope that helps. Scott Cadillac --------- Business Extranet Freedom IExtranet ~ http://IExtranet.com Online Demo ~ http://www.northwind.org/#demo --------- Weblog ~ http://xmlx.ca For Hire ~ http://xmlx.ca/forhire --------- 403-254-5002 ~ [EMAIL PROTECTED] --------- P.O. Box 69006 RPO Bridlewood SW Calgary, Alberta Canada T2Y 4T9 > -----Original Message----- > From: Hamrin Brian Thor [mailto:[EMAIL PROTECTED] > Sent: Monday, April 11, 2005 10:15 AM > To: witango-talk@witango.com > Subject: Witango-Talk: Tango 2000 MS Access Issue > > We had a fatal server crash and are in the process of restoring sites > to different servers. We are experiencing an issue with writing to > databases. It seems that any site using Access as the backend is > unable to write to the database, reads are fine, updates & inserts > fail. The error shown is "query must be updatable" > > Once Tango has tried to access the database, when I try to open it > with MS Access I get a error stating the database is read-only. > > All sites using MS SQL Server work fine. Also all sites worked on the > now dead box. > > The server is a Windows 2000 server. We loaded Tango 2000 on Friday. > > Any thoughts on what could be causing this issue? > > > Brian Hamrin > Developer > Administrative Information Systems > Illinois State University > 309-438-3156 > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf