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 ...
I have developed an access 2007 runtime application. I have a few fields that are OLE object fields. But when I test the application in runtime it will not allow the user to attach the docum...
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...
I'm working on a large project for my emplyoer. We now have enough data that we are worried that someone could open up the database and accidentally delete things etc.
What are my options f...
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...
Hi
I've imported a table from excel to access.
the dates field was imported to a text field (because there were multiple date formats including text in this field)
the problem is that t...
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...
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...
We have an Access database written using Access 2000 then modified in Access 2003. The users are now using Access 2007 and we set up the trusted locations and all seemed fine for a week. Then ...
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 thought I had the soluton with the previous question, but then I found a problem. I have an auto counter in the database. Since the database sits on a network, more then one person can use...
I'm looking for a code snippet that will allow me to link tables "on the fly". Specifically, I need to have a front end connect to several different backend DBs. The different DBs all have t...
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 understand that Access 2007 can edit the design of SQL tables (on a SQL 2005 Server). How do I do this? I have a ODBC connection to the server and that's about all I know about it. I want...
I have a database that was created in ACCESS 2003 (working database). This database works off linked tables in another database. We recently went form ACCESS 2003 to ACCESS 2007. The linked...
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 ...
Hi,
I am inquiring for expert opinions of which method is best suited for an Access application that is remotely accessed by VPN Client to a shared folder on a network drive?
With Replication being taken out of Access 2007 I have a huge problem. When i convert my db into Access 2003 i am able to replicate but then the embedded macros that most of my buttons use, no...
I have a Dart League Database I have inherited... My question is I have a Query, based on the PlayerStats table that is supposed to return results of the lowest PPD (Points Per Dart) in a sin...
The temporary locking file (.laccdb in Access 2007 and .ldb in all prior versions) that is created when a user is "in" an Access database, contains info on sharing the database.
I'm wonderi...
Our HR Database is currently experiencing issues whilst running over Citrix.
This is the application location command line in the Citrix Program Neighbourhood:
"M:\Program Files\Microsoft ...
user level security
I want to have user level security on an Access 2003 mde file. Is this possible?
I have created lots of Access databases and I want to create custom shortcut for each database. Can anyone recommend some good software or templates for cutom shortcut?
Thanks
This one should be simple:
I have a normalized table of Players, their stats, how many seasons they played, and when they started.
Everything is working great. The one thing i do need i...
I accidently set a field in a table to "Yes" to "Accept Multiple Values". I am trying to set it back to "No" but keep getting the message that this cannot be changed back. I'm a little irritat...
