I have an access dbase in which jobs are logged for completion by engineers.
Currently once a job is assigned to an engineer (by the service co-ordinator), it is transferred into that particular engineers queue (in access). what i would like to be able to do is to allow the service co-ordinator to assign the job to an engineer, and the job is then created as an appointment item in the engineers calendar in outlook. I have been able to create an appointment in outlook using some vb code, this works fine (using both: appOutlook.GetNamespace("MAPI") and PickFolder). The part I am having trouble with is I would like to select someone elses calendar (obviously not currently showing up in my select folder list).
Does anyone know how to access someone elses outlook mailbox?
Based on your experience, what is the faster, easier way to send e-mail in the background of an Access application, connecting to MS Outlook or using a CDO connection to the exchange server? :confused:
I'm not really looking forward to switching to the exchange server and bringing our IT Dept. into my program, but if it works better I'm all for the headaches and arguements.
In case you were wondering, this part of my application tracks education hours and e-mails empolyees when their certification gets within 4 months of expiring. This is all checked with a query. It then sends a simple text message, with one recepient and 4-5 CC to remind them about it.
I supervise a small group of people at a college. I connect to their computers through their ip addresses to share databases and files. Four out of the six people in my group have Windows 2000 and I and one other person have Windows XP.
Now this is the problem. I volunteered one of the people in my group to receive a new computer with XP (this is new to the organization) to test an image of the most commonly used software programs used in the college. There are supposed to be 5 people with test computers. The tech’s assigned to these computers are supposed to work the the employees to tweak them and make sure they work perfectly. Well our tech found a glitch. When my co-worker runs one of my Access processes (which automatically sends out e-mails in a macro) it comes out with a Mapi Spooler error. According to the tech he has done everything he can and it still doesn’t work. And because the problem is with one of the macro’s I created, they are not going any further to find the problem. They think there is something wrong with my macro.
When we first looked into the help feature in Microsoft it said the antivirus protection is the problem. The tech doesn’t think so.
I don’t know what to do. The anti virus is on the server and all our computers are serviced through our domain, so I cannot disable the antivirus.
What else can I do? I have XP and my old computer has XP and none of my processes have a problem. Any suggestions?
P.S. I am not a tech, but I do have administrators rights to all the computers in my group.
I have a form that had two active x calendars on it. The form itslef is pretty simple. I want the user to choose a begin date by clicking the appropriate date on the first calendar and then choose an ending date by clicking on the second calendar. here is what I cannot figure out. I would like my second calendar to show only valid dates, meaning only dates after the choice of the first calendar. If I cannot do that I at least want the second calendar to automatically come up with today's date. Right now when I open the window, the second calendar is Feb 2005 while my first is today's date. please help.
I'm really not sure about this one! I seem to remember reading about it but I can't find anything on it in the books.
Can you create a diary/task reminder in Outlook from an access database. I'm creating a service and maintenance database and the customer wants to be able to create reminders in his outlook by just pressing a button - is it possible?
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's. But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time.
How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek:
If I place the program on a server, how can I tell which users are using the program? Also, is it possible for me to kick someone off the program without going to their computer?
Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.
I would appreciate your comments and ideas regarding this part?
I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:
1.3 people (max) will be accessing the database, is that a problem or not? 2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?
I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?
I am trying to create a database that MULTIPLE users can log on and view the data.
Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details.
I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them.
Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once.
Can MS Access do this?
if it cant, would a vb front end located on each computer help?
What the user front-ends required in order to run/view my DAPs that put on the web? Do they really need to have Access installed (any versions is OK?) .... or anything else?
What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can 1) Kick a user off 2) Send them a message 3) Send a user a message and then kick them off
i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time. Any help will be highly appreciated.
This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.
Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?
I am pretty much self taught so nothing too technical if possible!!
Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.
I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.
Hi all, o.k prior to a previous message i have been back to my manager and informed him that there is no way of updating effectivly via email.
o.k first i will tell you what we will have: Three networked pc's running xp prof, and access 2003. Now what i want is to be able to have my database running as a server on one machine and have the two other machines running the same database simultaniously all of them updating.
Now what i need, i dont want to have the work done for me, just if someone could point me in the right direction, maybe one or two tutorials, any pitfalls i may find etc.
I am building a database which will be used by around 30 people at the same time. When telephone calls come in they will log the details. I dont need anything to explicit. I have one table, around six queries and 3 reports. I will be using one form with a save button and next record button and a switchboard. The users will log on at the same time and will log all telephone calls thoughout the day. Will the database work with so many people using it at the same time or do I have to change the properties.
I searched and doesn't seem to find anything about that question.
I am aware that there are forms that help with building dynamic queries for end users who need to juggle their data, but wondered if allowing them to access QBE would make everything easier (why reinvent the wheel?), and whether it is possible to restrict QBE from doing action queries or using dynaset to restrict end users from updating via queries which may circumvent the rules written in forms for the given data.
Have anyone had designed database with users having access to QBE? If not, how do you provide as much functionality without practically having to re-invent the wheel?
Question 1: Is it possible to use the same form, from the access database on the server, working with 3 users on 3 different pc's?
Question 2: How can I send data, wich is in the cells of an Excel file, to an Access database in a table? I have a machine that put data in an Excel-file without opening. Because I want put the data in Access I want automatically, done by VBA, send the data from Excel to Access without opening Excel. Is this possible?
