General :: Block User Access To Tables / Queries?
Apr 24, 2015Is there a way to securely block the access of user to tables/queries, else in Microsoft Access?
View Replies
ADVERTISEMENT
General :: Block Pathway To Backend Folder But Allow Access Via Frontend Database
Jul 17, 2012If I have an MS Access frontend that connects to an MS Access backend, is there a way to hide/permission block the pathway to the backend's folder but still allow access via the frontend db?
Right now I can't dedicate a server to a more "secure" form of DB or anything like that so I'm stuck with MS Access for now. I just don't want someone looking at, say, a link table path and then navigating to that folder and getting access to backend information.
Block A User To Login
Jul 1, 2013I Have a table votes where a user is able to vote for a specific campaign, when the user votes his username and the date and time is logged in the table votes.
After the user voted he is logged out, then displaying the login form for the next user.
At the login form I want to check if a user already voted and if so he should not be able to login again. How can you do this ?
Forms :: Block User From Writing In Textboxes If They Have Not Selected A Date
Aug 21, 2014I have a form that has four textboxes, date dropdown box and a date box. I am trying to get the form to do the following: Block user from writing in the textboxes if they have not selected a date in the date box.
Get the datebox to look at the behide screens records to see if there has already been a documented date (duplicate date) and inform the user that this date has already been used. Then auto them to the date dropdown.
General :: Access Multi User Database - Error On Only One User
Apr 24, 2013I 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.
General :: Securing Frontend By Disabling Access To Linked Tables / Queries
Mar 24, 2014I'd like to secure my frontend by disabling access to the linked tables, queries etc. I thought converting to .accde would do this but apparently not. Is there a way that this can be achieved?
I am aware that I can disbale the ribbons etc but they can all be turned back on using the options menu.
General :: Building Address Block For Labels
Dec 4, 2012My database contains business names and addresses in separate fields (name, address, city, zip code, state, country)
Now I have to build the address block for labels.
If there were just US addresses it would be easy but a business can be located in any country with the problem being
that countries require the block to be build in a specific way (order of city, state, zip code).
In some cases a particular section has to be upper case as well.
Of course I can build it manually in a memo field but the with chance of something easily going wrong I like to automate it.
It does mean the same info will be stored twice which is basically a no no.
I'm thinking of making a separate table with records for all possible layouts and use those as a source for a memo field in the business table. However I can't oversee if that would work alright or not.
Or should there be a way to generate the blocks on the fly?
General :: Error / Encrypting With A Block Cipher Is Incompatible With Row Level Locking
Nov 21, 2012What is "row level locking"?
How can I get around the "encrypting with a block cipher is incompatible with row level locking" error.
I've never had this error before and I do not know what I did to cause it.
Block Unauthorised Of Access Of Table
Jun 10, 2005Hi all
Please help. one of my table is confidential data and I don't want people from opening from the table. Can I block people from opening but people who has password can only access this information.
eg. please see my enclosed attachment file and the table is cost. I don;t want people to see the data by click the table filename.
Hope someone can help me.
General :: Multi-User Database Access?
Sep 10, 2013I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??
View 7 Replies View RelatedGeneral :: Handling Concurrent User Access
Mar 22, 2015I need to develop a database for HR department for hiring. There are about 30 departments in the office and these departments are distributed among 12 HR officers. Each HR Officer works on 2 or 3 of these departments at a time throughout the day. Currently the HR department is using Excel Workbook to keep record of each department (hence 34 Workbooks in use). I want to convert this system in Access.
Now the problem is that I am confused how to handle these department. To keep record, every department has exactly same type of data. I was planning to make one table for each department and make one form to enter data into each table (hence total 30 tables for departments). This sounds weird approach. I have done this to avoid concurrent access problem.
If I make one table to keep data of 30 departments and one Form for entry, will it be possible for 12 users to open the same DB, open the same Form and Insert/Update the same table at the same time? What approach should I follow?
General :: Make Warning Pop Up When User Tries To Access Database?
Feb 5, 2013How can I make a warning pop up when a user tries to access a database that another user is already in??
View 13 Replies View RelatedGeneral :: User Level Security / Access Control
Jun 27, 2012I have a question about user level security / access control.For my database I have a back-end containing the tables and a front-end with forms, queries and everything. I have set up the access user level security.Dependent from the access level of my users, some front-end options will be hidden and some queries retrieve only part of the data. For example: I have a form to calculate clients' end prices. A vendor can only see prices for his own clients, not for other vendor's clients.
BUT: to make the query work, all users need access to the tables and the back-end must be stored in a public place, right? Now all vendors can just open the back-end and see all information.Maybe protect the BE with a password and store this in the queries?
General :: Access Form - Allow User To Browse For Excel File
Jul 18, 2012What I would like to do is create a form that lets the user browse for an excel file, then will click an "import" button which then imports all the fields in excel into a table.
View 1 Replies View RelatedGeneral :: Disable SharePoint Access Setting Option For Certain User
Oct 3, 2014I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?
View 2 Replies View RelatedGeneral :: Access FE User Auto Copy Most Recent File
Jun 4, 2013I have an access 2007 database that is split front end and back end. There are about 15 users and the backend is stored on the network. Currently I am e-mailing out the FE when chagnes are made so they have the latest copy.
With everything I have read I think a bat file would work the best at allowing me to make changes on demand without having to continually email out new versions of the FE. Sometimes the changes are behind the scenes unnoticable to the user while others are obvious.
Questions: Exactly HOW does a bat file work? When the user clicks on the access file stored on their laptop? Where is the bat file stored? I am unfamiliar with where to write the bat file code as well - notepad perhaps?
I am not sure how to create a bat file and what the code should be?
For version tracking I need to put a version table in the BE and in the front end correct?
have made a few significant changes but I'm holding out e-mailing it if I can get this version copying figured out and in place first.
General :: Security And User Read / Write Permissions - Access 2010
Jul 19, 2013I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.
The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.
I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.
General :: Naming Of Tables / Queries
Dec 19, 2012Im putting up my Access table/query names for critique, because at some point Ill have to hand over this database to someone else and I want to see how they might react. So if you opened a query list and saw the list below, would you be able to find your way around, or are there too many similar looking queries?
Some of the queries are made up of 6 or 7 of the other queries. I find its easier to see what going on if they are separated out into individual queries, rather than throwing them all into a single select statement, and it means I can re-use things that I know work.
I get stuck on using plurals vs singular (e.g. StoresDeductions or StoreDeductions); how much detail to put in (e.g. BrokersChainsStoresCasesByMonth); how to indicate totals or being grouped by e.g. month; how to indicate date parameters, i.e. whenever a query says MonthRange it asks for this range, and any queries built on top of this one also have MonthRange in their name.
Code:
AccountsTotalNumStores
BrokersChainDeductionsMonthRange
BrokersChainDeductionsMonthRange_Crosstab
BrokersChainNumStores
BrokersChainsTotalsByMonthRange_Crosstab2
BrokersChainTotalsByMonth
BrokersChainTotalsByMonthRange
BrokersChainTotalsByMonthRange_Crosstab
BrokersChainTotalsMonthRange
[code]....
General :: Renaming Tables / Queries Using Navigation Pane
Feb 6, 2014I understand the principle of renaming the above of using the navigation pane and selecting the object but what is happening in my case is that when I select the specific table/query I wish to rename, the text is highlighted as per normal but the instant I move the cursor onto that cell that whole panel highlights in red and then reverts back to the original state of just the text in that panel (now highlighted).
I do not know if this is related to the problem but I have a text box with the "code" =Count([tblEntries].[CageNo]).
This was working perfectly okay but both this and the renaming appeared to happen about the same time. I have opened other Access files and the same re the renaming occurs. I have secure security running and do not think this could be the problem but anything is possible.
General :: Naming Of Tables / Queries / Forms And Reports For Identification
Sep 22, 2013Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?
View 1 Replies View RelatedGeneral :: Unified Same Tables For 3 Different MS Access File
Mar 31, 2015I have 3 sets of MS Access File (NEDA, RDC,& Summid) built with the same sets of structures. Originally at MS Access 2007, but now I'm using the built in 2010 version for Lenovo Flex 2.The table consist of:
*Chart of Accounts
*Journal Entry Voucher Master File
*Journal Entry Number Master File
*Supplier Master File
Queries are the same (links, designed, etc...)
Forms are also the same (links, designed, etc...)
Reports are also the same (links, designed, etc...)
The difference for these three file is the Journal Entry Number because each file requires a different JEV format...Example:
-For NEDA it should be NEDA-Year-Month-Number Series
-For RDC it should be RDC-Year-Month-Number Seried
Laslty for summid it should be Summid-Year-month-Number Series and separate transaction listing for the purpose of calling data for the report, such as List of disbursements and trial balance.But for these three MS Access file, Chart of Accounts and Supplier Master File do have the same set of data. That's why whenever a data is not available I am encoding the said information in each MS Access file (inputting the data three times).Example:If an asset account such as Office Supplies is not available, I will input in the Chart of Account Form for NEDA, then RDC, then Summid.
Question
Is there a way where I can unified the Chart of Accounts and Supplier Master File into one but still can entry/edit the same in each MS Access forms. Also can still link to each queries, tables,and reports?So that I will encode data one time only and save space.
General :: Publishing Access Tables For Runtime Viewers?
Feb 4, 2013My office recently purchased Microsoft Access for our secretary to keep track of our contacts. No other employee owns Access so we have to distribute the tables through Access Runtime. However, there seems to be a problem.
I save and publish a database using the Packaging Wizard. I then send the associated folder with the install program to a computer which has Access Runtime installed on it. But, when I install the file I created with Packaging Wizard it just opens an Access window that is completely blank. It's actually the same thing that occurs when I try to open an Access file on a computer that doesn't have Access or Runtime installed on it at all.
General :: How To Create Forms In Access DB Which Uses Links From Source Files As Its Tables
Sep 7, 2012I have a client who needs a Database created in Access for him. he would like to regularly auto-populate this Access DB from an Excel file - like twice a week.In addition, he wants me to create Forms, Queries, reports and Macros for him in the Access, which will have 2 Tables from Excel files and about 3 Tables created in Access.I figured that I could do that if I gave him a link to the Tables he needed from the Excel file(s). But how do I work remotely for him- the path to those files is on his computer. I can load them to mine, but then he can't open the files.How can I create Forms etc. in an Access DB which uses links from source files as its Tables?
View 2 Replies View RelatedAccess Tables Behaving Like Queries!!!
Feb 4, 2007Hi,
I'm a bit puzzled with this so hopefully someone can help me out. I have a database that has around 20 users who key on their vehicle orders. The main orders table has a number of fields. I have started to notice that the 'Order Date' field that gets populated on completion of the record is now blank on almost half the records. (I have retrieved an older copy of the DB and the dates are there, so they did get input at one point). Further more, I have another field called Business Group which is a look up to a linked table. The Orders table is showing the records in Business Group Ascending order for some reason rather than by the primary key. And finally, when I open the table a progress bar appears at the bottom of the screen stating 'running query'. It seems my main table is now behaving like a query and is losing data.
Anybody got an idea what's going on?
And yes I have definately checked it is a table. Im using 97
Cheers
Queries :: Search Multiple Tables In Access?
Jul 19, 2013I have a database built in Access 2000. It consists of the following tables:
45 tables each containing the same fields - ID, Vehicle, Fit, Part No, Qty, Level, Higher Assembly.
1 table containing the fields - ID, Part Number, Description, Issue No.
The 45 tables are each for a different vehicle build of materials, whilst the single table contains the additional common data that each vehicle form pulls in when the build of materials part number is added.
I want to be able to undertake a search across the 45 vehicle tables to look for a specific part number that I enter in the search box, and then if any is found, for all those vehicle to be displayed, along with the part number, description and issue number from the single table.
New Kid On The Block
Jul 13, 2005Hi-
I am a self taught beginner in Access applications, so excuse my lack of expertise and terminology. From reading through this forum, I realize how far I have to go. I am not a techy by any means.
My question: I have a database that keeps track of the delinquent taxes for our Town. One of the reports is set up from 2 queries, then 2 related tables (beginning balances and payments made). The query calculates the balance of each account based on the beginning balance minus the payments made, and returns a report which shows each account balance, and then another query returns a report showing the total balance of all the accounts due for the date the report is generated.
I am wondering if there is a way to generate the balances due on a previous date. For example today is July 13, and I want to know what the balances were on July 1. Both tables have a date field- beginning balance has a start date, and the payments table has the dates of any payments.
Thanks in advance for any advice