I have a large dataset, say 1,000,000,000 rows, that lives on a server. I need a user to be able to consume (i.e. "run queries upon") that data seamlessly, over the web, from within Access and/or Excel. Additionally, I need to filter the data on the server-side according to the user connected to it. My current approach is to create a we...
Imagine this: a prototype data entry system has been created using Microsoft Access and VBA. The entire application is the Access file; it holds the front-end forms implementation, the business logic and the backend data storage. A business meeting is being held where they are discussing the future of this prototype. Some individuals ar...
The scenario in question relates to the much-maligned Microsoft Jet database engine. The assertion was that the Data Access Objects (DAO) data access technology is 'native' to Jet, the implication being that creating an object via the DAO model is 'superior' to doing the same via SQL code executed from within in the Microsoft Access user...
What's the equivalent of an MS-Access crosstab query in TSQL? And Is there a better way? I have a data organised like this: Fish ID Name ---- --------- 1 Jack 2 Trout 3 Bass 4 Cat FishProperty ID FishID Property Value ---- ------ -------- ----- 1 1 Length 10 2 1 Girth 6 3 1 Weight 4 4 ...
I have a table orders that keeps all order from all our stores. I wrote a query to check the sequence orders for each store. It looks like that. select WebStoreID, min(webordernumber), max(webordernumber), count(webordernumber) from orders where ordertype = 'WEB' group by WebStoreID I can check it all orders are present with this qu...
Over the years I have seen many errors on corrupted Access *.MDB files. I do not use Access as frontend, just as backend to store data Tables. I already use the best practices: normalization, close the database connection ASAP, etc. I was wondering if somebody knew which the best commercial tool to recover data from a corrupted MDB file...
I have two tables in MS-Access, U and R. I have joined them together and want to compare two fields. However, because there are X Tags in both to compare I am getting X lines. As you can see on ID 4 and 2 there are two tags in each table and they are both the same however because of my query I get four lines back because it compares all...
We've got an Access Database Application. (Disclaimer: We'd have preferred a different technology, but things happen ...). In order to use and develop the database in parallel, we've split the DB into a "data" (backend) and "application" part as seems to be best practice for Access DBs. Now the performance has been degraded, queries tha...
How can I insert a description for a column in an Access table using SQL? I do: CREATE TABLE TAB_A (COLUMN1 TEXT(30), COLUMN2 REAL, PRIMARY KEY (COLUMN1) but how can I insert a description for each column? ...
Hi. I've created a database in access 2007 that needs to be used by 3 users. I'm stuck because I don't know whether to place a copy on each users' computer or to place it on their SQL server. Placing it on the server would mean one access point which is desirable for data consistency but I don't know whether I need ActiveX. Don't know ho...
What program/programming language would be ideal for creating an Access like database on a Windows 5 CE hand held scanner? We have tried Visual CE but it is not really something we can work with. Ultimately we would love to build a system where we scan a bar code, select a user from a drop down list, select basic options of division, l...
I am writing a distributed DB Application with an Access Front end. Essentially an mde with some forms and reports. Should I use an access mdb to hold the backend tables or use MySQL or some other database? ...
Hello, I am really stumped on this, I am not sure if someone can at least point me in the right direction? I have an MS Access Reporting Application. It has a few local tables in it but predominantly relies on tables from a SQL Server 2005 database that it links to. It links to the SQL DB via a System DSN. I have built a function th...
Is it possible to create a nested looping query in Access DB that will update a third table? I have a master (header) table: ------------------------ masters ------------------------ num | modality | cost | ------------------------ 01 | thing | 23.00 | 02 | thing | 42.00 | 03 | thing | 56.00 | 04 | apple | 11.00 | 05 ...
Is there a way to read a MS Project (mpp file) from ACCESS VBA?? ...
I want to do something like this within an MS Access query, but SUBSTRING is an undefined function. SELECT DISTINCT SUBSTRING(LastName, 1, 1) FROM Authors; ...
Although the actual schema is a bit more complex, the following should be a bit easier for me to get across. In one table I have a list of jobs: Job Status Open date Close date 1 Closed 04/29/2009 04/30/2009 2 Open 04/30/2009 3 Open 04/30/2009 ..and in another I have a list of notes associated wi...
I am writing a C++/MFC application that will use Microsoft Access to store data. I hope using it will suit my purpose : small, lightweight way to keep application's data. the question i'm asking myself is : if I use Access as DB, will the client's machine be required to install Microsoft Access to use my software ? thanks. ...
Hello everyone. I have a Database program which uses MS Access. The time has come and I need to make it a client/server app. The idea behind the scheme is: Server holds the database, and one or multiple clients need to access it simultaneously. The program will still need to operate under Ms Access (because porting DB and rewriting the...
[ edit ] For the record, here's the problem portion of the query, which is now working: SELECT m.groupNum, t.ea, ( t.ea - ( t.ea * m.margin )) AS estCost, (( t.ea - ( t.ea * m.margin )) * t.quantity ) AS salesSub, ((( t.ea - ( t.ea * m.margin )) * t.quantity ) / ( SELECT SUM(( t2.ea - ( t2.ea * m.margin )) * t2.quantity ...