Search results for query: *

We just decided to stick with MDB faced with too short a deadline to convert for speedier runtime. From what I remember it would not convert totals queries (GROUP BY, Sum, ect) but I could be wrong.

An MDE compiled in 2000 doesn't always run on systems with 2003. It seems to be very sporadic because sometimes it will run and sometimes it won't. The only constant we found in testing was that an MDE compiled on 2000 runs on runtime or full 2000, compiled on 2002 runs on ... 2002, ect. I...

For various reasons we needed to make our Access database an MDE file. It appears that each MDE is specific to Access 2000, 2002, and 2003 meaning there will need to be a different front end for different computers. In order to create a nice smooth install process I want to write a program...

Tranman, I am using Access. My reference to Oracle was b/c you had mentioned Oracle. My thinking was that perhaps TOP 1 had the behavior you described, stopping after it finds the first recordset, only occured in Oracle. I eventually tested the TOP 1 statement on one of the queries that did...

How would that be functionally different from PaulF's solution?

That also has the same run time. Each of these solutions seems to calculate the entire query before picking whichever record/s it picks. Thanks anyway though.

Just for reference here is a copy of one of the query's SQL: SELECT tblAllegations.Allegation_ID AS 1, tblAllegations.Referral_ID AS 2, tblAllegations.FIPS AS 3, Count(1) AS 4 FROM tblAllegations GROUP BY tblAllegations.Allegation_ID, tblAllegations.Referral_ID, tblAllegations.FIPS HAVING...

I need to be able to run a set of queries and determine if each one returns at least one record. There are so many that executing using a DCount or a recordset.recordcount is extremely slow. Is there any way to quickly determine if a query returns at least one record?

#2 would be the only option. Due to privacy requirements of the data we CANNOT see the data. It would be totally unacceptable to me personally as a gross violation of privacy and very likely a HIPA violation. I did a little research and I decided that in all liklihood the only options were...

We have 2 months which I think is enough time. I am an experience VB6 developer, I have just never done anything with the web. I did do some limited things with ASP a couple years ago - just creating a website that lets you enter data into a database on the server but what we need is leagues...

We are trying to create a web-enabled reporting system. Their is a database somewhere on the client's network which we cannot have access to but the client can. The data must never be uploaded to our server, it must stay local. The client would log into our website. Our website would need...

SELECT field1, field2, etc FROM table1 INNER JOIN [SELECT DISTINCT fieldX, fieldY FROM tableZ WHERE fieldY Like '%SDF%']. As SubQ ON table1.field1 = SubQ.fieldX The above is a query that calls a query. What do I do if a query calls a query that calls a query? I...

Never mind, I just figured out that I actually had to remove all DAO.Database declarations as well. Thanks for the input, it really helped. Just as a side note, we decided not to go with the password protected queries because all you had to do was delete the password file which was exterior to...

Hello again. I just completed going through all the different possible options here and have decided that an MDE file is the way to go. Unfortunately my MDE file conversion seems to freeze up whenever I run it. I did get it to generate the file once. I ended up having to make some changes to...

For some reason the upsizing wizard does not convert 99% of our queries from MDB to ADP. Is there anyway to automate this process so I don't have to go through each query individually and rebuild it in ADP/SQL-Server?

littlesmudge says: In the code window lick on the TOOLS Menu, Select the bottom option .. .. Properties, Go to the Protection Tab - click on the "Lock Project For Viewing" and add a password. ------ The last item on my tools menu in the code-window is 'digital signature'. I looked around...

Access 2003 Menu: Tools->Security->User and Group Permissions List: Users Select 'Admin' and check all boxes Select 'User' and uncheck all boxes Exit Access and login as 'User'. I can still view the design of the query and modify that design. The only thing I can't do is to overwrite the...

Please keep in mind that I have never worked in security or SQL-Server before so I don't really know what I'm talking about. I'm quite lost right now..... The data is now stored in SQL-Server. It, however, is fake. The user will be importing their own data into the system. (Someone else is...

Would that work in Access for a large number of records assuming the back-end tables are linked to SQL-Server? Access has an upper limit. That sounds like the best solution yet, especially if I can write a script to automatically take each report and modify its SQL code to follow that pattern...

The queries aren't simple queries though. That would work if the queries pulled directly from tables, unfortunately they call other queries. Most of them have between 3 and 7 queries all used to put the data together the way the report needs. For example: Query1 takes a primary key and the...