ms-access

How to use Access database with query as pivot table in Excel

I want to use Access database with query for pivot table in Excel. How do I do that? ...

What is the time of a datetime field in a database if only the date is entered?

I am working on an Access adp that has its data stored in sql-server. I have a sql statement that inserts the date part of a dateTime object into a datetime field of a table. INSERT INTO...DateValue(myDateTimeVariable) What is the time defaulted to? (I am hoping that it defaults to 12:00 AM) ...

Macro across multiple word documents

I am working with a small company who is slowly moving to MS access. Currently all their reports live in multiple MS Word documents. During this transition they need to not only keep the word documents up to date, but also feed the information into the database. (Basically remove the need to double enter data). Is there a way that I can...

Is Access required on client machine to view Access reports via Sharepoint?

If I publish an Access database to Sharepoint, does the end user need Access installed on their machine to view the reports? ...

how to add new column in ms access table with this criteria

i have two msaccess tables tableA textA numA bd 1 as 0 aa 2 cc 4 tableB textB ss aa bd as how to write an sql query to add one column called numB in table B so that final table B would be tableB ( basically fetching values from tableA ) textB numB ss 0 ( because ss is not there in table A ) aa 2 bd ...

Fetch unique combinations of two field values

Probably it has been asked before but I cannot find an answer. Table Data has two columns: Source Dest 1 2 1 2 2 1 3 1 I trying to come up with a MS Access 2003 SQL query that will return: 1 2 3 1 But all to no avail. Please help! UPDATE: exactly, I'm trying to exclude 2,1 because 1,...

Calculate average date difference between records in MS Access

I have a list on when items have been handed out. The table has the following structure: primary key - autonumber itemname itemid - number datehandedout - date/time I want to calculate the average length of time between when one object is given out and the next one is given out. There will be a number of different items for which the...

MS Access 2003 - Is there a way to programmatically define the data for a chart?

So I have some VBA for taking charts built with the Form's Chart Wizard, and automatically inserting it into PowerPoint Presentation slides. I use those chart-forms as sub forms within a larger forms that has parameters the user can select to determine what is on the chart. The idea is that the user can determine the parameter, build the...

Error when executing sql

I get the following error when I try and execute the code down below. I have added the sql string I pass as well. What am I missing? Error: Syntax error (missing operator) in query expression 'TOURID = 25e5eed3-ea84-4c30-a660-2c880253da60'. sql: "DELETE * FROM TOURS WHERE TOURID = 25e5eed3-ea84-4c30-a660-2c880253da60;" Dim connectio...

How to Compare Microsoft Access Password With User-Supplied Password?

Curious as to how to compare a text box string to the password the user used to authenticate themselves when they started the Microsoft Access database. Microsoft Access version is 2003. Users authenticate themselves using Microsoft Access Jet security. UPDATE: Per CesarGon (thank you), this is really a question of comparing hashed val...

Rebol MSAccess ODBC: works with DNS connection but not with DNSLess Connection

I have tested the new free Rebol ODBC with MS Access after reading the doc here http://www.rebol.com/docs/database.html It works with ODBC DNS connection but when I tested with this DNSLess connection (MSAccess2003 file with MSAccess2007 installed): connect-name: open [ scheme: 'odbc target: join "{DRIVER=Microsoft Access Driv...

How can I apply multiple table-validation texts to the same table in Access?

My table's records need to satisfy two conditions: Entries in the ClosingDate field cannot correspond to a date before what is in the RequestDate field. A BidBond value may be supplied if, and only if, the record's Type field is set to "Tender" The two resultant multi-field validation rules are: 1. ([ClosingDate] Is Null) Or ([Closi...

glitchy access website, freezes for 30-60 sec intermittently

asp website with access database freezes for 30-60 seconds intermittently. The site is on an internal 2008 server. About 25 users access the site simultaneously. Is it just the limits of access or can i do something to improve the situation? change any timeout/refresh settings anywhere? or could it be a problem with the network? ...

SQL Server to MS Access linked server: "Could not find installable ISAM."

Hi, I am trying to set up a linked server in SQL Server 2008 to a MS Access 2003 database that is protected by both a workgroup username and password, as well as a database password. It also uses its own system database (system.mdw) I used the SQL Server template, which is pretty much identical to the procedure I find by Googling and o...

how to run Make table query that i have in access in C# code ?

hi i have query (DO2) in access that makes a table and inserting any data. how to run this query in C# code ? i try this: SQL = "Select * from DO2"; Cmd = new OleDbCommand(SQL, Conn); Cmd.ExecuteNonQuery(); Cmd.Dispose(); but i get error ...

How to get rid of "Specify Relationship" dialog

I have a Access database with 3 tables involved in this problem: People, addresses, address_person People has an pID (person ID), Addresses a aID, and address_person has a person field and a address field. In my form wich displays data about the person I have a listbox with the following source: SELECT address.ID FROM address INNER J...

How to create new column in Access - using query ?

How can I create a new column on an existing table in Access using a query? ...

My MS Access control displays no text for appended items following an append query

Relevant Tables #One# +----------+ +--------------+ |Quotations| ---> |PurchaseOrders| +----------+ | +--------------+ <One> | <Many> | | v #Many# | +-----------+ +------------+ v |Quot...

What is the fastest way to load a text file to an access Database ?

I have Text file that contains data separated with a comma ,. How do I load this to access in the fastest way? The Text file contains 200,000 rows. I work with C#. ...

Help with query in Microsoft Access

I have 2 tables: Table A: code | name Table B: barcode | name Table B has full barcode and name, Table A has only code. I need to run update query that fill name in Table A. I tried something like: update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8)) but it doesn't work. ...