ms-access

Asp display txt from access

Hi there, i got a field that contains txt files in my access database. i want to display this txt file on my page. how can i read the file and display it exactly as it in file written? In which asp component can i display it? I know some methods to read file but they don't work as i want. my text files have a format and i want to displa...

Mail Merge from Access - Save Merged Document

I am attempting to open a document from access, execute a mail merge, and then save the document output from the merge using VBA. Here is my current attempt: Dim templateName as String, tempRoot as String tempRoot = "C:\report\" templateName = tempRoot & "template.doc" Dim objDoc As Word.Document Dim objWord As New Word.Application Se...

C# Access DB Queries

How can I perform queries on access using the C#? I want to create tables, and Insert/Select data from my access database. ...

creating a password protected Access database.

Using Visual Studio 2010 with a C# WPF project. I know how to create an Access 2000-2003 db file using the ADOX namespace. ADOX.CatalogClass cat = new CatalogClass(); string str = "provider=Microsoft.Jet.OleDb.4.0;Data Source=" + _dbPath + ";"; cat.Create(str); cat = null; Connect and open the database: conn = new OleDbConnection("Pr...

How do I write an "IF" statement for MS Access?

I am using MS Access 2003 SP3 and I need to write a statement that says something like this: I have two columns, one is the [MaxOfDate] field and the other is the [Date-Inidicator] field. For several of these rows, the Date-Indicator is blank. I want to tell MS Access that if the [MaxOfDate] field is a date of ""99991231" then enter "A"...

Access on NHibernate: slowness ?

Hi, I'm using NHibernate and Microsoft Access. My database file is fairly large ( ~500 MB ) and my app. is slow when writing to the database and I was wondering if any of you have experience with NHibernate and large Access databases. I want to know if this slowness in the app. is an known issue. Regards, MadSeb P.S I did "compact a...

Keep value of autonumber column when importing into Microsoft Access database

What I try is to import several tables programmatically from Microsoft SQL Server to Microsoft Access. Each SQL Server table has an identity column, and the corresponding Access tables, an autonumber column, too. Now I want to generate SQL scripts to copy the data from SQL Server to Access and have the autonumber colum the same value a...

Why does Access want you to identify a primary key on linked tables?

Supporting users who use MS Access as a front-end for viewing some Oracle tables at our intstitution. Typical use is to write ad-hoc queries with the Access querybuilder, and also they LOVE Access because it lets them build printable reports without having to submit to the lengthy & expensive programming-request process through our tech...

ms-access record/page level locking

i am baffled as to what is happening with the database i have a split front and back end access database every user has their own front end sometimes some users are able to edit the data and sometimes not. i don't know how to explain this here are the settings: anybody know what is going on here>? ...

Importing Excel into Access, error row number reported by Access does not match with row number in Excel

I have done this many times and have never seen this. I have an Excel file that I am importing into Access. In this process, if Access encounters some errors, it stores these error incidences in a table called ImportErrors. This table shows the error (eg. "Type Conversion Failure"), the field on which the error was encountered, and the r...

should i write an access front end or c# front end?

I have an Access database currently. There is a backend, and there are multiple users who use this database with their own front end. The size of the data is very small; however there are several forms that are constantly in use. I need to migrate the data to MySQL. Should I continue to use an Access front end or program my own c# front...

How can i read each row data from the database & the way i implemented below is correct or not?

public partial class _Default : System.Web.UI.Page { protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text == "" && TextBox2.Text == "" || TextBox1.Text == "") { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "LoggedInScript", "alert('Plz Specify Username An...

Access 2007 not auto-updating calculation with bound fields

I developed an Access 2003 database with a form that has a number of bound input text fields. As the user update the value in these fields, the table is updated with the changed value. I also have an unbound textfield that displays a calculated value from the user input. This does not use the values from the textfields on the form, but ...

Editing the contents of a ListBox

I have a ListBox with various rows of data (items that someone is buying, basically), and when the user clicks on a row it populates a textbox on the side with the quantity of how many of that thing he's buying. For example, one row might be "Pencils, $5, 3" and clicking the row makes "3" appear in the textbox. If the user changes that...

Selecting a record in Access Subform

I have a form in Access 2003 that contains 2 subforms. The first is in datasheet view and is only 2 fields, SiteID and SiteName, so a list of many sites for one record in the parent form. The second subform is the same datasource as the first, but in single form view, so it shows all the site fields for one site in a single form. The ide...

Importing XML files into an Access DB with multiple tables

Hello, I have a bunch of (flat) XML files such as: <?xml version="1.0" encoding="UTF-8"?> <SomeName> <UID> ID123 </UID> <Node1> DataA </Node1> <Node2> DataB </Node2> <Node3> DataC </Node3> <AnotherNode1> DataD </AnotherNode1> <AnotherNode2> DataE </AnotherNode2> <Anothe...

sql ms access select by date and genre

I have two tables: fID Enamn Fnamn bdate 1 Ronge Paus 49-05-14 2 Nesser Håk 50-07-26 3 Bods Thomas 51-05-02 And ISBN cathegory 123 Prosa 456 Poesi 789 Thriller I am trying to select by date and cathegory. The writer shoult be born before year "1950" and the cathegory should be "Poesi" The result should be: ISBN ...

Access Reports Looking up field value based on another field value

I have a group in my report that groups by the MachineID field and displays the MachineID in the header by a textbox with this Control Source:=[MachineID]. In another table I have an index of MachineID and MachineName. Is there a way to make the textbox get and display the MachineName from the other table instead of just the MachineID fr...

how to open ms access 2007 file in ms access 2003

how to open ms access 2007 file in ms access 2003 ...

how to disconnection access in my C# program ?

hi I tried to compress my Access 2007 database like this: System.Diagnostics.Process.Start(@"C:\Program Files\Microsoft Office\Office12\msaccess.exe",@"c:\Mydb.mdb /compact "); In my C# program and I get this error: You attempted to open a database that is already opened exclusively by user on machine . Try again when the datab...