D
David W
Is there a way to get the IP address and subnet of who is currently using
the backend dbf?
the backend dbf?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Hi, David.
No -- not with the Access back end. The back end consists of the tables and
relationships, which the front end links to, so an instance of Access isn't
opened in order to execute any code that might "read" information about the
environment, including who is opening the database file.
You could, however, write code in the front end that reads information about
the back end, such as the computer name and Access User ID of the computer
used to open the back end. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may also use the LDB Viewer tool to visually read who has opened the
back end. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web page:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
Is there a way to get the IP address and subnet of who is currently using
the backend
No -- not with the Access back end. The back end consists of the tables and
relationships, which the front end links to, so an instance of Access isn't
opened in order to execute any code that might "read" information about the
environment, including who is opening the database file.
You could, however, write code in the front end that reads information about
the back end, such as the computer name and Access User ID of the computer
used to open the back end. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may also use the LDB Viewer tool to visually read who has opened the
back end. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web page:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
G
Guest
Hi, David.
No -- not with the Access back end. The back end consists of the tables and
relationships, which the front end links to, so an instance of Access isn't
opened in order to execute any code that might "read" information about the
environment, including who is opening the database file.
You could, however, write code in the front end that reads information about
the back end, such as the computer name and Access User ID of the computer
used to open the back end. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may also use the LDB Viewer tool to visually read who has opened the
back end. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web page:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
Is there a way to get the IP address and subnet of who is currently using
the backend
No -- not with the Access back end. The back end consists of the tables and
relationships, which the front end links to, so an instance of Access isn't
opened in order to execute any code that might "read" information about the
environment, including who is opening the database file.
You could, however, write code in the front end that reads information about
the back end, such as the computer name and Access User ID of the computer
used to open the back end. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may also use the LDB Viewer tool to visually read who has opened the
back end. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web page:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
G
Guest
Hi, David.
No -- not with the Access back end. The back end consists of the tables and
relationships, which the front end links to, so an instance of Access isn't
opened in order to execute any code that might "read" information about the
environment, including who is opening the database file.
You could, however, write code in the front end that reads information about
the back end, such as the computer name and Access User ID of the computer
used to open the back end. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may also use the LDB Viewer tool to visually read who has opened the
back end. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web page:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
Is there a way to get the IP address and subnet of who is currently using
the backend
No -- not with the Access back end. The back end consists of the tables and
relationships, which the front end links to, so an instance of Access isn't
opened in order to execute any code that might "read" information about the
environment, including who is opening the database file.
You could, however, write code in the front end that reads information about
the back end, such as the computer name and Access User ID of the computer
used to open the back end. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may also use the LDB Viewer tool to visually read who has opened the
back end. You may find a link to this tool and other free diagnostic tools
in the "Free Microsoft Access Troubleshooting Tools" section on this Web page:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
G
Guest
Hi, David.
No. Not from the Access back end. The back end consists of tables and
relationships only, which are linked to by the front end, so an instance of
Access is not opened for the back end which can execute code to "read"
information about the environment, not even who is opening the database by
linking to the tables.
You could, however, read information about the back end database file from
the front end database file, such as the computer name and Access User ID of
whoever opens the database. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may be able to visually read the information about the back end, too.
Please see the following Web page for links to the LDB Viewer and other free
diagnostic tools in the "Free Microsoft Access Troubleshooting Tools" section:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
Is there a way to get the IP address and subnet of who is currently using
the backend
No. Not from the Access back end. The back end consists of tables and
relationships only, which are linked to by the front end, so an instance of
Access is not opened for the back end which can execute code to "read"
information about the environment, not even who is opening the database by
linking to the tables.
You could, however, read information about the back end database file from
the front end database file, such as the computer name and Access User ID of
whoever opens the database. Sample code for viewing all users logged into an
Access 2002 or 2003 database is available on this Web page (with a link to
the Access 2000 version):
http://support.microsoft.com/default.aspx?id=285822
You may be able to visually read the information about the back end, too.
Please see the following Web page for links to the LDB Viewer and other free
diagnostic tools in the "Free Microsoft Access Troubleshooting Tools" section:
http://www.Access.QBuilt.com/html/links.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.