Post reply

Best way to convert access database to Sql 2000

  • March 15, 2004 at 8:51 am

    #65543

    Hi gurus!

    What is the best way to  convert Access 2000 database into Sql. By linking table or AdP project. I need to maintain security of users who can edit,update and read only. So what is the best rout to go?

    Thanks in advance

     

  • March 15, 2004 at 9:14 am

    #498787

    Hello,

      I am not a guru, but I do work with Access 2000 and SQL Server on a daily basis.

      I believe that you have more flexibility when linking to SQL tables.  If you want to use queries for your front end or reports at all then you need to link.  Access queries are good for Access funtions, examples - format, left, cint, etc..  If you use the project method, you don't have queries but views instead.  I have had a hard time, getting exactly what I want for use by my front end with this option.

      I hope this helps.

    Chuck

  • March 15, 2004 at 5:26 pm

    #498869

    That is a hotly debated topic and no definite consensus. I would refer you to Mary Chipman's discussion in her book on Access, SQL Server interactions. I don't have the book sitting right here, but look her up on Amazon.com. It is an excellent resource. Also, F. Scott Barker's "Access 2002 power programming" has a chapter or two discussing the pros and cons.

    Basically, my take is that if you are adept at writing stored procedures, you get better performance from the ADP, particularly for larger enterprises (over 50 users). But many Access developers prefer .mdb because they can upgrade and go without starting over writing the app. If you go to ADP, almost none of your code on Access forms will be useable. So it also depends on whether you have lots of working code.

    HTH

    SMK

  • March 18, 2004 at 3:12 am

    #499279

    of course use MDB (not ADP) because there are many features in MDB that is not found in ADP, and many functions in MDB you have to convert it to ADP

    also you can only trasfer data and relink your tables in MDB and use the same old Access code, forms and reports

    I hope this help u


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply