Search results

I've tested this out and it too has the loophole that if you change the date to somewhere between the inception and expiry dates (as long as the db hasn't already expired), you can start the db no problem. The 'rs.Movelast' command selects the last record in the table I guess, so if there is a...

I also found the 'Updated Have Database Expire After 30 Days Of First Being Opened' db from here: http://members.shaw.ca/glenk/access2000.html I'm testing it and it appears to work (so far). It logs the period of db use to a table on first startup and also detects whether system date has been...

Thanks for the example, JohnN, I'll have a look. GHudson: I have a bits of code which hide the tables and disables the bypass key. I'll also convert to an .mde file. I'm not sure about the importing issue, have you any ideas? I realise that nothing's going to be 100% secure, but you can...

Hi All, I found the code below by Wayne Gillespie on an old Google Groups thread: http://groups.google.co.uk/group/comp.databases.ms-access/browse_thread/thread/34319d3f2d22c6b/09ef0085c0517803?lnk=st&q=access+database+expire+system+date&rnum=2&hl=en#09ef0085c0517803 The code doesn't allow the...

Hi all, I have a front-end database with a linked (data) database. Problems arise when this goes onto other PC's on different directories and I get the error that it can't find the linked database. This is easily fixed by updating with the linked table manager, but as I am not sure which...

Cheers for that, works a charm :) Atholl

Hi all, The title says it all; how can I make a form appear when something is selected from a combo box? Thanks in advance, Atholl