How do you implement user documentation in Access? I've never bothered with formal user documentation in the past; I tend to rely on good interface design to guide users (or so I tell myself). But I'd really like to know what people smarter than me are doing... Here are things I think I would consider important (in order): Simplicit...
I am reviewing an Access database of a coworker who left a macro in the database, but I want to understand what the macro does exactly. In design view, I open the macro and see there is a Specification Name field that seems to have everything I want. How do I view that file?? ...
Hi, I have a system that receives input from the public each day. Each morning when it starts up I want to run a VB script that moves every input beyond the latest 500 entries into a backup table. This is kind of a complete archive of the systems activity. I want to move (INSERT row from table 'active' into table 'archive' and then D...
Hi All, I have a CSV file with 550000+ rows, I need to import this data into Access, but when I try it throws an error that the file is too large (1.7GB), can you recommend a way to get this file into Access? Thanks, Darryl ...
I'm trying to secure an MS Access 2003 mdb using the workgroup security. I've got most of it set up (using a new MDW etc), but I can't stop people creating new tables in the database, if they've got access to open it. Am I missing something? None of the accounts have any permissions allowed, I'm doing it all through groups. Users only ...
Hi to all you mighty SQLsuperheros out there.. Can anyone rescue me from imminent disaster and ruin? I'm working with Microsoft Access SQL. I'd like to select records in one table (table1) that don't appear in another (table2) .. and then insert new records into table2 that are based on records in table1, as follows: [table1] file_inde...
How do you calculate with code the SUM of a row of data instead of a column of data? ...
I am using SQL 2005 Server Express. How can I setup a linked server to an MS Access 2000 database? ...
I'm consuming a 3rd-party web service that outputs a Dataset (from XML). I'd like to create a new table in my local MS Access database that contains the DataSet data. Is there a simple way to hand-off the DataSet to a .net object and ask it to "create a table from this"? I know that we can use different parts of ADO to extract schem...
I'm using VBA in an Access application and I would like to have a n-tuple object that contains values of different data types. Then I would like a collection of those objects. If I was doing this in javascript it would look like: var myStructure = { name: "blah" age: 33 moreStuff : "test" }; And then I would need a collectio...
I've got a table with users and their score, a decimal number ranging 1 - 10. Table(user_id, score) I also have a 1 row query with the average of the scores (about 6), and the standard deviation (about 0.5). I use MS Access 2007. I want to label the users A, B, C, D, where: A has a score higher than (avg+stdev); B has a score lower t...
i want to create a report to print invoices for certain start and end date. However, I would like to print only a certain number of records per page. i.e. 15 records per page. Next 15(16th-30th) will go on next page. Also, need total amount for each page. How do I do it? Reason is that I have preprinted statement form already with on...
I have no idea if this is possible - and suspect it may not be. I have a table in MS Access 2003 that lists some fields that are present in another table in the database. What I want to do is draw the data from the other table but in the select statement define the fields to draw by using the values in the first table. For example Ta...
I am not sure if my question is related with the tool for executing the queries. (I am using Query Analyser, Access and AQT generally). For example I have two queries. SELECT * FROM Table1 SELECT * FROM Table2 So, do the queries executed sequentially or at the same time? If the are executed at the same time, how to make them execute...
I would like to make changes to a form as it is closed. I know I need it in design for to do this, but Access will not allow the form to be in design view "on unload" or "on close." Is there a work around? ...
Hello all, I have tried to make use of linked servers in SQL Server 2008 by doing the following to access a Microsoft Access 2003 Table. EXEC sp_addlinkedserver access1t, 'OLE DB Provider for Jet', 'Microsoft.Jet.OLEDB.4.0', 'C:\tester.mdb' EXEC sp_addlinkedsrvlogin access1t, FALSE, Null, Admin, Null GO CREATE VIEW TI001APCE1265 AS SEL...
I have a customer that work with LOGICAISSE, a provider of registry cache that will be connected to MS Access database (yep it's old !) I need to have access to that database for shopping cart on the web, how to access this kind of database. For now I only have done it with SQL or SQL lite in PHP Thanks in advance ...
Hello all, I have just noticed that one of the views I create from Microsoft Access in SQL Server via a linked server is interpreted differently in different machines/setups etc. Example: EXEC sp_addlinkedserver acc465tghv, 'OLE DB Provider for Jet', 'Microsoft.Jet.OLEDB.4.0', 'C:\tester.mdb' EXEC sp_addlinkedsrvlogin acc465tghv, TRUE...
Hi django users-- I've been working on a modification of the django-pyodbc package so that it could be used with MS Access. I need this for a legacy database we are tied to at my organization, and have been doing a rather hacky job specific to my situation, but have also been making useful, generalizable progress in terms of adapting ...
Hi Guys. I have been handed a database to run a few queries on. For one query I have to find the top 10 applications, from two different tables with hundreds of records. then on row (11) I will need to SUM or Count the remaining records and name the row "Other". I have worked out the following code so far. SELECT TOP 10 ApplicationTb...