Recent content by tonymce

I have sql 2000 on a server and the same on another both with the same service pack. Also i have arcserve 9.01 (same version on both) with SQL agent installed i am having problems restoring to the second PC a restore from the 1st pc i cannot restore the MSDB to the 1st PC because it is...

i used the domain admin account it is ok to restore all databases except the mdb and the master all i am after is the mdb (that is where the dts package is stored i think)

you can go complicated and write some code to change somthing or to do somthing when run. like make a txt file somwhere with the run dat or somthing like that yse the fso to do this and their should be an event you can play with in powerpoint

Private Sub Form_Load() Dim fs, f, sf, ff Set fs = CreateObject("Scripting.FileSystemObject") 'It will take all subfolders in this dir c:\test\ and show the file contents within each folder Set f = fs.GetFolder("c:\test\") Set sf = f.subfolders ' For Each f1 In sf...

i know this sounds stupid but is it your virus scanner. I have mcaffee and it blocks loads of ports only on sp2 i know it sounds strange but it does.. Worth a look :)

what client OS are you using? are you trying to log onto the domain or long onto the vpn?? is the daomin for FQDN eg . my.mycompany.com also try domainname\username in the username box

in theory it can work I have my proxy in passive mode and i can get out to any vpn easily. i think you may have to open some ports up in the proxy to enable the vpn to pass but i might have a different configuration that you so it is just a thought. I have it working through a proxy without any...

ARRRRRRRRRRRRG still not working i have the same version 2100 on both but i am getting cannot restore msdb databse is in use. so i tried single user mode still not working it then says you can only restore master in single user mode. i am now trying it will all engines stopped to see if the sql...

the best way i found to do it is to remake the form again i had the same issue with an old outlook 97 form migrated to 2003 i could not get it back onto the server for posting so i opened the form in post mode then copied all the data then made a new form did the relevant changes then re posted...

all i can this is make it a pps (auto running show) then look at the last accesed time? i will look @ it in vb to see what i can find but i have not seen anyhting like it b4 hope this helps

winbatch can do it provising you export the data first use a macro to export the data to csv the use winbatch or a bat file to transfer the file to the server via ftp or somthing then use a timed code on the server to listen to the folder and pick up anything in it if not emptyt then process it...

if you use a proxy you can set the ie setting then they can only go out via your servers and no other but other apps will be able to get out. you can try a gpo to set the ie and connection setting to your vpn tunnel and proxy server only. you can also try the local gateways to be set on your...

it is all to do with nt and xp the user has to be administrator of local pc to enable proper sharing if the thrinters and installation. if this is the case then does the users have the correct permission to use the printer. have you looked in gpedit on the xp pro machines to see if you have...

here is another way use AD and publish the application but the script will be just to point to the msi (UNC) and call it logon.bat and assigng it to all of the users accounts. the ad way is cleaner though

why do you kneed to put it into an array? these are objects and it will fill the memory so fast it is unbeliveable type putting a pointer into an array then use the pointer to referance to the ole recordset then do the modification to it in that state