Results 1 to 9 of 9

Thread: [RESOLVED] MS Access to ???

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,794

    Resolved [RESOLVED] MS Access to ???

    Right now I am using MS Access as our database.
    The problem is that it is getting very big.
    It has about 40 tables, and a total of about 400,000 records
    File size is almost 200 MBytes

    I already tried to convert to MySQL, but the problem is that the applications (client & server app) that is using this database are about 50,000 lines together, and has a few hundred SQL statements, and almost none of the SQL statements are compatible with MySQL.

    My question is:

    To what database should I convert so that I don't have to make too many changes to our applications ?

  2. #2
    Fanatic Member space_monkey's Avatar
    Join Date
    Apr 2005
    Location
    神と歩くこと
    Posts
    573

    Re: MS Access to ???

    SQL server, its very similar command wise but a much much more robust database.
    Using VB6 or VB.net 2008 with .net 3.5
    "Life... death... either way I'll be confined to a small cubicle!" - Hermes Conrad

  3. #3
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: MS Access to ???

    CVMichael
    Converting Access to any real database solution is going to require lots of recoding because....
    Access uses a unique SQL synthax.
    Access uses DAO.
    Access uses lots of bound control.

    SQLServer is probably the best option, IHMO.
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful

  4. #4

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,794

    Re: MS Access to ???

    Does SQL Server support VB functions like:

    CDate, CStr, InStr, Format, Left, Mid, Trim, DateAdd, Weekday, Fix ?

    Because I'm using functions like the previous in most of my queries

  5. #5
    Banned
    Join Date
    Nov 2005
    Posts
    2,367

    Re: MS Access to ???

    Nope, transact uses none of those.

    cdate, cint and such are done with cast/convert, instr is substring (same with mid, left, ect ect).

    This is probably my most used link I have:
    http://www.transactsql.com/html/home.html

  6. #6
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: MS Access to ???

    I agree on using CAST for datatype conversion but..
    SQLServer does support Left, Trim (in the form LTrim and RTrim) and Dateadd.

    Also
    Weekday is replaced by a variant of the DATEPART function.
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful

  7. #7
    Banned
    Join Date
    Nov 2005
    Posts
    2,367

    Re: MS Access to ???

    My bad, he's right. I've been in .Net too long.

    m(_ _)m

  8. #8
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: MS Access to ???

    I've spent the last 4 days hacking away in SQLS, only reason why this stuff is fresh in my head....
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful

  9. #9

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,794

    Re: MS Access to ???

    Thanks everyone

    I guess it's resolved for now... (until I actually try 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
  •  



Click Here to Expand Forum to Full Width