Recent content by SimDuck

Thank you PlausiblyDamp. The link was a big help. What I didnt do was set up FormC to receive both Form A&B in the sub new. I only had FormB in there. I realised I needed to pass reference to both FormA & FormB to FormCs sub new from FormB. Thank you again

Hi, I

Thank you. This works well. I have copied the code & created the new exe. It deletes the file beautifully. I modified the DeleteExe.exe code to delete the whole directory (DeleteExe.exe is in this directory). When it gets to the delete command, it deletes every file except for the...

DriverDan, this sounds like an excellent idea. I have tried to do this but I dont know how to call a dll with out it being referenced to the calling form. :confused: This is my exit sub routine: Private sub btnFinish_Click(ByVal sender as System.objecti, ByVal e as System.EventArgs) Handles...

Thank you Cags & DiverDan. Cags, you are correct. I have created an *.exe with vb.net. I am extracting the exe to a temp folder (along with some other files) & then running the exe. The exes job is to copy the files to a specified directory & then delete the whole folder including the exe...

@ PlausiblyDamp Hi, Im wondering if you can help me with a problem I have? Im trying to open an executable file which copies some files & deletes the whole directory including the file that is originally opened. Im getting an error saying that the file is in use. My question is, is there a...

@TheWizardofInt, by any chance, have you resolved this as I am having the same problem. I am trying to do the same as you and after a certain amount of dll acces times, the dll code doesnt seem to work. Thanks

APaule, I did this and the password change worked. I have ancountered another problem though and am wondering if you could help me. If I run the sql query : "ALTER DATABASE PASSWORD new password old password" with a connection string of: "Provider=Microsoft.Jet.OLEDB.4.0;Data...

Hi, I did step through my code. The path & database are correct. When I leave the ";Exclusive=1" off of the connection string, then: DBCon.Open() works fine. But when ";Exclusive=1" is part of the connection string, then the error is generated on DBCon.Open() I am thinking that...

Hi again Chester. I have done what you suggested with: Dim strDataSource As String = TextBox1.Text strDataSource = strDataSource & "\" strDataSource = strDataSource & TextBox6.Text strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" &...

Hi Chester, I added it to my connection string to make: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = Y:\Work Computer Data\Work Data\Visual Basic Projects\Projects\Accounts Package\Version 1\Data\test.mdb;Exclusive=1" and received this error when trying to open the database : "An unhandled...

I am using the sql query "ALTER DATABASE PASSWORD new password old password" and I get the error "cannot change password on a shared open database". As this database isnt open any where else, what would be sharing it? Is this the correct sql query to change the password or is there a better...

Hi, I am trying to change a password on my Access database programmatically. I have tried the sql query: "ALTER DATABASE tabletochange ADD/ALTER PASSWORD password" to no avail. I am wondering if any one can tell me what the sql query is that I need to run to chang the password on my database...

I can see the constraint when I create a dataset & view the xml schema in design mode. It has a key next to afield. I ran this command "SELECT CONSTRAINT_NAME FROM Account_Details.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = PRIMARY KEY AND TABLE_NAME = Account_Codes" and got this error "The...

Hi, I have a table where I want to remove the Primary key. I run the sql command of "ALTER TABLE table_name DROP CONSTRAINT Primary_key" The error I get is "CHECK constraint Primary_Key does not exist. When I added the Primary key, I used the sql command of "ALTER TABLE table_name ALTER...