Just An Email Admin

Apr 12, 2005

I do Exchange administration, but I use Access Databases all the time to manipulate data. That is the only way I can take care of over 25,000 mailboxes with just two people.

Here is my scenario. I have two spreadsheets. First spreadsheet has UserIDs and Names. Second spreadsheet has group mailboxes and UserIDs associated with those mailboxes. I need to send an email out using Access to each of these 500 mailbox owners. In that email it must contain the name of the group mailbox and each user's name (not ID).

Examples:
Spreadsheet 1:
User01 Name1
User02 Name2
User03 Name3
User04 Name4

Spreadsheet 2:
Mailbox1 User01, User03, User04
Mailbox2 User02, User03
Mailbox3 User01, User02, User03, User04

Outgoing emails:
Mailbox1 Name1, Name3, Name4
Mailbox2 Name2, Name3
Mailbox3 Name1, Name2, Name3, Name4

I am pretty good at Excel and Access when it comes to basic data manipulation. I know how to make Access send an email out to hundreds of customers at once. Now I just need to be able to create that form letter and plug in the names where there are UserIDs.

Anyone have a suggestion (of course you do, so just put it down!).

Thanks a whole lot in advance for your assistance in this matter. And, if you have an email problem, let me know! I can prolly fix that for ya!

Don

View Replies


ADVERTISEMENT

Could Not Use 'Admin'; File Already In Use.

May 18, 2005

I'm working on an MSAcess 2003 database and I have saved the System.mdw file to a folder on the Server and linked all users to it. When multiple users attempt to log in, they get the message

Could not use 'Admin'; filer already in use.

I have used shared system.mdw files for years with no problems. But obviously the force is not with me today.

Any help with this issue would be appreciated.

View 6 Replies View Related

Admin Passwords

Nov 1, 2005

Within our client estate, there are a number of types of machines and a number of admin passwords that go with them

I need to put an agent on each of these machines but first i need to make all the admin passwords the same or add our domain group to the local administrators on that machine.

In order to do that I need to know what the admin password is for that specific machine

So a series of attempts with various different passwords and users names are required.

so something like this maybe

dim admin1 as string
dim pass1 as string
dim admin2 as string
dim pass2 as string
dim admin3 as string
dim pass3 as string
dim admin4 as string
dim pass4 as string


call Shell("psexec \192.168.0.1 -u + admin1 + -p + pass1")
if error = 1 then



call Shell("psexec \192.168.0.1 -u + admin2 + -p + pass2")

else

end if

end

Is this the best way to approach this? - Am confused? - Thank you

View 1 Replies View Related

Could Not Use Admin. File Already In Use

Feb 21, 2006

Hi,

One of my user is getting this error when trying to launch the DB - "Could not use 'admin'. File already in use. The DB is in shared mode and other users are using it without problem. What could be the issue?

Thanks,

View 1 Replies View Related

Not Being Recognized As Admin

Jan 5, 2007

About three weeks ago, my work computer crash hardcore. Windows (2000 ver) had many corrupt files in the Windows Directory and in the Registry. Because of that, IT gave me an up to date computer running Widows XP. I am still running the same version of Office (2003 Pro).

I think because I have a new machine and a different platform, I am now have issues with trying to administer the permission rights. MS Access is not recognizing me as Admin and/or Creator of the db, therefore I am not able to modify permission rights....... :eek:

Does anyone know how make this db recognize that I am the Creator of it?

Thank you in advance for your help.:cool:

Kilch

View 4 Replies View Related

Find Out If The User Is Admin

Aug 3, 2005

Hey

On my database I did it so it checks who logs in to the machine (through API), but now I'd like to see if someone logs in to database as Admin or regular user. How is it possible ?

View 2 Replies View Related

Contract Admin For Architects

May 29, 2006

I don't know who to write and thought that I would try this list. Has anyone written, or do they know of, a Contract Administration package for Architects, written in Access 2000 or later? I am an Aus architect who dabbles in Access and doesn't want to re-invent the wheel.

