Recent content by petebob796

forgot You can't do this at db startup since vba code is stopped until you click through and allow it to run which would make it pointless. Also even if you could access would have to close and reopen to read the appropriate registry entry. Try it as a logon script at user startup I did it with...

How I did it I posted this a long time ago but since you are interested I found out that unfortunately the settings are per user only there are no global settings. So I setup on the logon script for the users that it would add the appropriate trusted locations. I don't have the registry entries...

I think I can do it in code like this: temp = "QStudent " & [Forms]![Attendance and Lateness Main]![cmbYear] & "," & _ [Forms]![FStudent]![Sel_ID] & "," & [Forms]![FStudent]![Sel_Forename] & "," & _ [Forms]![FStudent]![Sel_Surname] Set rsRDC = dbRDC.OpenRecordset(temp, dbOpenSnapshot...

I know this is probably obvious but how do I pass through form variables to sql server I currently have: exec QStudent @_param_cmbYear="0708", @_param_SelID="S", @_param_SelForename="d", @_param_SelSurname="S" this executes correctly SelID being a student ID or partial ID also allowing for...

I thought that might be the only way the thing is I know the major programs that use the databases already just think I will forget something else that uses them, especially as I took over from someone else so am unsure of all the uses of the db.

I am trying to upscale several databases from mdb to sql server. Unfortunately I am not sure of all the programs that use these database tables. Is there a way for the mdb to store what programs request data from it or alternatively the username. Im thinking not but worth a check.

I have been posting a lot recently and have greatly appreciated the help. I have just been looking at the size of a ms access project, this is a front end for another database so contains no data (runs as an mde for most). I have made a few modifications using access 2007 including at one point...

I modified a bit of vba code and what do you know it suddenly can be saved as 2003. This was just the addition of an if statement nothing was inherently wrong with the code I just wanted slightly different functunality.

I was hoping there would be an easier suggestion the trouble with the backup is it's from 2 weeks ago I made a backup at the start of the week but that is again an access 2007 version which I hadn't realised. I have since changed many things. But I guess I will have to if no other suggestions.

Anyone know any issues that would stop me down grading an access 2007 database. Someone up converted it without me knowing but I want it to be usable for people on older versions. I went to save as access 2003 and nothing happened. My initial thought was recompile the vba code and do a compact...

It's not my decision on the upgrade to access 2007 this is at a college on a terminal server environment which most staff are on, although I have a local machine as well rather than a thin client. It's not a problem with the query as far as I can tell and i am reasonably experienced and have...

I have tracked the problem down to a select distinct in the final query I posted a new thread as I wanted a new title to show the more accurate problem. I tried the select distinct as an outer query which was still just as slow and grouping on all fields which was also slow.

I posted a while back about an extremely slow query when using access 2007 but the same query in access 2003 runs fine. I have since tracked the issue down to a select distinct statement. If I change it to just select the query runs in about 45 seconds which it does in access 2003. I have tried...

Any ideas why a particular query would run very slow in access 2007 when it runs fine on 2003. This is running on a terminal services environment and the database connects to a ms sql 2000 server. I will try it outside terminal services when I can but I can't understand the problem. Im not...

At work we have a terminal services setup for most of the staff which is being configured now. We have hit a snag with access security settings basically we need macros to run for relinking odbc databases and various vba functions (some run overnight so we don't want to deal with the security...