Need Opinions
Jan 28, 2006
Okay, as mentioned in another thread, I was given a huge project involving MS Access. I need some opinions on what to do for this situation, and here's the situation. So far, unless suggested a better idea, I'm going to have two databases. One database will be the final version, the other will if I want to make additions, changes, etc. They will contain the same data as users will only be using one and a relationship between the two will be created. I can't remember how to do it, but I remember there was a way to prevent users from changing anything about the Access file with the exeption of what the form and the vb code allows. I plan on creating some type of login using vb. The only access to the database I want users to have is what options the forms I create give them. Please give your opinions/suggestions so I can figure out what to do.
Thanks much,
jmh
View Replies
Mar 21, 2007
I'd like to say thank you to those who helped me with questions I had on my database. Even though some of you didn't even realize that you helped. Searching the forum yields answers to many questions.
So now that the database is complete, I'd like opinions. I'm attaching it as a zip file.
A couple of notes. I forgot to remove the database password so it's "fornax".
Also, being that I work for a very large hospital I cleared out my table and removed the logos.
I hid the menus and disabled the F11 key, but there is a hidden button on the far right of the footer. A double-click will restore the menus. Also try clicking on the logo--or it's place holder.
View 8 Replies
View Related
Dec 5, 2007
I have very painstakingly worked out a new database and I'm about to present it to the departments who will be using it. At various times words like 'password' and 'locked' have been thrown out but as of now I have not implemented any security measures. I started reading up on the topic this morning and the general consensus seems to be that unless there is a sincere need for them the security process is excruciating.
Does anyone have specific advice or opinions on access security? If I were to do anything, I think it would be to set up working groups only allowing users access to the parts of the database they are concerned with.
I would love any opinions or advice from people with experience of this on if I should recommend such measures or try to steer the department away from them.
View 6 Replies
View Related
Jan 9, 2008
I work for a property management compnay and they have put me in charge of coming up with a way to go some what paperless. What they are wanting is a way to enter a work order for a particular client (i.e description of work to be done for maintenance). This would then need to be printed in a report to be faxed over to the workers. This info would then need to be pulled out and placed into an invoice where, where items could be entered such as items bought ets.
My company is willing to spend thousands for software, but I think it is insane. to do so.
I was thinking that surely this could be done in access. I have an understanding of how access works (forms, reports, tables, etc.) but I have never designed one like this.
It does not have to be complex and it does not have to have a lot of formulas, I was thinking that the total could be placed in field when the invoice info is entered. Only really calculation would be adding the total of the items.
Anyway is this something that can be done relatively easily by someone with my experience, or is this to complex.
Thank You for your time
View 1 Replies
View Related
Jan 29, 2008
Main table about 3000 customers with 18 fields
Will input payments for each customer monthly and / or quarterly total about 12,000 per year.
Plan to purge payments over 18 months old frequently.
1) Put it all in one table or break into two ?
2) As far as db size wise and efficiency, would it really matter ?
Thanks in advance.
View 14 Replies
View Related
May 3, 2005
Hi,
We all know we're not supposed to duplicate data right? So was wondering how people deal with the deletion of Master records.
For instance let's say I have 3 tables.
tblSales
tblSalesSub
tblProducts
tblSales - lists the sales summary - stuff like SaleId, SaleDate, SaleTotal
tblSalesSub - lists the products contained within the sale.
tblProducts - is the Master list of products storing the product specifics
Now to prevent duplication of data I should just store the productId in tblSalesSub then reference that to tblProducts with an innner JOIN of some kind.
But what if the Master record gets deleted? The reference is broken and NULL values are returned.
How do you deal with this?
Don't allow deletion of these records?But just hide them when deleted?
Duplicate data by storing the product title and description within tblSalesSub?
Tell the user - tough cheese you shouldn't have deleted it should you?
Any other ideas?
Dan
View 3 Replies
View Related
Dec 1, 2006
Hi all: I currently have a database with a list of clients, and it is to be accessible to others to enter information on clients and to add new ones. However, I want to make it so that the user who wants to add a client can easily search the database for that particular client so that they won't enter a duplicate.
I have created a search function on my form, but then it occurred to me: what if there are two people with the same last name's? At first, I wanted a search operation to display a list of client names, along with their respective ID numbers and possibly a link next to each that would take the user to the corresponding record.
However, I have no idea how to do this, and I'm unsure as to whether or not this is the best way to tackle the problem. Please, someone show me the way!
View 7 Replies
View Related
Mar 23, 2006
Am fairly certain that I will be asked to design and implement a Machine Status Application.
Description below is very simplistic but believe you will get the idea
Basically simple stuff at Machine Operator. He clicks a command button on a display that signifies machine is okay or not. This updates machine status. Image it just toggles between Running and Stopped.
Each minute little process runs to at 1 to Run value or to Stop value. Okay so this will get a little more complex for sure.
Now I could end up collecting data on say 100 machines. Okay so I would not expect the status change to occur any more than once per hour on average so it would be a bit like having 100 very very slow users on the system.
Now the crunch. What effect (if any) would these 100 very very slow users have on performance and particularly the One much quicker user who is executing preset queries one after another for say 20 seconds every minute.
Thoughts and opinions welcome
Len
View 4 Replies
View Related
