Merge a spreadsheet into an already created table

[JHB]

.... thought I'd turned off the interpreter party

Yeah - but only think it, isn't enough - you do really need to check it, (it was on this way I found it)!!!

 

[bitsbb01]

Ok, so i removed the Comments Section and re-made a new Comments section, changed the interperter section, and now it works fine.. so far.. however the main test will be tommorow morning, when i do the first main update from the online datebase that exports to excel to this access database..

Thanks for all your help JHB

PS think i'm finding out how the corruptions are happening, watched as a staff member clicked exit db, that shuts it all down, then because it was taking to long to compress (4 seconds), then right click access in Taskbar and close and close and close, till it closes.. or they just task kill...

 

[JHB]

Thanks for all your help JHB

PS think i'm finding out how the corruptions are happening, watched as a staff member clicked exit db, that shuts it all down, then because it was taking to long to compress (4 seconds), then right click access in Taskbar and close and close and close, till it closes.. or they just task kill...

You're welcome, luck with your project and test.
About the "corruption" it could be that - the strange thing was, when you copied the field, the "corruption" followed into the new field.
It is really bad behaviour from the users - can't you show a warning message when the database closed?

 

[bitsbb01]

Ok the import went well
I wanted to add the name of the person importing and the date, but that dont work.. so oh well..
Cases.[Imported By] = "Graham 7-23-2013"

as for the message when closing, its when its packing/compressing that people seem to force kill, and any message box's by then have already closed..

Unless you know a way of keeping a msg box up till its completly closed.. ??

 

[bitsbb01]

ok i added a splash screen that runs from an external app whilst Access is shutting down... it doesnt stop them from closing them both, but at least it warns them..

 

[JHB]

I don't think you can do much more, else you have to remove the "Compact" on close.

 

[bitsbb01]

i ended up using the following code..

Dim retval

retval = Shell("G:\IT Information\Backups\Dont_Delete\Splashscreen", 1)
'Call module to hide access application close button
    HideAccessCloseButton
Call fSetAccessWindow(0)
DoCmd.Quit acQuitSaveAll

the Splashscreen i had created using Autoit and has a timeout of 4 seconds which is long enough for it to still show till Access closes.