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
Highlighted
Occasional Visitor

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

1 Reply
Highlighted

@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.