Access 2000 to SQL Sever 7.0 Advise

Results 1 to 2 of 2

Thread: Access 2000 to SQL Sever 7.0 Advise

  1. #1
    Join Date
    Dec 1969

    Default Access 2000 to SQL Sever 7.0 Advise

    I have to build a site and eventually have it work with SQL Server 7.0. What I&#039d like to do is build it first in with ACCESS 2000 then upsize and modify the connections. Is there any reason I shouldn&#039t do it this way?<BR><BR>Table building and modifying and creating mock data is much easier in ACCESS 2000

  2. #2
    shan Guest

    Default RE: Access 2000 to SQL Sever 7.0 Advise

    i would advise you to go for sql straight up pal...<BR>here are some of the reasons that i could think of...<BR>1) access is not a client server database it is a file server loads the woule **** table into ur desktop...<BR>2)access uses page locking as opposed to record locking..when it comes to web based applications this is not a healthy situation..<BR>because access locks six records together.<BR>3)if you are using date functions in ur application you will end up in a big mess when migrating...<BR>4) why would u wanna go through the hassle unless there is a good reason for it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts