Track Users Computer Name & Network Name?

Nov 29, 2006

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.!

View Replies


ADVERTISEMENT

Locate A Computer On The Network

May 12, 2006

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...

Thanks

View 2 Replies View Related

Network Computer Name Saved In Record.

Jan 20, 2006

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

View 2 Replies View Related

Computer Hangs Accessing Network Database Files

Oct 6, 2004

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?

View 2 Replies View Related

Track Changes By Users

Mar 8, 2006

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?

View 13 Replies View Related

Track Users

Aug 22, 2004

hello all... i tried to search an answer for my questions but i couldn't...

what is the easiest way to track users and their login time???

View 3 Replies View Related

Max Users On A Network Drive

Oct 23, 2014

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.

View 2 Replies View Related

Access 2007 Max Network Users

Feb 13, 2008

Hi, Guys

Im just wondering what the maximum number of simultaneous connections to an ACCES 2007 DB over a network,(obviously a mapped drive).

I apologize if this is a double post....

Cheers
Tristan F

View 2 Replies View Related

Where To Store FE / BE For Multiple Users On A Network

Nov 9, 2014

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.

View 14 Replies View Related

DB On Network Drive -- How Difficult To Set For Multiple Users?

Mar 31, 2008

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?

View 3 Replies View Related

Modules & VBA :: Users With Different Mapped Network Drives

May 13, 2015

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.

View 3 Replies View Related

Modules & VBA :: Application Quit Doesn't Work On Network Users

May 26, 2014

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.

View 10 Replies View Related

Modules & VBA :: Record Locking Multi-users Over Network Split Database / Access 2007

Aug 5, 2015

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

[code]....

View 8 Replies View Related

Question About: A Table Of Users Who Have Relationships To Other Users??

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

Computer Name Or ID

May 27, 2006

Anyone know how to get the computer ID or name unique to your computer?

I want to be able to use it in a database to keep logs for each computer on the network.

Any ideas?

View 9 Replies View Related

Please Help My Computer And Me

Dec 3, 2006

Hi

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.

Thanks

View 2 Replies View Related

My.Computer.Filesystem

May 19, 2005

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

If someone can please help.

View 5 Replies View Related

Help Computer Crashed

Mar 31, 2006

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

View 2 Replies View Related

Computer Database Help

Jun 14, 2006

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.

Where do i start?

View 4 Replies View Related

Cannot Open *.mdb On New Computer??

Jul 29, 2007

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

View 6 Replies View Related

Migrate To Another Computer

Mar 24, 2008

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.

What have I missed doing?

Thanks

View 2 Replies View Related

How Can I Check Which Computer Is In Use

Oct 13, 2006

Hi,

I made one database. Inside the database, I want to make a screen that show that which computer is in use of the current database.

Can we do that? Does anybody know how to do?

Thanks.

View 1 Replies View Related

Sync With Computer Clock

Jan 18, 2006

Hi,

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.

Chris

View 6 Replies View Related

Computer Configurator - How To Add Prices Together?

Feb 20, 2006

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...

james

View 1 Replies View Related

Computer Identification - Security

Apr 11, 2006

In my Frontend, i use parameters like:

1) computer name
2) a certain file's existance

So i'm sure that the front end is being run on an autherized computer.

i have hardcoded these values in the vb code and password protected the project so that no one knows about it.


what other parameters can i use to stop the front end being run from any other computer else than thoses allowed.

View 6 Replies View Related

Computer Booking Form

Sep 30, 2006

Hello,

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.

Thanks, ieuuk

View 3 Replies View Related







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