Search results

Hi, I

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...

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...

Hi, I have am having a problem updating multiple rows of a dataset. I am using Visula Basic.net; OleDB connection to an Access database. The table has four columns: Code, Priv_lvl, Prim_Key(autoincrement primary key), Account I run a search to fill at dataset & it retrieves two or more rows...

Hi, Im trying to use a dll to hold forms & code and instantiate them from an exe. I can successfully do it when there is only one form in the dll. The problem I am having is when there are multiple forms in the one dll. I load the dll to form 1. The user clicks a button and the code is...

Hi, I am trying to delete a database using the SQL query string "DROP DATABASE Copy of Account_Details". I have looked for some help but have been unable to find some. Dim strConnString As New Connection Dim strDir As New Directory Dim strConn As String Dim strCommand...