Search results

cheers for that.....using the lynda vidoes - boring bloke but knows what hes on about. if i survive i hope to "remake" the DB i am control of into SQL so we can use it mulitpatform across sites.

http://bytes.com/topic/access/answers/691309-access-2003-access-2007-same-machine its a lengthy thread...but you are not alone.

you can use some basic sql to JOIN the tables asummin all of your tables have similar fields. eg USERNAME - TIMEINRECORD - RECORD NAME etc etc but this is slow and complex. best thing is to create a new db. LINK the tables from your other 3 projects into it. then create a "mini" dashboard...

well, funny you should that. i am just starting out with sql and php. installed Xampp yesterday and going through the online course. took me half a day to install it !! haha what did you use to design your php font end ?

i have 2010 at home ( got it free from work ) and noted that i also got sharepoint. havent uased them yet but it looks good from what I have read. will repot back when got to grips with it. I am also looking at having my back end access via the web for home workers ( sounds dodgy! ) so this may...

oh, i use 03 and it works. not sure about the rest - apologies. i would have assumed it was forward compatible, but knowing access probably not.

Save a copy of an .accdb file in the .mdb file format Versions of Access prior to Access 2007 use the .mdb file format by default. In Access 2010, you can convert an .accdb file to an .mdb file, but only if the .accdb file does not contain any features that require the .accdb file format to...

worth a shot.... save as 2000 format and try that ? if your using Access 2010 though, isnt it saving in 2010 format ? you may need to save that as 07, then open that on 07 to save as 03. does that help ?

open access first - then go FILE , OPEN and locate file - sometimes works. worth a shot as above. can you post it here - how big is it ?

it was probably corrupted in the on and off the USB stick process...have you tried re-copying it ? simplist things first.....

maybe you could...... have it log in using the fosusername and set privileges - but then set a "no activity" shutdown for say 5 mins. in the scanrio above, if you logged in and walked away from the PC, then anyone could come and use it with your log in anyway. you could even lock it so...

it does sound unsafe easy to do though fosusername() = loginname have this in the autoexec. are you using the : Function fOSUserName() As String ' Returns the login name for Adminstrator use Dim lngLen As Long, lngX As Long Dim strUserName As String strUserName = String$(254, 0) lngLen...

"Unrecognized Database format". normally means it is corrupt. open it while holding down SHIFT and see if it will let you compact and repair it.

use the PAGE funtion in acces - you can build a simple html page and place it on a server that has your back end on. you can add, delete and change data in html forms simply this way.

alweays "compact and repair" often. speeds things up a bit

here you go ! 1 : follow the work here by the MS engineers. http://support.microsoft.com/?id=210297 2 : then CREATE A NEW DATABASE called LOGOFF ( call it what you want ). Save it in the folder with your back end. In this DB simply create 1 table called "tbllogoff". In this table...

by the way this works......I can now remotely REMOVE USERS FROM THE DATABASE simply with out alot of fuss. let me know if you want code and workings.

Hi guys I am currently using this code to detect Idle time and auto log of users after 30 mins if they have had ZERO DB activity. http://support.microsoft.com/?id=210297 it works a treat - even if the back end corrupts wich saves me loads of time as we have 100 users and most if not all...

still cant get it to work if anyone has any opther ideas they would be gratefully received. d

hi guys - thanks for yoru feedback the system is a validaiton tool - the hires are controlled by another company and entered into our system to validate/control. So - as new hires are entered they need to be checked with this to make sure there are no duplaicate hires. if there are - they...