Any help would be appreciated.

Cornelis (Kees) Wegman

View 1 Replies View Related

Delete Admin Account

Dec 4, 2006

Hi,

After I setup user-level security, and add the new users with Admins permission.

Why I cannot delete the Admin account?
Can we delete the Admin account forever after setup user-level security?

Please let me know about it.
Thanks.

View 1 Replies View Related

Admin Password Lost

Aug 1, 2005

Hi All,

I forgot the access database admin password. Please provide me the remedy to my problem. Your response is appreciated.

Best Regards,
Saied Aliuzzama

View 1 Replies View Related

General :: Admin Has No Permissions At All

Jul 16, 2013

Now there is only one set of permissions Admin, and Admin has no permissions at all. When I try to check admin rights or even read rights back to the Admin it says I need to be logged in as admin, which I am.

Is there anyway at all I can either copy some information from 2 tables and put it in my back up?? I'm really stuck here and need to fix this or I'll have lost considerable amounts of work.

View 5 Replies View Related

Securing The Database So Only Admin Can Make Changes.

Feb 7, 2006

I've been fiddling around with the Tools>>Security settings but I can't seem to find a way where only I can make changes to the database and the users can't just use the switchboard. If you are regular user you don't need password but if you are admin you do.

How do I do that?

View 1 Replies View Related

Any Good Links For An Auto DB Admin Prog

Jun 9, 2006

Does anyone have an updated link to a free utility download that will auto create a backup of my database as well as do a compact and repair at a scheduled time each week. Maybe twice a week if possible! :p

View 5 Replies View Related

Admin Issues When Copying Database To New Network

May 24, 2007

When attempting to open an Access DB that has been transferred from one network to another (via CD and aeroplane!) we are finding that the copy cannot be edited - the access is effectively read only... I believe this has something to do with Workgroup admin rights but this area is all a bit confusing for me. What do I need to do to open the copy up for editing - allowing the recipients to administrate their copy of the DB?

We're using Access 2002.

View 4 Replies View Related

! How Do U Create Admin Account In Command Prompt?

Mar 22, 2006

does anyone know the code for command prompt to create an administrator account over a network???

View 2 Replies View Related

Is The Current User A Member Of The Admin Group?

Aug 10, 2007

I am setting up a call log for an application. Once a message has been entered, I need to restrict access to the person who created it AND to managers (who have admin privelages to the database). Since the user who created a message needs to be able to go back in and edit it if necessary, I can NOT simply restrict access to the edit form to admins.

The command that opens this form looks like this so far:Code:If ((Me.[Transaction] = "Status Call") And _ (Me.[TransactionBy] = CurrentUser())) THEN DoCmd.OpenForm "frmEditMessage" ...Else MsgBox("Blah blah blah, etc etc.")End IfI need to add something to the initial If statement like this:Code:Or (CurrentUser.isMemberOfGroup("Admins"))but I don't know the correct Access syntax for it.

Any help anyone can give me would be appreciated!

View 1 Replies View Related

Modules & VBA :: Separate Users And Admin On Login

Jul 8, 2014

I need to separate Users and admin on login so that the admin can go to admin form and users to specific form using vba access. Here is my login code

Private Sub cmdLogin_Click()
'Check to see if data is entered into the password box
If IsNull(Me.cboUserName) Or Me.cboUserName = "" Then
MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
Me.cboUserName.SetFocus

[Code] .....

View 8 Replies View Related

Access Admin/Contractor Needed, Easy Project.

Jun 27, 2005

Hey i need some one that knows Access to help with a work Database, and just make sure everything is working and set properly.

This is for a Construction Managment Company.

Email me at *email removed* for more info, and i can send out the DB to be looked at.

Thanks

Kevin Maguire
President
GOT LOCAL MUSIC

View 1 Replies View Related

Creating Admin Function To Validate Time And Task

Feb 19, 2007

