Replies

Reply from our ICT department: this requires a Windows Database Server, which we don’t have…
They propose Citrix now… but no idea what pitfalls that might imply for our setup… Let’s google 🙂 (but any more thoughts are welcome!)

Tx for the suggestions! Meanwhile problem’s ‘solved’: the decision to migrate to sharepoint is postponed – probably for a long time :)…
(opening an opportunity to figure out how to work with Access in that new environment at our own pace… will post in the appropriate section 🙂 ).

Hi Patt, tx for looking into this. You are right (but) both subforms do use the same data source: tblTaakRapportering. The second subform is just another presentation.
I try to emulate a split (sub)form…

I should have made that more clear. I have reduced the original db maybe a little too thoroughly…

@Paul: tx, that’s right… but they just can’t tell how it’ll happen. Well… It’ll probably become ‘wait and see’ then…

So, if I understand it correctly… this should be possible through VBA :).

@David, thanks for the tip. I’ll think about forwarding it along with my own idea… (And: same remark as Paul… Could you send me a PM with pricing info, both for individual use and for a big organisation? Chances are small it’ll be used, but you never know…)

@Paul: the ICT team currently has in mind to leave it up to us, users, to delete all those old resurrected mails manually (again)…

Leechblock:https://addons.mozilla.org/en-US/firefox/addon/leechblock/
The best addition to self control re: internet use I’ve ever found :).

I discovered Explorer ++ too, to my satisfaction :)…
I like it a lot because of the following features (among others): possibility to open several files from different types at once (disabled by Microsoft since Vista); remembers last browsed location; tabbed browsing; no installation (indeed); …

Thank you so very much…
It seems like Explorer++ is, in my case, most promising!

What would I have to do (suffer) without you guys & girls.
This community is a blessing :).

Thanks Hans. I tried it but the ‘open’ line yielded an error 53 (can’t find file), also when I for example created such a file myself before running the procedure. I’ll ask a collegue at work if he can fix it and let you know.

Does MD5 for Visual Basic (VB) do what you want?

Thanks Hans! Yes it does .

Now… next problem: unfortunately it’s too slow for large files, yields an error with a ‘regular’ file,…

So (before spending time figuring out workarounds & debugging) I tried using the Shell function & a small freeware MD5 generator of DiamondCS (page includes screenshot).
I put this generator in the same folder along with my database… and ‘run’ it with these lines (in order to yield the hash for a file called plan.htm which resides in the same folder too):

Code:

Private Sub MD5_Click()
Dim str As String
str = Shell(CurrentProject.Path & "md5.exe " & CurrentProject.Path & "plan.htm")
MsgBox str
end Sub

The MgsBox returns a (every time different) number instead of the hash string.
Is my Shell command wrong? Or is there something else wrong here? (Or should I contact the creator of this tool?)
I feel pretty much like a greeny…
Hasse

(…) Our programmer designed a Visual Fox Pro program that processes mail received in Outlook and saves the attachments for later MD5ing. So it would be really cool if we could find a program with an API Visual Fox Pro could call for programming ease. If not, we’ll manage with these anyway.

For anyone else ever looking for such a solution: Quickhash might help. Excerpt from the explanatory text on this page:

It supports 3 interfaces: QuickHash API (…) and QuickHash Type Library (includes all declarations for accessing the functionality from programming languages that can reference a .TLB, such as VB 5.0, VB 6.0, VBA, etc).

Hi, (bringing to life an old thread… )
I’m also looking for a freeware alternative that provides this kind of info.
Have there been developed some new alternatives since then?
It also looks like not too much of a task to derive such info from the Access system tables (if you know how these are built) – is it? If I can work something out, I’ll let you know. Any suggestions, meanwhile, are welcome…

FYI: the recent address of Tony D’Ambra’s site is: http://www.accessextra.net/%5B/url%5D. Unfortunatly the add-on referred to here is no longer free (still cheap though).

John,
indeed – thanks for the confirmation.
An append query was one of the alternatives I was thinking about – now you mention it, I guess I can assume it’s the best or at least way good enough way to go .
I guess the easiest way is to (please correct me if I’m wrong):
– create an append query selecting (through comparison with the ‘normal’ table) only records which are absent the backup “…Orig” table… and
– execute this update query (when it contains records) at the subform’s ‘Deactivate’ event (and not at the AfterUpdate event, as the latter would have it launched for every record that has been added).
Thanks again!
Hasse

John, thanks for your reply. It also cleared the way to solve a deaper (stupid) problem: the subforms lacked their ID field and that’s pretty essential :-p. As such the ID field wasn’t copy-pasted along… and received it’s default value with the first record added… and again with the other records, generating a double value – key conflict error for each of them (preventing further copy-pasting). (fyi: I used a long number key for the backup table’s ID instead of an autonumber in order to give it the same value as in the ‘normal’ table so you can easily relate them afterwards.)

The problem with the ‘Allow editions’ property still feels odd as I remember it not being an issue when I dreated this form: I could copy-paste. You just couldn’t modify the added records afterwards (which was as intended). Can’t figure out why it doesn’t work anymore now, but I’ll leave it for what it is.
Thanks again,
Hasse

I’m sorry – I didn’t make myself clear enough.
The mysqldump is a plain text file (example in attachment). As far as I understand it’s a backup of the MySQL database’s structure (SQL?) and content.
Our admin mailed me this dump asking me to figure out if I couldn’t import it like that in Access. I replied that I couldn’t, but wanted to be sure – hence my question here.

Now… I decided it’s probably better just to locally install MySQL on my laptop (Windows XP)… This would allow me to ‘unpack’ the dump here into a full local backup copy of the database which I can link to using ODBC (*) without any security issues to handle, or convert to an Access database backend using software like John suggested.
So the confirmation I looked for (that I can’t import the dump file) isn’t that important anymore. I’m exploring new grounds.

Thanks again for your time,
Hasse

ps FWIW in addition to John’s suggestion: a couple of years ago I dumped some google search results at the board here … maybe it’s time now to figure it out what they were worth for real .

(*) Alternative howto at devshed mysql