I use Access 2007 and love it. When I need help with something, I would prefer to upload an .mdb file that more folks are going to be able to open. Are there any specific limitations of the ...
Hello, I'm still a rookie to MS Access, using version 2003, and would like some help/input on determining table relationships for a few examples. I do have one other post at the MS forums in t...
I have developed some MS Access dbs using version 2002 and want to test them in the 2007 runtime enviornment.
If I right click the db icon and choose 'Open with' and then click on the 2007 ...
I have an MS Access program that monitors bids/quotes. Each bid has a bid manager and a due date associated with that bid. I run a query to determine if any bid are due within the next day. ...
When access opens the Switchboard, is there a way to cover or hide the start menu bar at the bottom of the screen? I am trying to make prevent users of the database from 1/2 entering data or ...
Currently there is a Microsoft Access Database containing thousands of customer records, details such as emails, address, phone numbers and more. There are many linked tables, and the data is ...
Hi Experts,
I created a database using Microsoft Access 2007, and put it on a computer that uses Microsoft Access 2003. I can't get the database to open properly using 2003. Any ideas? T...
Converting ADP format from Access 2002-2003 to Access 2007
I'm running a test instance of Office 2007 to work out compatibility issues. The project opens fine, however, the ability to conve...
Hi
I have a split Access database. On opening the databse (not sure where to find this event) I want to
check if a table tbl_A exists and then if not create the table using SQL code, run b...
Hi Experts,
I am trying to design a jewellery making database in access. I have certain components that I buy from various different suppliers. I'd like to have an individual record for the...
I need to create an MS Access Database that collects information from employees mid-way through a long-term assignment at an offsite location. I need to track the following information and all...
Found part of my answer in the following answered question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23333891.html?sfQueryTermInfo=1+2007+access+secur
It says to o...
Is there a VBA way to change the users monitor resolution in an unpon open event proceedure?
I have developed an application in MS Access. It resides on a shared network drive. It appears tha...
Hi,
In Access 2007 I'm trying to add values to a table field with a data type of Number, format set to standard, decimal places set to 2. No matter what i do, if I type the value into that ...
I'm trying to use user-level security in an MS Access 2003 database to disallow access to some forms (this I can do without much trouble), and allow read-only access to others so that the user...
Hello Experts,
I am working on an assignment for school, which is actually completed, but the instructor left me with some "thoughts for the future", that I don't quite understand. My table...
I am having a password protected Database in msaccess. what i need is to remove protection from this database. I want this same database which is not password protected. how can i achieve it.
i am running into a problem calling a MS Access 2003 macro that runs functions in a module. I need to call the macro from either a batch file or vbscript. the problem with running the batchf...
I have a replicated database that I need to make design changes to. I've opened a new, blank database and want to import the objects from the design master so I can redesign and test changes ...
In Microsoft Access 2003, you could create a "start-up file" or autoexec batch file that set the preferences for Access itself such as: Macro Security, start-up form, etc. I'm looking for a t...
I have a user without Access installed. They need to view an Access 2003 databse. Not sure what to do and I don't want to install Access.
I recently developed an Access database at my company with Access 2007. Developing the database and all of the forms, etc was problem free until I split my database. Since that point, problems...
Please offer alternate methods that may accomplish the same thing if needed
I have two tables with a table structure as follows
Table Name = ITEMS
item code
item description
item...
I am trying to add a registry key using Access package solution wizard see this question for background.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-De...
I want to setup an mde file with user level security. I have made the mdw file for the mdb database but how do I make the mdw file for the mde database?
I have used the user lever security ...
