Posted
by Rick
on Server Fault
See other posts from Server Fault
or by Rick
Published on 2010-06-01T13:34:33Z
Indexed on
2010/06/02
12:56 UTC
Read the original article
Hit count: 326
Is it possible to restrict MS Access creation but still be able to view and execute Access files.
© Server Fault or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and…
>>> More
as seen on Super User
- Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files.
In one case, the user has 2007 on his PC and opend the front end in 2007. No problems.
When the the user is done, he clicks a button that executes a macro full of update queries. The macro…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have created an autoexec macro in MS Access 2007 and cannot find it!
I know its there because it runs, but I cannot find it to delete or modify. I can see other macros that I have created just not the autoexec one.
Can someone please point me in the right direction to find where it is located…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm looking for a way to connect to a MS Access 2007 database from Java. I don't believe the ODBC way is available to me as I'm writing on a mac and will be pushing this product to Linux. The HXTT drivers also do not work with 2007.
Is there a way, a tutorial, an example, etc that accomplishes this…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi All,
I have a huge database (800MB) which consists of a field called 'Date Last Modified' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out some queries.
I have another exact same database but with only 35MB of data inside it and when…
>>> More
as seen on Super User
- Search for 'Super User'
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query.
Here's a example of my scenario:
cmbCarMake
Behavior: User starts typing, and list…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have the following data in my database:
MemberID | DateTime
-------------------------------------
1 | 31/03/2010 3:45:49 PM
2 | 31/03/2010 3:55:29 PM
1 | 31/03/2010 4:45:49 PM
Every time a user is authenticated or un-authenticated this log appears in the database…
>>> More
