User Accounts Issues / Bad Set Up

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 Replies


ADVERTISEMENT

Create User Accounts

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

Setting Up User Accounts To Access A Database

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

Security Issue - Group / User Accounts

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

Queries :: Select Change ID From Changes Made To User Accounts

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

Using Access's User And Group Accounts Or Using A Login Form To Access Database?

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

Accounts Receivable

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

Duplicate Accounts

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

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 2 Replies View Related

Accounts System - Audit Trail (needs Speeding Up!)

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

Find Numerous Accounts (and Skip Through Results)

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

Queries :: Accounts Package - Combine Sum And Group By One Field

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

Modules & VBA :: Email Query - Changing FROM ID If Have Multiple Accounts?

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

Modules & VBA :: Accounts Package - Emailing Reports As PDFs

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

Queries :: ODBC - Return List Of Sub-accounts Associated With Main Account

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

Reports :: Multiple Prints Form Single Report For Individual Accounts

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

Tables :: Suitable Table Structure To Distribute Payments Among Different Bank Accounts

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

Query To Give Daily Balance Across Bank Accounts? (Then Plot In A Graph)

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

Data Entry - Auto Fill Data For Exisitng Accounts In Records

Mar 9, 2006

First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.

So now I would like to add some more functionality to this existing project.

My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.

I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.

The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.

Second I haven’t figured out how to call up the customers information from just the account field.

I’ve googled this and haven’t found anything terribly helpful.

View 2 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

Multi-User - Can You Assign Which User Created/amended A Record?

Aug 4, 2007

Hi guys,

I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...

We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...

Best ideas anyone?

dazza61

View 6 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

Calc User Totals Table 1 And Enter In User Records In Table 2

Oct 28, 2004

I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".

My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.

Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.

Thanks in advance.

Regards Peter

View 5 Replies View Related

Forms :: Second User Record Changes When First User Selects Record

Jul 31, 2014

I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.

But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.

View 1 Replies View Related

First User Allow To Read And Write / 2nd User Only Allow To Read?

Sep 2, 2014

Will like to check, i have a access database which can be open up by a few users.

How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?

View 4 Replies View Related

A User End?

Jul 26, 2005

I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.

I already searched these forums and googled for help.

View 13 Replies View Related







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