Tech Off Thread

3 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

New media db

Back to Forum: Tech Off
  • User profile image
    Rake

    I need to re-build the media database our my job, the old web admin did it with access 2003 instead of the sql 2000 server we have on the backside. There are 2 packages 1 package has about 22 pages and the other package has 14, those pages where used for ordering that specific package. It was working fine until it was time to add new packages and then a error saying something to the effect of it be too many fields or somthing:@

    Anyway at this point it might as be well be re-done from scratch. The display page for each package needs to show

    Order Plan Package Name Space Price


    and the ordering page needs normal info name,address etc. how should i build the db?

  • User profile image
    Ang3lFir3

    while I agree that re-designing the DB might be a good idea for the future ... have you tried using the Upsize/Upscale (i forget the correct name) utility in Access 2003 to upsize the DB to sql2000 directly?.... this may save you some real time and headache and allow you to keep the current app online while reworking the DB.

  • User profile image
    Rake

    I forgot about that. I will give it a shot and sql takes with me having to change anything.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.