I'm updating a client's Access front ends programmatically to change linked tables from an insecure Access back end to a more secure MSSQL database. The linked tables seem to be read-only, bu...
Hello experts,
For some reason I can't find ANYTHING on Google about how to build a simple asset tracking database. All my searches come up with software to purchase. I have Access 2000 and...
I recently migrated my Access 2003 database to 2007, and now only one person can open it at a time. Access 2003 allowed my program to be run by several people (I don't remember the exact numb...
Hi,
I'm trying to create a uner menu bar for use in my Access 2007 database system i am creating, however i'm a little unsure as to how to impliment a custom ribbon. I have sotware which a...
MS Access 2003 has a great Imprt utility for XML. I would like to accomplish the same task programtically using C#, I have search the Google over and never found a true solution. Does any...
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...
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 ...
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 ...
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...
I have set up an access system which will take bookings for a company. The user ideally wants to have it in a calendar style (like Outlook), so I am trying to implement a FlexGrid. I was giv...
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 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...
Hello Experts,
I have a basic Access/dbase question i think.....
When buliding forms for end users should I use lookup tables for the dropdown or Select queries for the dropdowns. At fi...
Currently, I have a Microsoft Access Database 2007. Multiple people need to access the application at one time, but receive "Read Only" accesss. Is there anyway to allow multiple users full ...
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...
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...
Attached is a database file by mbizup - The request was to be able to add a new record from the top as opposed the the bottom. He did a great job with this.
In short, I am trying to get th...
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 am building a database. I have created a model of the major entities and am now building the tables and relationships. It appears that when you create a Lookup field that uses another table ...
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...
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'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...
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 table that has a auto number set as the primary key. I'm on record number 300, but would like to erase all the records and start over at 1. Is that possible?
Is it possible to move the header down a little and have an additional body on this form?
