Recent content by dirkps

thanks - just 2 questions - i initially wanted to go down the route you are suggesting in essence creating a temp db for the temp tables but couldn't figure out how to use the DoCmd.TransferText to import into another db - if i'm not mistaken i did try using '[c:\temp\temp.mdb.[temp_table]'...

Which version of Access arre you using? 2003 SP3 Is the database split? if understand question correctly then yes - i have a front end mdb (with gui) and a backend mdb that houses data What method are you using to import records? i import from text file into front end db (into a temp...

Hi, I need some advice wrt record locking in MS Access - first a few bullet points on my setup - multi user environement - 10+ users - no edits only bulk inserts and deletes (and selects) - data volumes high -> 1-2mio records inserted in total (every day) between 10+ users - inserts /...

hey Doc Man - thats the frustrating bit - i'm not getting an error (with no error trapping enabled) - i've tried using the property dbFailOnerror but it made no difference. A total of around 1,500,000 records are inserted every day (i create a new mdb for every day) by 6 users roughly at the...

thanks for the reply but just to clarify - the SQL itself works fine most of the time - my problem is that when inserting 80,000 records (in one go ie calling above statement once) it inserts only 79,996 out of the 80k for no apparent reason - a rerun will fix it - it seems to be most frequent...

Hi - i have a very annoying problem which i hope someone can help me with. i use MSAccess in a multi user environment with a front end mdb and a backend mdb. In essence the users would run a process that creates a text file (outside of access) - this text file is then imported into the front...