Home

why cant i use View and Triggers in access?

%3CLINGO-SUB%20id%3D%22lingo-sub-1028775%22%20slang%3D%22en-US%22%3Ewhy%20cant%20i%20use%20View%20and%20Triggers%20in%20access%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1028775%22%20slang%3D%22en-US%22%3E%3CP%3Ewhy%20cant%20i%20use%20View%20and%20Triggers%20in%20access%3F%20I%20receive%20a%20syntax%20error%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1028775%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eviews%20and%20triggers%20errors%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1030436%22%20slang%3D%22en-US%22%3ERe%3A%20why%20cant%20i%20use%20View%20and%20Triggers%20in%20access%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030436%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F466968%22%20target%3D%22_blank%22%3E%40Chris1967%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20details%20about%20your%20unsuccessful%20attempts%20to%20use%20Views%20and%20Triggers%20in%20Access%20will%20be%20very%20helpful%2C%20but%20some%20preliminary%20thoughts%20might%20be%20in%20order%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20%22View%22%20is%20generally%20taken%20to%20mean%20a%20specific%20type%20of%20object%20in%20a%20SQL%20Server%20(or%20other)%20database.%20We%20refer%20to%20%22saved%20queries%22%20in%20Access.%20These%20are%2C%20for%20the%20most%20part%2C%20conceptually%20the%20same.%20So%2C%20if%20you%20are%20merely%20looking%20for%20the%20corollary%20to%20a%20view%2C%20it's%20going%20to%20be%20a%20%22query%22%20in%20Access.%20If%20you%20mean%20something%20else%2C%20we%20need%20to%20know%20what%20that%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Triggers%22%20exist%20in%20SQL%20Server%20tables%20(with%20corollaries%20in%20other%20RDBMSs).%20In%20Access%2C%20the%20corresponding%20tool%20is%20called%20a%20%22Data%20Macro%22.%20Triggers%20in%20SQL%20Server%20are%20far%20more%20robust%20and%20powerful%2C%20but%20if%20the%20functionality%20is%20what%20you%20need%2C%20look%20at%20Data%20Macros%20for%20your%20Access%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%2C%20if%20you%20mean%20something%20other%20than%20this%2C%20please%20explain%20in%20sufficient%20detail%20to%20help%20us%20understand%20the%20actual%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Chris1967
Occasional Visitor

why cant i use View and Triggers in access? I receive a syntax error

1 Reply

@Chris1967 

 

More details about your unsuccessful attempts to use Views and Triggers in Access will be very helpful, but some preliminary thoughts might be in order as well.

 

First, "View" is generally taken to mean a specific type of object in a SQL Server (or other) database. We refer to "saved queries" in Access. These are, for the most part, conceptually the same. So, if you are merely looking for the corollary to a view, it's going to be a "query" in Access. If you mean something else, we need to know what that is.

 

"Triggers" exist in SQL Server tables (with corollaries in other RDBMSs). In Access, the corresponding tool is called a "Data Macro". Triggers in SQL Server are far more robust and powerful, but if the functionality is what you need, look at Data Macros for your Access tables.

 

Again, if you mean something other than this, please explain in sufficient detail to help us understand the actual problem.

 

Thanks.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies