1. Is it ok to use dbSeeChanges when setting rs for tables that are in Access? I may not know where they are ...
2. If a column changes in SS, will the table relink when Access is opened again?
thanks for the article, Bill
~ have an awesome day ~
Most of my Access applications use linked SQL tables. You can treat them just like Access tables. You don't need to use pass-through queries in most cases. Just regular Access queries. That lets you use all your functions as you normally would. Having an Access front end gives you the power of VBA.
There are a few things to understand about using SQL tables. I've written an article concerning this topic. http://www.thatlldoit.com/Pages/howtosarticles.aspx
Look for the article titled "Working with SQL Server Linked Tables: The Hidden Gotchas"
Sorry about the anchor links not working...Another "MS broke my site" issue.
Regards,Bill Mosca, Founder - MS_Access_ProfessionalsMy nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <email@example.com> wrote :
My mscaccess database has grown so much that I need to upgrade to SQL server.
I am in need of some guidelines, is there a or tutorial or a good book?
I already followed the upgrading wizzard, but I have more questions, like:
Can I use VBA in the sql server environment? or is there another scripting facility?
How do I write passthru queries with built in functions ?
I seem to understand that that is not transferable from msaccesss, what is the solution in sqlserver environment?
Hope you can give me some good advise!
Thanks in Advance
Posted by: crystal 8 <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|