Recent content by goyal

I have the parameters just removed it here. I will try removing and pasting that line. Hope that works :)

I have this module which used to run fine till now. I did a small change to the module and that was added a DTS call step in between call runDTS1() the DTS call function is as follows: Sub runDTS1(strServer As String, strUser As String, strPassword As String, strDTS As String) Const...

I am trying to refresh an excel through a macro in access. I am getting the following error on the refresh table code: "the database has been placed in a state by user "admin" on machine "XXX" that prevents it from being opened or locked" The excel refresh link uses the same access dB. Is it...

I did C & R and got the same error. Btw when I did C & R as I have a autoexec macro it also ran. If I remove the autoexec macro (rename) will it make any difference in C & R ?

What do u mean by split ? I will try C&R and then see. Btw my bad it is access 2000.

Hi, I am running a make table query. my access dB size is around 450 Mb. I am always getting the following error:"Not enough space on temporary disk" My C drive and has like 30GB free. My temp folder reaches 1.95GB when I run this query (before that it is like 50mb). So I am thinking is it...