Sarah
I don't know how data macros translate with linked SQL tables. As I said, I've not used them. If you use a trigger on a column in SQL you shouldn't use a data macro on the same field in an Access table.
I'll try and make some time to test.
---In ms_access_professionals@yahoogroups.com, <sarahk@schemesoftware.com> wrote:
Bill,
So what do you mean?. I need to rewrite an old ERP application and was thinking of rewriting it in Access. Smaller customers could you an Access DB back end and larger ones an Sql Express back end. Are you saying that this is not the way to go?
Sarah
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Jim
They are actually more like triggers in SQL Server. They fire when a field is changed or added/deleted. One good use is to update a field like ModifiedBy where you want to keep track of the last person who updated a field. It's easier than writing code for it and is probably the only way to do it when it comes to web forms since you can't use VBA with those.
Like John, I haven't explored this new feature mainly because I use SQL Server databases for most of my back ends. Access is definately movong away from desktop databases. That might be good for some, but I'm not thrilled about it. Eventually, I know I'll have to move from Access to something like C#. But until then I'll stick with VBA.
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar