Jumat, 01 Agustus 2014

[MS_AccessPros] Re: Best option for handling data from Microsoft 365's Azure SQL

 

Ryan


I have rarely used class modules so I can't comment on whether or not you should use a class or a standard module. As to using local tables, it might be a good idea in this case. But beware that creating temp tables will bloat the front end. I'd set it to compact on close. While some think that risky it really isn't when it comes to a split database since if the FE blows up you just get a new copy.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Yahoo Groups
New Feature! Add Polls to Conversations
You can now include a poll directly within your message. Members can view, vote and add poll options either via email or on the group. Try it today!

Did You Know?
Learn more about how to search within your groups.


.

__,_._,___

Tidak ada komentar:

Posting Komentar