Finished Acces Db. How Should I Set Up For Users?
Feb 28, 2008
I have completed a db and am satisfied with the structure and forms. The object window is hidden when the database is opened, and the main entry form automatically opens for the user. This db will be in a network folder and several users will have access to it. I want people to be able to enter data and run reports, but not make any changes to the database itself, or accidentally delete the database file or some other change to the structure. What is the proper way to set up the folder rights and anything else associated with the previous question?
Thanks.
View Replies
ADVERTISEMENT
May 9, 2005
i have a form, in which two of the controls on the form, are unbound image controls, which display linked images. Now i have a button, which when both images have been displayed successfully, i would like to set the enabled property of this button to true.
How can i detect, that an image has ended up linking and is now fully displayed ?
Thank You
View 1 Replies
View Related
Feb 7, 2007
Im nearly finished creating my first real production database, its pretty exciting! Theres a few things that I need to accomplish to consider it 100% working and im wondering if anyone has any input on the following matters:
1) Users import their data via an excel spreadsheet. Its all done behind the scenes. One routine pulls in information about servers from an excel spreadsheet and after formatting it via queries, puts it in the main table. The spreadsheet in question starts with the servername cell. On the spreadsheet, the first row contains the name of the server, but the second and subsequent rows contain blank space in the servername column, but imply that the rest of the information is for the various connections associated with that server listed above... IE:
Column "ServerName"
Row1: Server1 IP address Switch Etc
Row2: <blank> IP address Switch Etc
Row3: Server2 IP address Switch Etc
Row4: <blank> IP address Switch Etc
Row5: <blank> IP address Switch Etc
Row6: Server3 IP address Switch Etc
and so on and so on...
What im wondering, is if its possible to fill in the blank spots with the cell above the records that start blank? (to populate the record with its respective server). Any input on methods to accomplish this would be appreciated.
2) Is there a way to attach code to the different buttons on the record selector? For tracking purposes, everything that my users do is stored in a seperate table. The only thing I cant seem to track is when users enter a record via the main data entry form. Automated tasks are no problem, but I cant seem to find a method to attach code to, say, the next record button on the default record selector.
3) I have a few queries that collectively import data from excel. When I do this, I remove confirmation messages so that users dont have to click through a sea of 'OK's. Im wondering if theres a way to count how many records get pulled in from an import, seperate which were good and which were bad, and simply pop up a message box stating that X records were imported succesfully, and X were not due to whatever reason.
4) Is there a way to sort text as if it were a number? I have a few fields that need to be text format, but contain numbers most of the time. The sorts always put 1 above 10, 9, 8, 7, etc, and id like to either find a way to make a query that changes all single digit numbers to double digit numbers or simply sort it in a numerical format.
5) What considerations should I take into account when it comes to the amount of data that access 2003 databases can effectively store and use? Ive heard that access can effectively handle 32000 records or something to that effect. Over that, what will I be dealing with? Slow performance? A complete roadblock?
I realize that there are a lot of questions here, and by no means wish to have my work done for me. Id very greatly appreciate any feedback that anyone wishes to give 8) Even if you dont want to code routines for me, thats fine.. I actually enjoy figuring this stuff out on my own, and a simple nudge in the right direction would suffice.
Thank you so very much!
View 2 Replies
View Related
Feb 23, 2007
I'm new to Access (2002) and have been trying to learn by reading books, posts, forums and practicing with models. I've set up a database for inventory, primarily to track the cost of goods sold as raw material costs change from month to month. So far I have tables for raw materials, container sizes, suppliers, and finished products. But I have a problem - in some cases a finished product is also a raw material, so cannot appear in both tables. (Let's say we make cookies and we make ice cream, and we also make ice cream with cookies on top as a third/separate finished product!) Should cookies have two records ('CookieFinished' and 'CookieRM') and can they be linked together so cost is determined before it's part of another? Is there a better way? Thanks in advance!
View 9 Replies
View Related
Jan 6, 2008
Hello everyone,
I've competed my Access Application...Finally! I spent 3 months developing it!
Now I've finished it! I want to put it in work.
I need someone to guide me step by step (Sorry I'm really get tired from searching :( ) how can I do to make my application working in a small network (5 computers) ???
I want that only 1 user (master) get the entire data; for exemple all the Orders placed from other users...
I searched for Split but I did't figure out how to create backend frontend?? and how to make difference between Front End Master and BackEnd?
Please Any guideness will be Highly appreciated!!
Best Regards,
View 5 Replies
View Related
Jan 3, 2008
Hi
I have created a small form that hold a cube of 9 boxes on it. The idea is that it will act as a small icon that indicates the system is loading. (Purely cosmetic)
I have triggered the boxes to change colour on a loop when the form loads but the problem is that the loop function is being carried out before the form actually loads. How do I get the form to display first and then carry out the loops to change the colour of the shapes?
Thanks all...
View 5 Replies
View Related
Nov 5, 2014
I have a Subroutine that is using CutePDF writer to create a PDF from a report, then attach it to a new message in outlook. The problem is the code runs too fast and it's looking for the file to attach before the file is created.
I'm getting
Run-time error '-2147024894 (80070002)':
Cannot find this file. Verify the path and file name are correct.
Yes, I know why I am getting the error, and yes I could use a loop timer, except it may be 5 seconds before the person finally clicks OK in CutePDF dialogue box, it may be 5 minutes or it may be 5 hours.
View 8 Replies
View Related
Aug 19, 2013
If I had a textbox [txtTotalDay] which its days/Time was in decimals and a start textbox [txtStartDate] and a start time and number of shifts the product can run how can I accomplish this?
Example:
[txtTotalDay] = 3.50
[txtStartDate] = 8/19/13
[txtStartTime] = 6am
[txtNumOfShiftDay] = 2
ANSWER : The time/date it would finish would be 8/21/13 @ 4:00pm
View 6 Replies
View Related
Oct 2, 2006
I am looking for a way to export my database and all linked files into one folder with automatic updated links. I would like to transfer the complete project to an other computer. Is this possible? How to do? Thank you.
View 1 Replies
View Related
Oct 16, 2006
Which is better fo running a website which is small?
MySQL or Access?
Sathu
View 1 Replies
View Related
May 10, 2005
Hi i've got a table with a couple of fields
What's in the fields is irrelevant but i'd like to
change that to *****
the original value should stay there
but when you view the record it should only give *****
for example
field value : HELLO
when viewed: *******
Does anyone know how this could be done I ones knew how it was done but can't find it anymore
plz help
View 3 Replies
View Related
Dec 21, 2005
I only want the active screen on the toolbar. and all other screens like the DB screen and forms that are not active to be hidden on the toolbar.
I hope you can understand it. else i wil make a screendump of what i want.
View 1 Replies
View Related
Jun 25, 2007
I'm not brilliant at using MS Access - can't use the VBA codes or anything like that.
basically, I want to set up a database of photogrpahs where you store thephotograph in Access, and then run a query to search for specific photos, which brings up a form showing the picture.
I seem to be OK at doing all of this so far except I can't get the photo to appear in the form - it just displays a link which you double click on to get to the photo.
I've tried to look up how to sort this on the web but don't understand the way people speak about access :confused:
can anyone help???
View 12 Replies
View Related
Jun 3, 2005
I'm getting an error (SQL command not properly ended) but main thing is, I can't get it to recognize the ms access db.
In a nutshell...I want to query the oracle db for a number and count, then scan a number into msaccess and have it 'find' the matching number in oracle and return the count only to ms access. More comments below between the code and here are table names for both oracle and access:
ORACLE: Table name is: batch_status bs
Field names are: batch_num and Batch size
MS ACCESS: Table name is tblbatchstatus
Field names are: batchnum and idcount
CODE in PASSTHROUGH QUERY:
select batch_num,BATCH_SIZE
from batch_status bs
(this works and selects all batch numbers and sizes from oracle)
(If I say 'where batch_num = 60024 -----this works also....)
However...when I add the below part...I get errors...it can't seem to match to access database....
SELECT tblbatchstatus.Batchnum, tblbatchstatus.Idcount
FROM tblbatchstatus;
where batch_num = tblbatchstatus.batchnum
And I want to just say: where batch_num = <<<scanned batch number>>> and return the id count.
View 1 Replies
View Related
Jan 22, 2006
I am a first time user of access. i am trying to create an Data Access Page which will list all entries in a table and then allow me to add, change and delete them. I have created the page using the wizard but it will not let me add, delete or update. i view all the entries at one time but that is all. the navigation toolbar shows up at the bottom but it is grayed out. any ideas on what i may be doing wrong?
thanks
brian
View 5 Replies
View Related
Jan 11, 2006
I have a two level security system to protect my date. The first uses the MS Access security, the second is a simple login system wherby a user enters their name and personal password to gain a customised view of the data eg if the user is me, I can see all tool bars, other users cannot. What I would like to be able to do is write a query wherby I can use the users login details to diplay only their data. An example of the script I built is as follows
'IF USERNAME AND PASSWORDS CORRECT THEN LOGIN TO THE MAIN SWITCHBOARD
If Me.qpwd.Value = DLookup("PWD", "AUTHORISED", "USERID = '" & Me.quserid.Value & " '") Or UCase$(Me.qpwd.Value) = "abcd" Then
DoCmd.Close
DoCmd.OpenForm "Course Booking System"
Else
MsgBox "Invalid Password"
End If
Is there a way of including a select criteria like the following
SELECT USERID, DETAIL
FROM COURSE
WHERE USERID="Me.qpwd.Value"
I have tried several differnet versions for this syntax without success!
Any help would be greatly appreciated.
Regards
Peter
View 3 Replies
View Related
Oct 19, 2006
hi,
i am currently dealing with a form which does not show data after it has been opened.
it shows the data after removing the filters from the form when it is opened.
in fact the filters are set to false
Me.FilterOn = False.
so kindly help me out from this problem
thanking you
View 3 Replies
View Related
Apr 11, 2008
Hi All
I've created a database where a query who'se result is loaded on a form uses following function --
DateDiff('d',Date(),[Target Date])-(DateDiff('ww',Date(),[Target Date])*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between Date() and [Target Date])
I've notice that 2 ppl get an error message when they try to open database, with thatt function coming on an error message
Does this mean they have older access version ?
How can I tell ? Any advise on what to do ?
View 2 Replies
View Related
Oct 13, 2004
So here's my problem. I'm trying to update a listbox in excel with values that are being pushed in a table in access. The problem is that there are repeated values in the column in access, but I only want to show each value once, regardless of how many times it appears in the table. I would give a code sample but I'm having trouble getting started...
Any help is appreciated.
--patrick-->
View 2 Replies
View Related
Feb 21, 2006
Hi,
I have a table of users somthing like this:
User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah
Users can be friends with one another and I need some way of logging this.
My 2 options (that i can see) are:
1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:
User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010
2) Making a seperate table with multiple entries for each user like so:
User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Thanks.
View 1 Replies
View Related
May 9, 2005
All,
I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time.
How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek:
debo
View 3 Replies
View Related
May 16, 2005
If I place the program on a server, how can I tell which users are using the program? Also, is it possible for me to kick someone off the program without going to their computer?
View 1 Replies
View Related
May 26, 2005
Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
View 3 Replies
View Related
Jun 23, 2005
When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.
I would appreciate your comments and ideas regarding this part?
Thanks.
View 4 Replies
View Related
Jun 29, 2005
I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:
1.3 people (max) will be accessing the database, is that a problem or not?
2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?
Thanks.
View 6 Replies
View Related
Jun 30, 2005
I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?
View 3 Replies
View Related