tagged [ms-access]
How do I connect MS access linked server on a network drive requiring a password
How do I connect MS access linked server on a network drive requiring a password I am trying to link an MS access mdb to my sql server 2005, the problem is that the MDB is located on a shared network ...
- Modified
- 24 Mar at 11:25
ASP and Acess DB - "Like" Query problem
ASP and Acess DB - "Like" Query problem this query works when i'm
- Modified
- 22 Nov at 00:53
Persist Security Info Property=true and Persist Security Info Property=false
Persist Security Info Property=true and Persist Security Info Property=false For the properties: and Can you tell me what is the difference between them, and if I don't put it in my connection what wi...
- Modified
- 24 May at 04:3
Is it possible to convert VBA to C#?
Is it possible to convert VBA to C#? I have a few modules of block of code in VBA to run on few Access databases. I would like to know how I should proceed if I want to convert the coding to C# enviro...
How to SUM two fields within an SQL query
How to SUM two fields within an SQL query I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Is this wha...
Alternative to Microsoft.Jet.OLEDB.4.0 for 64 bit access on MDB File
Alternative to Microsoft.Jet.OLEDB.4.0 for 64 bit access on MDB File I have like many others the problem that I can't access Microsoft Access (MDB Files) from my 64 bit machine using Microsoft.Jet.OLE...
How can I convert an MDB (Access) file to MySQL (or plain SQL file)?
How can I convert an MDB (Access) file to MySQL (or plain SQL file)? Is it possible to create a Dump of SQL commands from a Microsoft Access database? I hope to convert this MDB file into a MySQL data...
How to restart counting from 1 after erasing table in MS Access?
How to restart counting from 1 after erasing table in MS Access? I have table in MS Access that has an `AutoNumber` type in field `ID` After inserting some rows, the `ID` has become `200` Then, I have...
- Modified
- 19 May at 07:36
How to create an automatically managed "last update" field with Microsoft Access
How to create an automatically managed "last update" field with Microsoft Access Originally I thought to ask if there would be an easy way to provide an automatically managed last update field with MS...
- Modified
- 8 Mar at 23:14
How to set DB2 ODBC driver locale?
How to set DB2 ODBC driver locale? I want to import data from a DB2 database into MS Access via ODBC. The connection is set up and working but decimal values get converted due to some locale issue (Ge...
How to replace blank (null ) values with 0 for all records?
How to replace blank (null ) values with 0 for all records? MS Access: How to replace blank (null ) values with 0 for all records? I guess it has to be done using SQL. I can use Find and Replace to re...
how to get the last record number after inserting record to database in access
how to get the last record number after inserting record to database in access i have database in access with auto increase field (`ID`). i insert record like this (in C#) how to get the last
How to do INSERT into a table records extracted from another table
How to do INSERT into a table records extracted from another table I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this i...
Query Microsoft Access MDB Database using LINQ and C#
Query Microsoft Access MDB Database using LINQ and C# I have a *.MDB database file, and I am wondering if it is possible or recommended to work against it using LINQ in C#. I am also wondering what so...
How to make a select query for sql and access databases?
How to make a select query for sql and access databases? Using SQL server 2000 and Access 2003 I want to take the field from person table, and include in Events table by using inner join Tried Query `...
- Modified
- 19 Oct at 10:21
ServiceStack OrmLite with Ms Access Database First Approach
ServiceStack OrmLite with Ms Access Database First Approach I am relatively new to servicestack. I have searched enough but couldn't find any answer. I have worked with sql database first approach wit...
- Modified
- 7 Sep at 11:11
How to refresh an access form
How to refresh an access form I am building an MS Access application in which all the forms are modal. However, after data change in a form, I want to refresh the parent form of this form with newer d...
How to copy to clipboard using Access/VBA?
How to copy to clipboard using Access/VBA? Using VBA inside Access2003/2007. How to copy the contents of a string variable to the clipboard? [This site](http://www.tek-tips.com/viewthread.cfm?qid=1138...
MS Access - what are the lowest required permissions for the backend file and for the folder containing it
MS Access - what are the lowest required permissions for the backend file and for the folder containing it I maintain an ms-access application splitted to frontend and backend files. The frontend file...
- Modified
- 16 Sep at 07:23
VBA procedure to import csv file into access
VBA procedure to import csv file into access i need procedure in VBA to import data into access from csv excel file without some records,, as header and footer. Example,,, i have table in csv file, wh...
Convert String to Date in MS Access Query
Convert String to Date in MS Access Query I am trying to retrieve data from my `access` table based on `Date` column. My requirement is to display everything greater than the certain value. I am tryin...
How to pass an array to a function in VBA?
How to pass an array to a function in VBA? I am trying to write a function that accepts an array as an argument. The array can have any number of elements. H
MS-Access design pattern for last value for a grouping
MS-Access design pattern for last value for a grouping It's common to have a table where for example the the fields are account, value, and time. What's the best design pattern for retrieving the last...
- Modified
- 6 Sep at 12:37
Manipulating an Access database from Java without ODBC
Manipulating an Access database from Java without ODBC I want to manipulate a Microsoft Access database (.accdb or .mdb file) from my Java project. I don't want to use the JDBC-ODBC Bridge and the Acc...
- Modified
- 23 May at 11:33