I have been searching and found a few great threads about checking users but the codes there were incomplete. Is there a way to effectively log a user's name & computer name when they open your database and also log when they close/exit your database. Without them noticing but just for your own personal security incase something happens and you would like to know who all was actually working in/on the database at that specific time?
Or just something that will show me who is in the database so I dont' have to keep seeing network333 something has it open.
Thanking you all in advance, and I know I am a P.I.T.A.!
The problem I having is if I have a computer name of a computer on our network (not the one I am running the database on), is there a way using VBa to find the details about this machine.
For example if the computer name is 'DTP002133' I can click 'start' then 'search for files and folders' then click 'computers' in the search for other items. This search will give me the computer location and comments. I would like to be able to automate this process within my database.
Not sure if this one is possible but thought I'd pick you brains...
I have a split database (A2000) on a server; many people use the database at many different terminals. I would like to save the computers identification to the record being created. Any ideas on how to accomplish this? Thanks gMAC
And yes I now that's the title of a Knowledge base article, I stole it because it put into words what I can only say in expletives right now.
Basically, well it's all a bit odd. I got users on the network who, until yesterday, could access some networked databases. Other files from the same source are ok, just Access files. Today the moment they click (and I mean a single-click) on the icon to open the database...explorer hangs. You can't open the database from within MS Access either, that hangs too. But you CAN open them up and use them if you can get them copied locally. Oh yeah, some people (in the same room, on the same VLAN) can access the database, but can't perform any tasks within it. Databases are a mix of 97 and 2000. And to make matters worse, it's happening on another server.
I know you're gonna shout virus, but that looks to be a non-starter since I know of no such virus which would affect ONLY Access files and do it on a single click, and secondly The systems check out fine with both Sophos (and our good luck charm AVG) run against them.
Holy Moley! Has anyone ever come accross such a palarva?
What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
I was just wondering how many users Access would be able to handle on a split frontend and backend database? The backend will be on a network drive and the frontend will be installed on each workstation. My database is pretty simple with no relationships if that matters. Also using Win7 and some users will have Office 2010 and others will have 2013.
I will have around 10 simultaneous users of a database. Each will probably keep it open all day and subject it to fairly light use.
I will split it into front and back ends, the be going into a network folder.
Where would you recommend I put the fe?
Should I put one fe in the same folder and let them all use it at the same time? I presume that would be faster than giving them all a copy of the front end to use on their local hard drives?
I have considered adding the facility on the fe to allow user-definable defaults, like the user's name, to speed things up for them but i assume that will only work if they each have their own fe and not sure if it's worth the hassle if it's faster to have one fe in the same network folder as the back end.
Alright, so my pride and joy and departmental savior database has been fully implemented and people are so pleased with it that they *all* want to use it at the same time. Initially, I made it custom for three peoples' UI preferences, but since it's such an intuitive design, other staff now feel comfortable using it instead of passing the work down the line to the one person who knows how to use that "newfangled thing".
A couple years ago, I used FMPro and allowing for multiple users at once was an annoyingly complicated process dealing with permissions and rights and accounts and passwords and yadda yadda. Is it any easier to set up in Access? Does anything special even need to be done to allow for multiple simultaneous users?
I need to make sure that all users on the network can access a specific network drive folder.
Most users don't have a problem but some users have the network drive mapped differently so when running the feature required their system can't find the file at that specified location.
I have the location of the files hard wired into the VBA code.
E.g. Z:INVDATACOMPANIESCompanyAASSETS Pty LtdPrecedents 2015STAGE 3A - COLLS-DEMS
The location is outside of the project address.
I need to be able to make sure the address of the folder is the same for all users.
My database is used by a few users on a shared drive in "read-only" mode so they can't change any data.I set a scheduled task to copy an updated version of the database (which I edit) every morning.
The problem is that when the users forget to close the database file I can't overwrite it.For this purpose I wrote a small code that quits the application at 00:00 using Application.Quit.The code WORKS when I test it on my computer, but every morning when I try to open the file I see that it is opened by another user since I also open it as "read-only" - meaning the code didn't work...getting the code to work properly OR get a better solution to be able to overwrite the file even though it's opened by other users.
I have designed a database which I intend to split for multi-users to access from one front end icon on a shared folder at work. I have designed a form bound to cmr record table and on it a subform to another table where cmrs activities will be saved. The form has buttons to and blank controls.
User can create a new activity entry by typing into the blank controls and pressing the save button which saves to the activity table. the edit button extracts a selected records details (selected on the subform) from the activity table and populates the blank field for a user to edit and then hit save to save changes. The delete button deletes a selected record from the activity table. I intend to have multi-users either accessing, viewing and a possibly editing the same customer at the same time. The simultaneous viewing is essential but the simultaneous editing, though not desired is inevitably going to occur.
What I would like to know is:
1. Can you lock an individual record in a table or does the whole table have to be locked. E.g If Colleague 1 is editing Cmr A's record in Table1 can he lock it so Colleague 2 can view and edit Cmr B's record in Table1
2.Can Colleague 1 access/read Cmr A's record in Table1 to retrieve details toe the form controls if Colleague 2 is viewing or editing Cmr A's record in Table1
3. If record lock is possible, how can I initiate it in my example code below.Edit activity record Code
Code: Private Sub Edit_A_Click() 'Get Data to text box control With Me.R_P_Data_P_Subfrm.Form Me.txtrID = !rID Me.txtrID.Tag = !rID Me.txtrefNo = !refNo Me.cmbrpc = !rPC
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.
I don't know ASP at all, and I know very little about the Internet.I do know JavaScript and VB6 among other things, so I am not a complete dummy. I have a webpage on a webhosting company's ftp (they host asp) and my html file is working, but my asp file won't do anything (should I be calling it with the javascript from my html file?). What I want to do is make a list of the top 10 players of a game. My questions: 1. how do i get my asp to display anything? If I use my winXP IIS I can view ASP files. But from this ftp the computer just asks me if I want to run the file or save it and then opens my interdev program. Please help before I throw this computer out the window and I don't get to see your message. 2. Should my access file be 2.0 or 7.0 or whichever? 3. I use this code (from a tutorial) to connect to a database, but it doesn't work. [code] <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.open "DSNname" %> What is DSNname?(In VB6 it is the name of the data control), but there is no such thing here, is it the mdb file name?
I think I will have many more questions but for now I'll stop here.
After 2 days of searching I am sick too my stomach from not finding what I needed. I simply do not understand how it is possible that everyone, including Microsoft, assumes people just know stuff.
I have been wanted to read text files within an Access DB. The DB will extract key words and store them into fields. This is all very simple if I could get the rotten VB to read the files. I wanted to use the object My.Computer.FIlesystem, and all the others associated with that library. But going through the hundreds of possible references, I haven't a clue to which one has that library.
No matter where I went too look, not a single line, post, page listed how to reference it. Only how to use the function. So frustration.
My current reference list is as follows:
Visual Basic for Applications Microsoft Access 11.0 Object Library OLE Automation Microsoft DOA 3.6 Object Library Microsoft ActiveX Data Object 2.5 Library
Can anyone help i was in a database and my computer crashed now when i try to load the database it says it needs to be repaired so i click yes to repair it and it comes up Could not find Description how can i fix this
I am building a database of all the computers at the company i work for. Each computer has a unique ID. I want to be able to enter the ID of a computer and have its details displayed. IE. A user enters 34321 and then computer 34321 shows up and has information about its history specification etc.
I want to transfer and old database used currently for quotes etc to a new computer. I transfered all files, but when I want to open the file an error message comes up referring to the old location on a small office network. How can I import, that is use the files on new computers??
Thanks! You help is greatly appreciated! Deed, Auckland, NZ
I have a small lookup app working fine on one computer. When I copy the files to another computer, it does not recognize the search entry as having a value.
My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful,
Thank-you for your help in advance, and i apologise for such a lengthy post!
Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here.
I am trying to create an Access database that can be used to configure computers for sale in a small pc repair shop.
What i need it to do is have drop down boxes for different parts, each part having a value, and at the end being able to update the total value depending on which parts are selected.
I have tables with different types of CPUs, Motherboards, RAM, etc etc... each table has description and price values ( a couple more for relational stuff but i don't think that is needed to figure this out ) Just to test it out i have a form where i can go through and select the different products, but i am stuck on the adding of values of the different computer parts.
So anyway, i am trying to take prices matched with values from multiple tables, then add the prices all together at the end for a total value, like any of the pc configurators online.
If anyone can help, greatly appreciated, if i make no sense just ask to clarify...
For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.
Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in :confused:
Any other comments or suggestions are welcome too if there is a better way of doing this.