I would like to insert some data into an Access Database. DataTable dt = new DataTable(); String sql = string.Format("SELECT * FROM {0} where 1=0; ", tmap.SqlTableName); string con = string.Format(conn, accessPath); OleDbDataAdapter da = new OleDbDataAdapter(sql, con); OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(da); da.Ins...
i am a little confused in finding out what would be the best way to replace all occurances of 1. Blanks 2. - 3. NA from all collumns of TableA with question mark ? charachter. Sample Row in orignal tableA 444586 RAUR <blank> 8 570 NA - 13 - SCHS299 MP 339 70 EN <blank> Same Row in Expected TableA 444586 RAUR ? 8 570 ? ? 13 ? SCH...
hi ,is it possible to compact the Msaccess database using c# if so let me know the way? ...
I have a query in MS Access which creates a table from two subqueries. For two of the columns being created, I'm dividing one column from the first subquery into a column from the second subquery. The datatype of the first column is a double; the datatype of the second column is decimal, with scale of 2, but I want the second column t...
I have an Access database with a form in which a user clicks a button which in turn runs a macro which also runs a function in a module. Yes, convoluted and no, I am not allowed to change much since it's the customer's application. What I need is to read some combo-boxes and a radio button from the form in the function that's in the mod...
is it possible to delete all the records in a MSaccess table using c#? ...
Working on an old Access 2000 database, and am really rusty. Remembering why I quit doing most Access development a while back, too. ; ) I have a query that I need to export the results of to a CSV file, and save where the client requests (dialog box). Did some searching on same, but not finding what I need and am back against the wall...
Debugging an old Access 2000 database which someone recently added a labels report to. It prints 3 x 10 labels on a standard Avery 5160 layout. Runs flawlessly the first time it's opened, but any time after that goes to a 1 x 9 layout, even if I close and reopen the database. If I copy the original file again to my working directory, I g...
hi guys. I need som help here. need to know how i can compare date from database to today´s date. don´t need it to be very exact. just days will work fine in my case. i need days so i can see if its time for transducer calibration. if date < three month or 90 days then should textbox´s change color to red, showing its time for new calibr...
in ms-access i am running a macro that runs several queries, during the execution of a query a message box appears "you are about to run an update.......... are you sure you want to run this query ? " how can i automatically select for all such cases so that macro runs without human intervention. ...
I have an access database which has some sql queries loaded into it. I have no experience with microsoft access and need to know how I can see the sql queries it contains. My guess is they are somewhere in r_[sql name]? What I mean specifically is to see the query itself, for example there is a form which generates an output based on va...
I have a Microsoft Access File, which has two level protection: database password mdw file ( for storing username and password) I can easily unset the ms access database password, but is there anyway to remove the username / password restriction on the ms access file? ...
will the sql queries i run in ms-access also work on mysql without any changes ? ...
In MS-Access database, table called NewTable3 colname is a text column containing lot of empty cells or blanks. i want to put ? character in empty cells . when i run the query UPDATE NewTable3 SET colname = '?' WHERE ISNULL(colname) ; This query updates 0 records why . what is wrong with this query ...
In the 'code behind' of the report is there anything I can do in code to query a property of the record source. Sorry I'm new to access and VB, but I am wanting to achieve something along the lines of this If Me.RecordSource["MYFieldName"] = "dan" Then //do something End If Is this possible? ...
what are the various other programs using which i can connect to odbc database besides ms-access. i'm talking about programs in which i can run sql queries. i dont want to use ms-access because the size of the access file has become 1.5 gb . why my database is 1.5 gb ? i am using access to connect to odbc - mysql database . which is q...
i am migrating from ms access database to mysql database with java frontend so that my application can be used in linux as well . in ms access here's what i would do go to create query . write a select statement . call give the name of the query as query1. when double clicking on query1 you would get the result of select statement in ...
I have four make table queries that need to be ran in a certain order and on a daily time schedule. I tried creating a macro that would open them in order but it required human interaction to exit out of the warnings and it failed to move on to the 2nd query. Any ideas? ...
So I have some data in an Access table. I am well-versed in Access and am using it in this instance for its report-generating qualities and ease of use for the non-tech proficient. This is the only tool at my disposal. The data came to me as an .xls with a lot of junk and stuff basically all over the place. I made a bunch of queries to ...
What's the best way to install MS Access on a remote windows server? I do have a valid license for the product. I want to install it on a remote windows server, for development purposes. Server is running Windows Server 2003. ...