Results 1 to 2 of 2
  1. #1
    cachi is offline Member
    Join Date
    Jul 2007
    Posts
    40
    Rep Power
    0

    Default Access with MS SQL

    Hi, I have a database in SQL and I need clients to connect to it but they don't have Internet access. I mean, they'll have Internet access from time to time, but not all the time.

    They are going to be entering products into the system and they need to see if the product meets certain conditions specified on the database.
    How can I create a version of it on the client's computer?
    Would I need access or something like that?
    Thanks.

  2. #2
    silvia is offline Member
    Join Date
    Jul 2007
    Posts
    35
    Rep Power
    0

    Default

    You can create a replicate of the remote database on user's local machines.
    Personally, I would use XML files. Basically, when the user connects to the Internet, a connection to the remote server is established, and sync in an XML format is saved locally on user's machines.
    If a user updated records on whilst offline, these changes will be flagged and once connected to the Internet, you can apply those changes.
    It is not going to be an easy ride, but I think you are better off using XML files.

Similar Threads

  1. SQL Server and MS Access
    By Hima in forum JDBC
    Replies: 0
    Last Post: 04-08-2008, 03:59 PM
  2. Access modifiers
    By bugger in forum New To Java
    Replies: 5
    Last Post: 11-28-2007, 11:32 AM
  3. Replies: 1
    Last Post: 08-07-2007, 08:51 AM
  4. access cd drive
    By milinkp in forum New To Java
    Replies: 0
    Last Post: 07-20-2007, 07:14 AM
  5. access to dll files
    By Heather in forum Advanced Java
    Replies: 1
    Last Post: 07-08-2007, 01:30 AM

Posting Permissions

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