Also make sure it is a System DSN as if it's not you get this message also...
(I had to do something like this before - you can't do stuff with the database while it's actually open...this applies to asp aswell - what I did at the time (and I'm not sure if this is your issue) was to create another MS Access database which just consisted of linked tables to my 'real' database - this way I was able to see the data/column types etc. and still be able to "access" it from witango - excuse the pun) --- "Wilcox, Jamileh (HSC)" <[EMAIL PROTECTED]> wrote: > Steve - if you're sure you don't have the database > already open in > Access (which will cause this error), then you might > try doing a compact > & repair on the database. It sounds like something > has the db locked up > and that might fix it. Open the Access db, Tools > menu, Database > Utilities, Compact & Repair. > > Also, check your perms on that file to be sure > Witango has rights to > open it. You don't have a password or anything on > there, do you? > > Hope that helps. > > jamileh wilcox > Information Systems > OU Physicians > (405)271-4647 x54124 > [EMAIL PROTECTED] > -----Original Message----- > From: Steve Campbell [mailto:[EMAIL PROTECTED] > > Sent: Thursday, January 29, 2004 5:33 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Record Builder Error > > > Hi Tom > > No sir, I sure don't > > Steve > > > -----Original Message----- > From: Tom Ferguson [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 5:25 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Record Builder Error > > You don't have the file open in the Access Window > do you? > -----Original Message----- > From: Steve Campbell > [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 6:01 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Record Builder Error > I am working with a simple insert on a Record > builder > like application. I know in the years back ..I use > to see this error all > the time when working with Access. ( I know ..it's > not a good database > type app. to use). > I got this error today and have checked my DSN and > pathways ..etc..etc.. > > Any insight would be appreciated and I know it's > an easy > error..I just think it's been so long since I have > seen it, that I have > forgetten the work around for it. > > Thanks for helping out his part time coder! > > Steve > > > > >>>>>>>>>>>>>>>>>>>>>>>>>>>> > File: addnews.taf > Position: Insert > Class: DBMS > Main Error Number: -1032 > [Microsoft][ODBC Microsoft Access Driver] The > Microsoft > Jet database engine cannot open the file > '(unknown)'. It is already > opened exclusively by another user, or you need > permission to view its > data. > HY000 > > File: addnews.taf > Position: Insert > Class: DBMS > Main Error Number: 0 > [Microsoft][ODBC Driver Manager] Driver's > SQLSetConnectAttr failed > IM006 > > File: addnews.taf > Position: Insert > Class: Internal > Main Error Number: -4 > Unable to connect to the specified data source. > > File: addnews.taf > Position: Insert > Class: Internal > Main Error Number: -4 > Unable to connect to the specified data source. > Verify that data source is properly configured and > that > database server is online. > > >>>>>>>>>>>>>>>>>>> > > > Steve > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system > (http://www.grisoft.com). > Version: 6.0.563 / Virus Database: 355 - Release > Date: > 1/17/2004 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system > (http://www.grisoft.com). > Version: 6.0.563 / Virus Database: 355 - Release > Date: > 1/17/2004 > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system > (http://www.grisoft.com). > Version: 6.0.563 / Virus Database: 355 - Release > Date: 1/17/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system > (http://www.grisoft.com). > Version: 6.0.563 / Virus Database: 355 - Release > Date: 1/17/2004 > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
