Results 1 to 3 of 3

Thread: Help again

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Help again

    I have a database with SQL server 2000 as the engine and Access 2000 on the client end (GUI user interface) I was wanting to make a switchboard like the original one in accesss only I dont have that option to use it when the tables are sql tables instead of access tables. The only I could come up with is a form with buttons on it that lead to different forms but it doesnt have the same abilities as the original switchboard in access. When I click on a particular form button the form comes up but the original form is not hidden, its just not the same..and I dont know vb so what can I do?

  2. #2
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    I'm not sure I completely understand your question, but you should be able to export all your Access table to SQL, drop your existing Access tables, link the SQL tables (via ODBC), rename the tables to the appropriate names and everything should work like a charm. Unless I'm missing something, of course.

  3. #3
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    You're from Lakeside? Well, Yee Haw!!!.


    Just kidding!

Posting Permissions

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