Search results

yes, several

it's not handling an error, it's crashing Access

set them up on a yahoogroup www.yahoogroups.com they can join/leave as they like and you can add them all in as admin

yes and this one is simple anyways...

no joy so far... :( tried a few paths including the c: and tried a few different excel parameters might have missed a combo that works, but it's a pain having the whole lot crash everytime

yes and i've tried it in other databases and compact/repaired and new databases :confused:

oooh, i assume 2007 attempts to convert a 97 version...

cool, as i suspected, it's just IT trying to have an easy life ha ha, no chance. they are some of the worst databases i've ever seen. the team amend the live version, very few are split and everything is hard coded. oh and they're all macros and no VBA. truly they are rubbish. except mine of...

it's the old "Microsoft Access has encountered a problem" crash i can get the error out of visual studio...but it's all in hex or greek or something....

i have a little piece of code Sub publish_data() Const UNC As String = "\\opssvr01\dmi\" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "tbl_COMMODITY", UNC & "TEST.xls", True End Sub which crashes Access EVERY time it runs :mad::mad: in 2000 or 2003 format...

all i work in a team that supports ~100 Access databases (~90 of which are Access 97, ~10 are 2000) which are used thoughtout the day by 100s of people. several are business critical IT are telling us that the migration to Office 2007 is imminent and they are going to switch off all office...

why can't you bind the form to a table or a pass through query?

:mad: am i right in thinking that if i have two parallel data flows into the same table then the first one to hit deadlocks the table and i have to do them in series? :confused: aaaah found the "lock table" option on the OLE destination component

ooooh, i see aha the parse doesn't seem to work, but it does work overall can't properly test it atm, but will be this week thanks a lot

hi i've declared a vairable varMinDate and now, in an OLE source component, i'm trying to use it like this:- SELECT Field1 FROM Table1 WHERE BusDay= @User::varMinDate but i haven't got the syntax right :( any ideas?

hmm now stuck on a different error i got the ODBC to work on a sql comonent, so i bravely ploughed on with a Data Flow object the source object, a Datareader component, keep giving me the "inconsistent metadata" error and it is completely stumping me why?? anyone got suggestions for getting...

aha, found a guru at my work and he suggested 3 things 1) just use SSIS, management studio looks at sql server stuff, but SSIS should be able to connect via ODBC 2) as bob suggested, get the DBA to load the driver onto the SQL server box 3) use BCP i'm currently tinkering in SSIS and it looks...

aha, thanks Bob think it may be this http://support.microsoft.com/kb/280106 will ask the DBA...(i'm just a blagger with access to sql server!)

hi i can connect an Access db to Oracle via ODBC and see a table fine... but when i try and do this in a query in SS 2005, it doesn't like it giving me now i'm pretty sure one of two things is happening here:- 1) the database is set not to allow connections from SS? this seems possible but...

use a batch file to copy a master front end to each c: then you never need to compact it or distribute it :)