Recent content by hedidit

Sorry yes I was being thick, rather embarrased... cheers!

Hi Tarwn I've got round the problem by inporting into a DB and then updating within that. However it'd be far better to update the actual XLS file. When you say a connection object not a string what do you mean? Sorry if I'm being thick! Cheers

Hi Sheco thanks for the response, I've already given ready, write and modify access to the IUSR and IWAM accounts on the file. The file is located within a folder that contains a database that my asp code can update etc. Any other ideas?

Hi all, I need to update records in an excel spreadsheet, I'm reading the spreadhseet content using: csvcon="Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & Server.mappath("\mypath\db\import.xls") & ";" Dim SQL SQL="SELECT [reportMAP$].ReportNum, [reportMAP$].RecNum...

Yes it is different... in database A it's called Archive, in database B it's called TblArchive...

Thanks for the replies, I'll have a go with both now... I'm merely trying to tell whether the table is linked... not so bothered about whether it's from database b... cheers again

Can someone show me any example code of how to check whether a table is currently linked into my database? Example: I'm in database A, database B has a table called Archive... I want to know whether my current database (database A) is linked to table arbice in database b... Cheers

Sorry i didn't have DAO checked in my references... doh!

Can someone show me the code of how to open a VBA recordset? I have a query I'd like to mess around with via VBA... i know how to do this in vbscript with ASP but not in ms access. At the moment I have: Dim dbs As Database, rst As Recordset, strSQL As String Set dbs = CurrentDb Set...

Typical, I finally decide to post after looking for ages and then find the answer straight after posting! Problem solved.

Hi all, I've always used a seperate database for checking login credentials / logging users into my sites however a friend now wants me to set up an intranet site for him that allows access to various screens depending upon the users membership of active directory groups. I realise I need to...

Thanks guys got it working after all using 'format' Thanks again for the help...

Hi I have a form that a user enters various bits of data onto. , the data is then inserted into a table called 'TblInventory'. The code works fine accept that the field called D8Rec changes format from dd/mm/yyyy to mm/dd/yyyy once it's inserted into the table. The code I'm using for the...

Thanks for the responses... the site is mainly written in ASP so I can use a session variable to do this... Thanks trollacious i can't believe I didn't think of that!

Hi all, I have a site in two frames, a small top frame with naviagtaion bar in it and the main content frame below. My problem is that google is only picking up on the main frame content pages so when users try to visit my site they don't see the top frame that enables them to navigate the...