By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Is a table open or visible

P: n/a
Hi,

Is there a way to check if a table has been open or is visible
programmatically? Or if a table has been opened? Also, if a table has been
opened is there a way to prevent records from being deleted or changed in a
table view? I'm using Access 2000.

Thanks in advance for any help offered.
Nathan Bloom
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SA
Nathan:

1.) You can test whether a table is open by calling code like:

If sysCmd(acSyscmdGetObjectState, acTable, "YourTable") = acObjStateOpen
Then
Do Something
End If

2.) The only way to prevent records from being deleted or changed in table
view is to implement Access' security model. Then you can assign users
various permissions such as read only or no permissions on tables, and use
only queries to view / update / delete data and assign permissions to
various groups or indivduals to run specific queries.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Nathan Bloom" <na*******@earthlink.net> wrote in message
news:wD*****************@newsread1.news.pas.earthl ink.net...
Hi,

Is there a way to check if a table has been open or is visible
programmatically? Or if a table has been opened? Also, if a table has
been
opened is there a way to prevent records from being deleted or changed in
a
table view? I'm using Access 2000.

Thanks in advance for any help offered.
Nathan Bloom

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.