Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2003
    Posts
    130

    Question Unanswered: Upscaling to SQL Server

    Hi,

    Currently I have a database in Access 2k with linked tables in SQL
    Server 2k. I've experimented with making very primitive web forms to
    access the SQL tables. I need to know if there's any software to design
    subforms and reports that will be web accessible.

    I think the Access queries can be put into stored procedures in SQL, but
    I'm not sure how to do this.

    Basically, I need to know if there's any software to convert most of the
    database front end. I could use Visual Basic/Crystal Reports to do most
    of what I want, but the time it would take to code may be too much.

    I would eventually like to go totally web based with the front end. I
    think I could do the forms and possibly reports in Java or Javascript.

    I'm good with C++, Java, VB, and Access but I'm new to SQL Server
    and just really need some feedback as to what to language/software to
    use to create a good database front end (hopefully all web-based).

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    Portland, Or
    Posts
    21
    I have found that php works really well for me. I was in your position about a year ago. I tried .net and I din't really like it. PHP has a very small learning curve. You can use a variety of databases it will work with including SQL server but, also postgres and mysql if that isn't enough power you can always go with Oracle as well. I personaly have chosen to use Linux and Postgres because of Licensing costs. You will find a lot of documentation on the web.

    So this is what I would do if I were you.
    1. Get something like Sybase data architect(sp) this is the best program in the world and you can get a free 45 day trial.
    2. Either Create a Linux box or get a hosting service email me and I'll give you a great one.
    3. Mess around with PHP and use a WYSISYG editor and then just embed the data output.
    4. You can still use your access front end through ODBC.

    If you have any question drop me a line
    Stephen Rich
    http://www.teniosoft.com
    Web Applications, Client Server Databases for Linux and Windows

  3. #3
    Join Date
    Mar 2003
    Posts
    130
    Thanks for the suggestions.

    I still have a few questions, though.

    1. I checked the Sybase website and couldn't find Data Architect. Could
    you give me a link to the page?

    2. I have no clue how to create a Linux box.

    3. Where can I get a trial for a PHP editor?

    4. I was hoping to get away from Access totally.

    I hope that clears it up a little.

    What did you not like about .net and were you using asp?
    Last edited by wey97; 03-14-03 at 10:23.

  4. #4
    Join Date
    Feb 2003
    Posts
    109

    it depends on what you are doing.

    if you are making a website for personal use and you want to take 6 months to do it-- the go ahead and use PHP. And if you want to hire a half-dozen linux engineers to maintain this. But i dont think that is the answer that your boss is looking for.

    But if this is for work, and you already have Access and SQL Server-- I wouldnt hesitate to embrace Access Data Projects.

    they rock my world.

    just read a lot on the subject, and then apply the skills you have and the code you have in order to move to a cutting edge client-server development platform where performance is the most important thing.

    1. Wrox/Rick Dobsons 'Professional SQL Server Development with Access 2000'

    and

    2. Coriolis/Lars Klander 'Access 2000 Client/Server Solutions'
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  5. #5
    Join Date
    Feb 2003
    Posts
    109

    DB Selection

    and just for the record, SQL Server is faster than oracle in most situations.

    www.tpc.org
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  6. #6
    Join Date
    Mar 2003
    Posts
    130
    Yeah, I don't have 6 months or any Linux people here and like I say,
    everything is already in Access. I just wanted to go away from Access
    because of some damage and corruption we've been getting. I think
    this is due to Access not being designed to be used as a shared intranet
    database.

    But I'll definitely look into Access Data Projects.

  7. #7
    Join Date
    Feb 2003
    Posts
    109

    yeah MDB was good 5 years ago

    i mean-- there is almost always some way to fix your problem in MDB.

    but moving all of your queries to the SQL Server side of the equation makes them a lot more manageable.

    and they are BLAZINGLY fast.
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  8. #8
    Join Date
    Dec 2002
    Posts
    7

    access conversion

    We had an Access2K database and converted the backend to SQL Server using DTS. We are converting the front end to VB using some shareware/freeware tools (good sites are www.download.com, and diamondedge.com/products/Convert-Access-to-VB.html (we chose this add-in)).

    We did the conversion for many reasons, but mainly to make it web based.

    Hope this helps

  9. #9
    Join Date
    Feb 2003
    Posts
    109

    i dunno man

    you really should break this down into worrying about moving the queries to the SQL Server side of the equation.

    then you can deal with the web migration.


    its 2 different phases-- and moving to ADP and then ASP isnt that difficult.

    how many forms and reports do you have anyways?

    you should probably use Crystal Reports for the reporting side--

    but to make that webbased costs something like 75k-- at least thats what they quoted me for a copy of Crsytal Enterprise (the only edition that handles any sort of logon functionality)
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  10. #10
    Join Date
    Dec 2002
    Posts
    7
    We have close to 40 forms/subforms and 30 reports. Crystal Reports is what we are using. We moved a lot of the queries into sql as views - some we couldn't.

    We are using dreamweaver MX to make it web accessible (not based - my bad) - and it works pretty smoothly.

    Anyways...thanks for your feedback aaron, you really seem to know your way around this stuff!!!

  11. #11
    Join Date
    Mar 2003
    Posts
    130
    Now I've found out that we're soon getting Visual Studio .NET at my
    company. Now I'm debating on whether to go ahead and try to
    spend a lot of time migrating our Access 97/2k .mdb's to .adp's for the
    time being or just wait to learn .NET and migrate then.

    I think a SQL Server backend and a VB/ASP.NET frontend would be a
    SWEET setup but I wanted to get some tips from anybody that's used
    .NET.

    One concern I have about a web based system is we've got a lot of
    forms that have a one-to-many relationship with a subform thats shown
    in datasheet view. As the record changes on the main form, the
    subform's requeried to show new records. The only way I know of doing
    this so far would be to use an embedded DataGrid ActiveX control.

Posting Permissions

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