ms-access

Access MDB: Is it possible to monitor and log actual queries made against an Access MDB?

Is it possible to monitor what is happening to an Access MDB (ie. what SQL queries are being executed against it), in the same way as you would use SQL Profiler for the SQL Server? I need logs of actual queries being called. ...

Access 2007 file picker, replaces all rows with the same choice.

This code is from an Access 2007 project I've been struggling with. The actual mean part is the part where I should put something like "update only current form" DoCmd.RunSQL "Update Korut Set [PikkuKuva]=('" & varFile & "') ;" Could someone please help me with this?` If I use it now, it updates all the tables with the same file pick...

Access - how to derive a field upon entry of a record

I have an Access database for a media rental company which includes the following tables, among others; LOAN: customer_id (pk), loan_datetimeLeant (pk), loan_dateReturned (pk) LOAN_ITEMS: customer_id (pk), loan_datetimeLeant (pk), item_id (pk), loanItem_cost ITEM: item_id (pk), product_id, item_availability PRODUCT: product_id (pk), ...

MS Access 2003: Can data disappear from records and how do I test for this and prevent it?

Problem and about the database: Data from a record in Access 2003 database has disappeared. This database has 1 backend and 3 frontends, multiple users and is hosted on Citrix. Within this database, we have records of all clients served, ranging in the 1000s. Background info: The form for client data entry is set up with various subfor...

displaying decimal values from database in textbox

Hi there! i just want to ask how to set the textbox so it will display decimal numbers. Couse now if i read a decimal number from my access database like 0,2 it displays only 0 Tnx for the help! ...

Retrieve Value Using Key From a Collection in Access 2000

I know this is a simple question but it's aggravating me. If I have a key/value pair in a collection but I can't seem to get the value out using the key. I can get the key using the value but not vice versa. Is there some magical way to accomplish this? For example: Dim CycleList As Collection Dim Value as String Set CycleList = New Co...

MS-Access nested DIR - check if a file exists elsewhere whilst looping through a folder

I have used the DIR() command in Microsoft Access 2003 to loop through the files in folder A. This works fine, but I need to check if each file also exists in another location (folder B), and only process the file if it doesn't exist in folder B. The problem is that checking for the file existing in folder B also uses the DIR() function...

Is it possible to do a 3 table join in MS-Access?

I try to do a 3-table join in Access and it will not work. Is it possible? ...

Application deployment problem

Hello Everyone, I developed an application using VS 2008 and MS Access2007 and it works fine. Now have to make a setup of it(this is my first project). I gone through many tutorials about deployment, I tried VS 2008 setup and deployment, but after installation it only runs in my machine and not in others..sometimes it shows error(The 'M...

SQL: HAVING clause

See the following SQL statement: SELECT datediff("d", MAX(invoice.date), Now) As Date_Diff , MAX(invoice.date) AS max_invoice_date , customer.number AS customer_number FROM invoice INNER JOIN customer ON invoice.customer_number = customer.number GROUP BY customer.number If the the following was added: HAVIN...

SQL partial max

Struggling with the following SQL problem. Assume a three dimensional table with entries (h,t,q) 1,A,20 1,A,10 1,B,5 2,A,10 2,B,3 2,B,8 3,C,50 4,A,10 etc. I would like to extract 1,30 2,11 3,50 etc. group by the first element and then return the maximum q value of the same type, i.e. for header number 2 there...

Select Query Joined on Two Fields?

I've got a few tables in an access database: ID | LocationName 1 | Location1 2 | Location2 ID | LocationID | Date | NumProductsDelivered 1 | 1 | 12/10 | 3 2 | 1 | 01/11 | 2 3 | 1 | 02/11 | 2 4 | 2 | 11/10 | 1 5 | 2 | 12/10 | 1 ID | LocationID | Date | NumEm...

Trying to Export Data from an unusal Access Database with Synonyms

We use a product called SalesOutlook which is a type of CRM system. I need to export data from this using SSIS or some other program. When you install the program, it creates a DSN on my system called SalesOutlookReports. It use the Microsoft Access Driver (*.mdb). When I try to look at it using Crystal Reports I see a list of tables...

Problem evaluating NULL in an IIF statement (Access)

Item in the recordset rstImportData("Flat Size") is = Null With that, given the following statement: IIF(IsNull(rstImportData("Flat Size")), Null, cstr(rstImportData("Flat Size"))) Result: Throws error 94: Invalid use of Null If I change the statement by removing the type conversion upon a false comparison: IIF(IsNull(rstImportData(...

Error: operation must use an updateable query

hello, After making the set up of the application(developed using VS 2008 and MS Access) the installation in another system works fine. But whenever I try to change the Password or id(there is a login window which the user need to access to get into the main window) it shows an error sayin "operation must use an updateable query". Can an...

JET SQL: do LEFT JOINS and RIGHT JOINS only work under JET 4.0 and above?

Does the following article apply to all uses of JET (including from within client apps via DAO or OLEDB): http://support.microsoft.com/kb/275058 Does this mean JET 4.0 or above is mandatory for anything involving an Access MDB? ...

MS Access Database Check Box List Filters Missing On SQL Server back end

When I connect Access 2007 to SQL Server (whether by ADO recordset or by linked table) I no longer get check box lists (of available filter values) in the datasheet column filters. Is this feature available only with MDB/ACCDB and/or DAO? ...

select statement in C#

Where's the problem in my code ? string constr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Users\\Simon\\Desktop\\test5\\test5\\test5\\save.mdb"; OleDbConnection conn = new OleDbConnection(constr); string sql = "SELECT users.user_name,naziv,obroki_save.datum" + "FROM zivila JOIN obroki_save ON zivila.ID=obroki_save.ID_...

Problem using OLEDBCOMMANDBUILDER.

So, here it goes: I need to copy data from table in access database, in another table from another access database. Column names from tables are the same, except the fact that the FROM table has 5 columns, the TO table has 6. here is my code: dsFrom.Clear() dsTO.Clear() daFrom = Nothing daTO = Nothing conn_string1 = "Prov...

Enable Session state in sharePoint 2010

I setup a test box computer with server 2008 (standard edition, not R2 and not hyper-v editing). I then installed SharePoint 2010. I was amazed how easy the whole setup went (the prerequisites setup on the SharePoint disk made this process oh so easy – great install system). Really this was just so easy. This test box is being used for...