Jumat, 25 Oktober 2013

[MS_AccessPros] RE: Data Macros

 

 I agree with J. Viescas, Access 2010 Inside Out is an awesome book.  I've been left out on a limb with no training trying to manage 15 + databases so I got this book to help and I have learned a lot!

 

I'm hoping SharePoint 2013 Inside and Out is as good :)

 

John F



---In ms_access_professionals@yahoogroups.com, <sarahk@...> 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:

Hello all,

I am studying for my 2010 certification in Access and came across Data Macros. I have never used them. Has anyone else? I know they are like stored procedures is what I am told. 

Thank You

Jim Wagner

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar