Who Is Connected

May 2, 2006

hey gus....How can i know Who is connected to the db?
thx, Max.

View Replies


ADVERTISEMENT

How Many Users Connected To Db

Jun 20, 2007

How can we know that , how many active connections or users are using database at some specific time..

View 11 Replies View Related

General :: How Many Connected Users In Database

Dec 4, 2014

I made an access 2013 application. I want to sell licences per users. How can I know how many users are connected in the database ?

Is there an easy way to know that?

View 5 Replies View Related

Open Blank Form When Connected To Table?

Mar 21, 2005

I have a form that is connected to a table - when I open the form it loads the first record in the table. How can I make it open a blank form, ready to add a new record?

View 1 Replies View Related

Modules & VBA :: Users Connected To Split Database

Sep 30, 2013

I have an project with a split database. The data is stored in the database_be.accdb

I want to know which users are connected tot this database.

View 4 Replies View Related

Tables :: Connected Views Deliver Incorrect Data

Mar 26, 2014

Front end access 2010, back end SQl-server 2008 R2.I have all talbes and views connected to the server and due to incorrect results I found out, that the views from the server deliver incorrect data.Of course I refreshed the views in the access front end I even deleted them and connected them for new, but the incorrect data, even a different field sequence (!) remain.in a certain field there can be two different values: 1 and 2.

If opening the view I can only see 1, on the server the view shows 1 and 2, in the records, whatever is the value.This is not a calulated field.When checking this in a query in access I can select on value 2 (although I cannot see it!!) and I get the correct records but in the field itself the values still show as 1 !!

Same with other values in other fields. When I take the same SQL from the view in a stored procedure and execute is from access I get the correct data!!On both, view and sp I have the same permissions on the server!why views show incorrect data?

View 2 Replies View Related

Modules & VBA :: Send Command To Device Connected Via RS-232 Serial Port

Feb 10, 2014

Using Access 2010

How do I send the command "^G" to a device connected via serial port (RS-232) number 3?

View 1 Replies View Related

Forms :: Query Show A Combo Box To Select What Is Connected To Data

Dec 10, 2013

I'm trying to set a query with 6 fields.

My question is: Is it possible that the query shows me a combo box to select what is connected to this data.

Example fields:

HospCode; HospName; Dept; ModName; SerialN; DatInst

I'm looking to select name of a hospital from "HospName" from a list box. If no, then at least to write the name and the rest I'll get it associated with the name.

Then I need to know if I can put this in a form so the form asks same criteria?

View 1 Replies View Related

Requery Subform From Another Subform Both Connected To Main Form

Aug 8, 2014

I have a main form that has two subforms, subform1 and subform2, both connected to the main form. When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.

I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.

Me.[subform2].Form.Requery

Does not work. It errors and says it cannot recognize subform2 as a field. I have tried a field name on subform2 but I still got the same error.

View 1 Replies View Related







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