Go Back   Access World Forums > Members List

 
flscotty1 is on a distinguished road

flscotty1 flscotty1 is offline

Newly Registered User

Visitor Messages

Showing Visitor Messages 1 to 1 of 1
  1. Rx_
    06-10-2015 06:22 AM
    Rx_
    Saw that you plan to split the DB - put it on the WEB.
    This will probably lead you to SQL Server and AZURE.
    Just wanted to give you a tip. Use SQL Server.
    To link tables to use either version, consider using DSN-Less tables with SQL Server Native Client 11.0
    We have posted regarding this subject.
    An example of the code might look like this:
    strConnectionString = "ODBC;DRIVER=SQL Server Native Client 11.0;" & _
    "SERVER=productionsql\MyServer;DATABASE=" & DatabaseName & ";" & _
    "UID=" & UID & ";" & _
    "PWD=" & pwd & ";" & _
    "Table=DBO." & sLocalName & ";Option=3;"

About Me

  • About flscotty1
    Biography
    Married over 30 years with 4 kids and a growing number of grandkids. Self-taught access database designer.
    Location
    Michigan
    Interests
    Writing, directing and acting. Running, Cycling, Basketball, Soccer, Softball
    Occupation
    Self Employed - Insurance Support Products

Statistics

Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 09-09-2015 10:14 AM
  • Join Date: 10-20-2014
  • Referrals: 0



All times are GMT -8. The time now is 07:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World