Search results for query: *

Hi I have set-up a DTS local package which, if executed, runs ok there is a job that runs based on the DTS Operating System Command (cmdExec) DTSRun...

Hi I've got one SQL server (staging server) with a Database called Internet and a table called membership I've got another SQL server (live server) with the same Database and table. The live server will have the up-to-date data although at times I will need to modify/append the staging server...

Hi I have the code below, which has worked ok up until now. The validation is now not being called - although the rcord still only inserts into the database if all validation is met. What used to happen is if validation wasn't met the page would display, in red, any errors. This is the bit that...

Had this bit of code that worked on Access 97 under Windows NT server - since moving to Access 2000 on citrix metaframe xp it doesn't DoCmd.TransferText acExportDelim, "TblSendToTEC", "tblSendtoTEA", strFileName the specification name does exist any help appreciated richard

previous versions of access pre-2002 - the workgroup administration file could be found as an executable - it joined to the system.mdw file on \windows\system32\system.mdw and we created new workgroups for our own databases and had the path as follows "C:\Program Files\Microsoft...

What is the easiest way for me to pass a sql statement page to page as hidden ? thanks kim

Hi I've regularly imported objects into Access from other Access databases. I've had the occassional time where access has crashed done the importing in blocks and its ok. I had a strange one the other day where I imported 30 or so tables - it ran ok - no errors - however it turned out that not...

Hi I have a SQL table where the dates are stored in US format yyyy-mm-dd 00:00:00:000 I have an asp page where the user can enter date parameters as dd/mm/yy this isn't returning the records I'd like - is there a function I can use to convert what the user enters to match records in the SQL...

hi I'm getting vbscript comilation error 'name redefined' this exact script worked ok on a tet environment but not now it gone live ! I haven't declared the variable more than once and the include file has no declarations anyway any ideas ? thanks gareth <% Response.Buffer = False %> <% Set...

Hi I've maanged to connect to an external server via their IP address so i can now see my server Server1 and the external web server Server2. Databases that are created in Server1 I'd like created on Server2 also. Then the data within the tables on Server1 I'd like replicated in Server2 (I'd...

Hi I'm trying to connect to an ip address ***.***.***.*** - i keep getting SQL server does not exist or access denied. I am typing in the ip address in the server box and am using SQL authentication then typing in the login and password. I read you need to set-up an alias in SQL's Client...

Hi I have my live Database CCCInternet which has a backup performed this morning I don't want to touch the live Database (because of work done this morning) but I'd like to restore CCCInternet.bak to a temporary Database (I don't want to overwrite anything that is live) and compare one...

I've got a write conflict error when I click previous menu. it was ok before which leads me to think it is some new code I've included causing me the problem. the form runs the code below, calling functions which i've also included further on down. I think it is the line DoCmd.RunSQL ("UPDATE...

Hi When exiting a form I run a Function called AllocateType. This function checks which other records the current record (SECT_PAIS) has linked to (PAIS_SECT) and checks their funding status. These links are stored in tblPAIS_links The link may link direct to a service action - this is fine...

Hi I have a form where the user can select a service - audit for example, and then add records, edit records etc using Audit as the service. On the form that they select Audit I'd like to assign Audit as a global variable so when they edit/add records they can retrieve the value Audit until...

Hi I've got the following for an AtoZ page. problem is it is only displaying the first record it finds - if i use response.write it does display all the records any ideas ? thanks keith if not rsOutput.EOF and bValid = true then rsOutput.Sort = "az_keywords ASC" rsOutput.MoveFirst Do Until...

Hi I have this code which worked fine in Access 97 - now we're using Access 2002 it doesn't ! and it doesn't like me trying to manipulate the subform on the fly, as per the last 3 lines of the code below anybody know why ? regards ian i.e. can't change the linkchildfields and linkmasterfields...

Hi I have an asp page, which when I load says page cannot displayed - then i refresh - the page comes up with strange font sizes and the css out of sync - then i refresh again and the page is fine a colleague of mine, on first load get the strange font sizes and css out of sync - but refreshing...

I'm running a Database Maintenance Plan for integrity, optimization and backup of 3 databases. The optimization fails and I know it is the Training48 Database because when I remove that from the Plan it works ! I have tried EXEC sp_resetstatus 'Training48' but it set to zero anyway. I have...

Hi We have our naples server holding all our Web datbase backends. We also have our web server which is hosted by an external company. Assuming, I can connect to the live web server, via SQL, as an IP address (I think I can) I'd like to achieve the following. Using Jobs as an example...