Setting Up Group Accounts In Ms Access
Dec 7, 2005
Hi folks,
I'm new to MS Access and these group forums, and have just taken over an admin role, so please bear with me.
I'd like help with the following. Just nearly had a catastrophe with MS Access, but luckily I've managed to get it back to what it was this morning.
We have a Task Database, set up years ago, which is held on a centralised server, and each person accessing the database has a folder called C:/Task, with a Task.mdb icon, which then links to the main database. This works OK.
I also have a database on another server, which is used for logging problems, and handovers. I've set this up as a One stop shop, with a nice front view, from which I have links to all our databases, and other documents, one of which is the Task Database. This worked fine until this morning.
What I was attempting to do was to setup access to that it recognises the person logging on, and instead of saying Hello Admin, it will say Hello xxx.
I tried setting up a new multi user environment, by updating the Workgroup Administrator. I set up a new .mdw file called system.mdw, which worked on my task database, when I logged on directly.
However, when I log on via the front database, it won't open up the Task Database, as it says that the system.mdw file is in use.
Is it possible to set Access up, so that you can use logon account on more than one DB ???
I've now reset the Workgroup Administrator to point back to WINNT/system.mdw, and it now allows me to access the task db from my front db... So, I'm back to square one.
Please, please can anyone help?
Ta
Karen
View Replies
ADVERTISEMENT
Apr 18, 2006
I've created a database and I now need to set up user accounts for access to it, so that I can restrict who has read only and who has write only permissions.
I've done this before and never had a problem! But this time, whenever I try and create a new account, the following message is displayed:
Cannot update. Database or object is read-only.
Can anyone help as to why I get this message and what I can do to stop it! Whilst it does this, I can't create any user accounts.
Any help would be appreciated!!
Thanks in advance
View 1 Replies
View Related
Sep 9, 2005
Using Access's User and Group Accounts or Using a Login Form to access database?
I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.
I also saw some sites where they give an example of a Login Form and how to create one.
My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?
But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?
Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.
How would I go about creating that. Hope I made my explanation clear.
Thanks in advance.
View 3 Replies
View Related
Aug 17, 2006
I moved my access database and not my user account do not have privelages. However, the group accounts they are linked to have been set-up correctly. Why would my group account privelages be ok, but when I look at each user individually they have no privelages set. I'm confused as to why this would be if the users are in the specific groups I have set-up.
View 3 Replies
View Related
Sep 6, 2013
I'm making an accounts package.
I've got a query that shows all individual invoices with their total amounts. This works.
But now I'm trying to make graphs so I want show just total amounts combined by customer, for each customer.
So for example if I had 8 customers and they each had 10 invoices each my current query would be returning 80 records.
What I want is 8 records, once for each customer with the summed total for each customer so that I can then graph this.
View 3 Replies
View Related
Jul 30, 2005
Account Receivables
Hello, just want to ask on how to report a two detail report.
I am creating an Account Receivables report that displays all the invoices for a customer as well as the payments received against them and also the balance due on each invoice.
1) The first detail have the records that are not paid or not fully paid
2) Second detail contains the Returns.
3) Third, set off payments against the respective invoices and calculate the balance due on each invoice.(or) balance unallocated payments as the case maybe.
4) Total days outstanding for each invoice grouped as 30, 60, 90, or over90 days old.
I can manage the fourth one, but I need help on the others. Can anyone please help me?
regards,
Carl
View 1 Replies
View Related
Sep 15, 2006
Hey all,
I have a table with account numbers, but need to find duplicate matches only, can't get it going.
AccountRef
Total: Group By
Criteria HAVING COUNT AccountRef >1
Thanks.
View 1 Replies
View Related
Nov 18, 2005
Firsty, hey all!
I have recently set up a small stock system for my company, and during the last stages i was setting up the user groups and security settings.
Unfortunatly i am now in a position where i cannot modify anything at all! It seems i have set up the 'Admin' group, myself, with no permissions at all. i have one copy of the DB which has a database password, which i know, but no rights to change user privlages nor the ability to open exclusive. There is only one user set up - 'Admin'.
I also have another copy which has no DB pass, but fails to open due to access rights again.
I think i have made a real boo boo. Unfortunatly as all the tables, forms, queries and macros are protected i am unable to even import them into a fresh database without a complete rewrite.
Anyone got any ideas on this?
Thanks
View 6 Replies
View Related
Jun 1, 2007
hello,
I have 2 questions:
1) How do I add an icon to a form in ACCESS 2007 (and where do I get it
from)?
2) How and where do I create different user accounts for the data base
(ACCESS 2007)?
Thank you very much
View 5 Replies
View Related
Mar 16, 2008
Hi all,
Through years of hard work I have created a fully functioning double-entry accounts system with epos and inventory management capabilities for my retail business.
Each transaction is stored once - either in tblPurchaseInvoices, tblSalesOrders, tblPayments, tblReceipts or tblJournalEntries.
The double entry part is created automatically by queries as is all the vat/sales tax information. Producing: qryPI_VAT, qrySO_Vat, qryPaymentVat, qryReceiptVat, qryTradeDetors, qryUnpaidInvoices.
The audit trail then combines all of these queries (a total of 11!) in a union query. This is obviously a very slow process and produces 63,354 records currently. Searching for information in this list is a nightmare as are calculations!
Can anyone point me in the right direction of creating a more efficient audit trail. I would have thought one transaction table would be the way to go but I can't see how it could be done.
Thanks in advance for any help.
Cheers,
Chris
View 13 Replies
View Related
Jun 1, 2005
Put simply - when I do a find it displays the first account that matches it, then, when you leave the find screen and hit the "next record" key it simply displays the next account (i.e it no longer matches the search criteria).
So my question is,
How do I search records, then skip through ALL accounts that match the criteria.
example:
100 accounts in a database. 50 accounts are assigned "Mr A" and 50 "Mr B".
Mr A and Mr B sit down to work - hit find, and type in their name.
The form shows 1 account, and when mr A hits next fifty times it should not move on to mr Bs (possibly a "no more matches/records" message?).
I hope this is clear enough - and thanks in advance.
ps - I heard something about one form to search - and a subform to display results - the search criteria is static in form one, where as the subform can be skipped ("next record" pressed). But trust me - Im inexperianced :p and would need a nice newbie friendly description of such technological witchcraft.
View 1 Replies
View Related
Aug 5, 2013
How do I change the account from which to send the email if I have multiple accounts, or can I?
View 14 Replies
View Related
Jul 19, 2013
I've created an accounts package for my business using access 2003 and I'm just thinking of some time saving features.
We need to email our invoices to our clients.
Normally we print out an invoice, scan it back into the computer, save as a PDF and attach to an email manually one by one.
My package can now print to PDF (saving one step), but what I would like is to be able to print to PDF and attach to a new email (with the email address coming from the customer table) and possibly attach more than one PDF to a single email.
I know you can use
Code:
DoCmd.SendObject acReport, stDocName
to send a report but I would like it as a PDF as my formatiing is lost using that code and we normally send PDFs to our clients.
View 14 Replies
View Related
Jun 12, 2013
I have a few tables, one of which stores a record of changes made to user accounts, and some of those changes are linked to a "multichange" table for when I have made the same change to multiple accounts.
What I am trying to do is select the change_id from my changes table, with a limit of 1 as I only want one result (it will always be the same) but I am using this query and getting a syntax error telling me I have a missing operator.
Code:
SQL_SELECT = "SELECT change_id from dbo_user_change where username = '" & username & "' AND change_type = 'new account' LIMIT 1"
Set qresults = CurrentDb.OpenRecordset(SQL_SELECT)
Do While Not qresults.EOF
multichange_id = qresults.Fields(1)
qresults.MoveNext
Loop
qresults.Close
View 5 Replies
View Related
Jan 6, 2005
I am having some problems setting the default value of a field to the user name of the person logging on to the database.
I have created a *.mdw for my individual database and would like to include the current user id of the user creating a new record.
Anyone out there have any ideas how i would go about doing this?
:confused:
View 3 Replies
View Related
Sep 9, 2004
I am using vba code to create a new MS Access 2002 database and copy the current database tables, forms,etc into it.
The problem I have is there are several references that I need that are not set in the new database I created. One of them is the DAO reference. My question is, is there a way that when I copy the DB the references from one will be copied to the other? or is there a way to set the preference and priority using VBA?, DAO needs to be higher up on the list inorder to work.
I use the following code to create a new db
Dim cat As New ADOX.Catalog
cat.Create ("provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sName & ";")
I then use the transferdatabase command to copy the tables, forms, etc to the new database
is there a different way to copy the current db into a new db that will include the references
I also can add a reference using the following code
Set ref = References.AddFromFile(spath)
AddReference = true
But this doesn't set the priority
View 3 Replies
View Related
Jul 28, 2015
I have a query which looks at a linked table (ODBC to SQL Server) in order to return a list of sub-accounts associated with an account. If I run it as a pass-through query it executes correctly, returning a list of the sub-accounts. If I run it as a query in Access it return the correct number of records but each sub account has the same name as the main account, as follows.
Result of pass through:
Main Sub
A X
A Y
A Z
Same SQL in Access:
Main Sub
A A
A A
A A
View 1 Replies
View Related
Nov 14, 2007
When opening Access, the default printer changes from "Letter" to "User-Defined". The output is then unreadable. I then change it back to "Letter" and all is fine until I reopen Access with the same result.
I'm using Access 2003 with a Brothers HL1440
How can I make Access leave the printer's default setting as it is?
View 8 Replies
View Related
Dec 15, 2007
I am having a problem with displaying the scroll bars in Access. I have created a database which is viewed correctly in 1280x720 screen resolution, which is our standard setting. However, we have recently taken on some users with sight problems, and they are using a different screen resolution.
This means that the forms do not fully display on the page, and I would like to add scroll bars to the access window rather than the form so that the user can move up and down the displayed form. Is this possible?
Any help will be much appreciated!
View 2 Replies
View Related
Jul 30, 2014
I am using the group by function to remove duplicates based on certain fields. However, I want the Primary Key ID to also be returned .
If I add it to the select statement, I have to also add it to the Group By line which messes up the duplicates.
So...how can I just view the ID field in my return without making it part of the group by function?
View 2 Replies
View Related
May 11, 2015
I have a report , which i print every month and it consist of of more than 500 pages. This report is based on a Query called L_Inv2. i want to filter and loop this report based on the filed AccountReference with in the query. And save as PDF for individual accounts.
i have also created another query based on the L_Inv2, Called L_Inv4 which only got the record of account numbers as a AccountReference
i am trying to use below code but some how this is not working.
Code:
Private Sub Command43_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
[Code]....
View 6 Replies
View Related
Aug 17, 2015
Looking for efficient table structure for this. Let's say I have a list of contractors who will get paid a certain amount of money each week. The amount of money changes each week by measuring the amount of work done, giving it a price and calculating it. The fields are these:
[pk]WeeklyWorkID
WorkID
Quantity
UnitPrice
Total=Qty*UnitPrice (not stored in this table)
EmployeeID
WeekID
So far, it's all good, but we wish to pay the contractors in an unusual way. Let's say he makes $16,000 of work this week, and we want to pay him using cash AND/OR either one or multiple debit cards. For example:
Cash: $1,500
Debit card 45: $7,500
Debit card 71: $4,000
Debit card 13: $3,000
Total = $ 16,000
We can only deposit $7,500 max in each card. But it's even worse... two or more contractors can SHARE the card and it's not always the same card. Sounds pretty funky, but it's what the company wants to do. So, what would you recommend me in this case?
I'm guessing I'm gonna need these tables: tbWeeks to hold the week number, tbCards to store the cards' info, and an extra table to make a many to many relationship between the cards and the employees.
View 2 Replies
View Related
Feb 22, 2015
How to build query to give daily balance across bank accounts? (to then plot in a graph)
Assumptions:
* There is a table TRANSACTIONS which includes columns TRANS_DATE, AMOUNT and BANK_ID. It does NOT include a column for balance. So current balance for a bank account is the sum of the AMOUNTs for that BANK_ID for example. Balance on date XX will be the sum of all AMOUNTS for that BANK_ID for all TRANS_DATE's prior and including the date XX.
* Table BANKS which has BANK_ID and TITLE
Would like a query that gives: Supply StartDate and EndDate for the query:
Date Bank1Balance Bank2Balance Bank3Balance TotalBalance
1/1/15 $100 $200 $100 $400
1/2/15 $200 $200 $100 $500
.
.
.
etc
View 1 Replies
View Related
Jun 14, 2013
I have three tables.
Table 1: Group
Field 1: Group Text field ( Primary key)
Field 2: Group Description Text field
Field 3: Uidgroup( Autonumber)
Table 2: Subgroup Text field
Field 1: Group ( I want to bound this column to Table 1's Group field that is column 1) I have set bound column property to 1 and column count 1 and the Subgroup table is showing group fields as input perfectly no issues in that )
Field 2: Subgroup, Text field( Primary Key )
Field 3: uidsubg( Autonumber)
Table 3: Email
Field 1: Group ( Bound to Table1's Group ; showing values in combo box, setted bound column property to 1 and showing group field perfectly, no issue in that )
Field 2: Subgroup (I want to bound Table2's subgroup field, which is column number 2, so I wrote 2 in bound column property and row source is table subgroup ; Here is some error comes up, values from subgroup field of subgroup table not being shown up in Email Table's subgroup field as combo box. )
Field 3: Email Text field
Field 4: uideml (Autonumber ) primary key
I want to prepare a Data entry form should have all these fields from all the tables. That should work in following way, first user selects Group then User selects Sub Group and write Email and save the record.
What relationship should I set, or shall I change the table structure.
View 1 Replies
View Related
Apr 17, 2013
How would I use the Access 2010 setting, 'Compact on close'?We have a back end on a server and many users with front ends on their computers. So would I set 'Compact on close' on the back end? And then it would compact when the last user logged out?
View 3 Replies
View Related
May 29, 2015
Despite Google I can't seem to figure this out.
I have some data in a format similar to:
Name / Style / description / speed / distance
john / driver / careful / 80 / 5500
mary / driver / careful / 70 / 7000
pat / racer / reckless / 100 / 6000
anne / driver / careful / 75 / 1000
peter / racer / reckless / 110 / 6500
don / snail / slow / 60 / 6000
I want my report to total by style, without details and to look like:
driver careful 13500
racer reckless 12500
snail slow 6000
How do you get a report to sum the group items by a specific item and to hide the details of that group summing?
View 2 Replies
View Related
