Re: Live record counts
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Tue, 3 Apr 2007 12:32:08 -0700, TOMAC <TOMAC@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
We have 2 MS Access front end guis we use to enter data into an MS Access
master table, stored in a llinked MS Access database on a shared network
drive. I want to be able to run a procedure/macro whenever the record count
in the master table increases. I can tell when I add a record to this table
becasue I hit the save record button. However, I need to run the same
procedure/macro when the other user updates the table too without exiting the
data entry gui.
Does anyone have any idea how I can tell if the master table has been
updated by the other user?
Not sure if this is the proper place to post this but thanks in advance to
anyone who can point me i teh right direction!
In other databases, a trigger would be used for this kind of thing. But since
Access isn't a real client/server database, it doesn't support triggers.
--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.
Relevant Pages
- Re: Live record counts
... stored in a llinked MS Access database on a shared network ... I want to be able to run a procedure/macro whenever the record count ... in the master table increases. ... Dim NewCnt As Long ...
(microsoft.public.access.formscoding) - Re: FileCopy locks source-file
... I have made a client-application which uses data from a local Access database. ... The application has builtin update functionality, ... If the master database has a higher version than the local database, ...
(microsoft.public.vb.general.discussion) - Re: Get custom database properties from an Access database
... I could start a local copy only if the master is unavailable. ... If my database gets hosed, or even the entire machine stolen, it doesn't matter, it's only a snapshot of the actual data and can be rebuilt any time it's necessary. ... Dim wshShell ...
(microsoft.public.scripting.vbscript) - Re: Replication problems
... An error occurred while accessing the DHCP database. ... DHCP server event log for more information on this error. ... browser for the domain on transport NetBT_Tcpip_{99B638B5-2C0B. ... master browser is stopping or an election is being forced. ...
(microsoft.public.windows.server.active_directory) - RE: SQL Server failing to start (directly effecting sales!!!) Error: 823, Severity:
... You should consider calling Microsoft Technical Support as your master ... They will want your SQL Server Errorlogs ... that the machine with the database has hardware that is failing. ... Even if you are planning to reinstall you should make a backup copy ...
(microsoft.public.sqlserver.msde) |
|
