It's not going to find the table cause it's a SQL server table...sorry :( I don't know how to get it in Access, but I would point you to the newsgroups
Microsoft.Public.Access.Forms Or Microsoft.Public.Access.FormsCoding Steven D Dworman ------------------------------------------------------------------------- Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 ------------------------------------------------------------------------- EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -----Original Message----- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 8:45 AM To: CF-Talk Subject: Re: Last Updated Date Thanks for your help - unfortunately - I am getting the following error when I try the code - do I have to change anything in CfAdministrator? Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'sysobjects'. Make sure it exists and that its name is spelled correctly. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:54). Date/Time: 10/02/01 13:43:51 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; poing!; Poing! Guest) Remote Address: 62.190.52.254 Cheers Simon ----- Original Message ----- From: "Steven Dworman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 1:05 PM Subject: RE: Last Updated Date > select refdate > from sysobjects > where name = 'TABLE NAME' > > > Steven D Dworman > ------------------------------------------------------------------------- > Web Consultant > Systems Administrator > > ComSpec International - http://www.comspec-intnl.com > phone: 248.647.8841 > cell: 734.972.9676 > ------------------------------------------------------------------------- > EMPOWER-XL ***Software for Higher Education*** > http://www.empower-xl.com > -----Original Message----- > From: Simon Whittaker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 4:08 AM > To: CF-Talk > Subject: Re: Last Updated Date > > Cheers Howard and John, > > Unfortunately the option of having a seperate column or even a seperate > table is not really availablt - is there anyway of obtaining the last > modified date of a dbase or even any file? > > > Cheers > > Simon > ----- Original Message ----- > From: "John Paitel" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, October 01, 2001 6:28 PM > Subject: RE: Last Updated Date > > > > >You can create a column in your table called "DATE_MODIFIED" and update > that > > >with the current date each time the row is updated, then retrieve that > date > > >when displaying that record. > > > > I believe he wanted to see if it was possible without using another field. > > John > > > > > > Is it possible (without a seperate field/table) to obtain a last > updated > > > > date/time for an Access 2000 or SQL database and then display it on a > > > > page? > > > > It would also be brilliant to obtain a last updated date/time for a > > > > paticular record but I realise that this is less likely. > > > > > > > > I hope you can help, > > > > > > > > Cheers > > > > > > > > Simon > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