Hi all,
was wondering if there was a simple way out there, or if someone could give me some ideas on how to use an admin function to either approve or deny a users time and tasks... this wouldnt neccesarily have to a be a daily function... but i would like to have this done before the end of a pay period(2 weeks).
i feel like this could be as simple as using a check box to show approval, but i wouldnt know how to have the users submission go into a place where the admin could view to approve or deny.. has anyone seen something like this done before?
thanks in advance

View 8 Replies View Related

Reversing Startup Settings With Passworded Admin Access If Possible?

Mar 19, 2007

Thought I best ask this question BEFORE I run into trouble.

If I were to set my database to hide the database window and all menus on startup so that users can only do what I want them to do and not edit anything. How do I go about reversing this if I needed to edit something as I would not be able to see any of the regular menus?

It would be good if the solution involved some sort of admin password rather than a sneaky short cut that a user may accidently stumble across.

View 5 Replies View Related

General :: Set Password For Tables And Forms - Allow Admin View Only

Apr 21, 2013

I have a receptionist which uses a database that contains everything in the company ..there is an employee table that contains their salaries and I want to set password for this table so that the admin is the only person who can view this table .......... is that possible?? And the same thing for a form that controls this table!

View 4 Replies View Related

Modules & VBA :: Change System Date / Time Without Admin Privileges

Mar 31, 2014

I have an Access 2010 application running on Win 7 Pro which connects to a Back End SQL Server database. I am trying to get Access to synchronise the client pc system date & time with the Sql server date and time. Please note, the date/time does not necessarily have to be correct, it just has to be consistent between the server and all the pcs running the Access application.

I have tried two methods as follows. But both only work if Access with Administrator privileges, which isn't really practical.

Method 1:

Code:
Dim MyDateTime As Date
'Some Code here to get MyDateTime
If MsgBox("Change date & time to:" & vbCrLf & vbCrLf & MyDateTime & "?", vbYesNo, "Change") = vbYes Then
Date = DateValue(MyDateTime)
Time = TimeValue(MyDateTime)
End If

Method 2:

Code:
Private Type SYSTEMTIME
wYear As Integer
wMonth As Integer
wDayOfWeek As Integer
wDay As Integer

[Code] .....

View 2 Replies View Related

General :: Lock File Shows Admin User Active For All Clients

Jul 2, 2013

We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.

View 12 Replies View Related

Queries :: VBA Code On Subform To Lookup Email Field On Table And Launch Email?

Jun 26, 2015

VBA Code to go in the on double_click event of a name field in a Subform bound to a table. The subform is just a copy of a data table and within the subform view, When the field "employee name" which contains e.g. John is double clicked, I would like access to Lookup and get John's email in the employee table under field "Email" and launch outlook application and insert it into the To field.

I assume hyperlinking the field can also achieve this similar to what excel does but I am fast learning that what is standard functionality in excel is a whole another story in Access..

View 3 Replies View Related

General :: How To Send A Single Email Message To All The Email Addresses In Query

Jun 2, 2014

I have a query (Access 2007) that contains a field named "email" (which contains email addresses, of course). I want to email everyone in the query and they are all going to receive the same message. My email to them doesn't have to be personalized and I don't need to collect data from the recipients. I don't even need a reply to the email I send.

View 12 Replies View Related

Modules & VBA :: Form Which Has Button To Email Data Out In Standard Email Message

Jan 15, 2014

I have a form which has a button to email the data out in a standard email message.

Private Sub Command60_Click()
Dim MyDb As dao.Database
Dim rsEmail As dao.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String

[code]...

This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when not all of the fields are populated, for instance, the address might only be 5 lines.I know I can do this using IIf statements on a report, but how can i achieve the same thing for the email.

View 6 Replies View Related

General :: Send A Specific Email From Outlook To All Email Addresses Within A Query

Jan 21, 2014

I have a database that I can use to create a query, grouping companies by city. I then want to send a specific email I have created in outlook to all of the email addresses in the query.I do not need to include names.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved