Search results

  1. A

    Question How to connect to SQL database file

    The steps are outlined here: http://office.microsoft.com/en-us/access/HA102004941033.aspx The above is for 2007, but just go file->get external data, and the steps are then the same as above outlined if you using a previous version. Albert D. Kallal Edmonton, Alberta Canada kallal@msn.com
  2. A

    Question How to connect to SQL database file

    Well, you have to setup and install sql server. the process is then VERY much like running a split data base. the up-sizing wizard built into ms-access will move up your data to sql server. HOW TO: Convert an Access Database to SQL Server (a97,a2000)...
  3. A

    Question How to connect to SQL database file

    You face two major problems: The fact that you split or do not split does not change if this will work. The problem is when you don’t split you wind up with a very unreliable application. If your application is so unreliable your users will not like you anymore, and they lose complete faith in...
  4. A

    Question How to connect to SQL database file

    Well in theory it does. But this will only work if the users around the world can see and view the folder with that back end mdb data file resides. So if I want a use the word file on your computer, or PowerPoint file, or in this case a standard mdb file, Then I’ll have to have access and be...
  5. A

    Question How to connect to SQL database file

    No, when you use sql server, you are not linking to a file. You NEVER even a specify a file location when using sql server. You are linking to a server box. In fact, this means that you can use an IP address and even link to a server over the internet. Thus, when you use sql server, ms-access...
Back
Top Bottom