Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL, Access and Internet (SQl 7/ Access 97 sr2)

    I need some help!!!! I have a SQL server 7 database and I want to create an access database to enter records and produce reports. I also want to put this on our internet sight and let the user run the access program to enter data. Is this feasible? If feasible, where do I begin????

    Thanks,
    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL, Access and Internet (SQl 7/ Access 97 sr2)

    You will need Access installed on each of the machines that will use the application, and you'll need adequate seat licenses for SQL Server. If you're missing either of the above, it won't work.

    Do you have a DBA for the SQL Server database? Security is very different in SQL Server from Access, and if the database is large or the queries are complex, they'll need to be converted to stored procedures and executed from Access rather than using Access queries, which can be slow even against a SQL Server back end.
    Charlotte

Posting Permissions

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