Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-12-2018, 12:28 AM   #1
FuzMic
DataBase Tinker
 
FuzMic's Avatar
 
Join Date: Sep 2006
Location: Far East
Posts: 638
Thanks: 2
Thanked 2 Times in 2 Posts
FuzMic is on a distinguished road
Up sizing study

Hi members

I had avoided moving away from Access02/03; I was just comfortably enjoying the .mdb even avoided using .accdb from 07. The reason being I feel so good staying in my comfort zone; living with familiar things yet get the job done. At the back of my mind is "small is good" recognizing the eventual point of diminishing return when a system grows huge.

But now with some prompts from members who asked me why I stay on the old place, I down loaded SQL Server 2017 and try my hand on it. My last encounter with SQL Server Express was 2005. At that time I used to be able to up size a mdb to the SQL Server using its database tool. This don’t seem to work any more from A03 up to A2013. What’s happening?

I am now able to import an mdb into a SQL data base going through OLE DB Provider for SQL Server from the SQL Srv 17 Import / Export 32 bit option.

When I look into the ODBC Admin in win10 v1709 I now see 4 drivers.
  1. ODBC Driver 13 for SQL Server
  2. SQL Server
  3. SQL Server Native Client 11.0
  4. SQL Server Native Client RDA 11.0

Which ODBC driver do I use to connect a mdb to the SQL Service?
Can i use OLE DB Provider in Access & how to do it?

Can some of my experts friends enlighten me in my unfamiliar environment i just got in?

FuzMic is offline   Reply With Quote
Old 09-13-2018, 10:48 AM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,431
Thanks: 13
Thanked 1,419 Times in 1,353 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Up sizing study

I would use #1. However, keep in mind that you will need to install this driver on ALL user machines also. The default driver is #2 and is installed with Access. It works OK but does not support newer data types. The biggest problem will be dates. You must stick to DateTime and not use any other data type. If I am in control of designing the database, I stick with the old data types so I don't have to deal with distributing drivers to everyone. However, if someone else has designed the BE, they may have used things like BigInt or DateTime(2) and those will not work with driver #2 so I have to distribute driver #1.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 09-14-2018, 03:45 PM   #3
FuzMic
DataBase Tinker
 
FuzMic's Avatar
 
Join Date: Sep 2006
Location: Far East
Posts: 638
Thanks: 2
Thanked 2 Times in 2 Posts
FuzMic is on a distinguished road
Re: Up sizing study

Sir you have always gave the most valuable practical advice, THANK YOU SO MUCH.

FuzMic is offline   Reply With Quote
Old 09-14-2018, 07:22 PM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,441
Thanks: 62
Thanked 1,172 Times in 1,072 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Up sizing study

FuzMic, just for the record, Pat is a "ms.", not a "mr."
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 09-14-2018, 08:18 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,431
Thanks: 13
Thanked 1,419 Times in 1,353 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Up sizing study

You're very welcome
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 10-12-2018, 01:30 AM   #6
FuzMic
DataBase Tinker
 
FuzMic's Avatar
 
Join Date: Sep 2006
Location: Far East
Posts: 638
Thanks: 2
Thanked 2 Times in 2 Posts
FuzMic is on a distinguished road
Re: Up sizing study

Sorry Pat, thousand apologises.
FuzMic is offline   Reply With Quote
Old 10-14-2018, 07:33 PM   #7
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,431
Thanks: 13
Thanked 1,419 Times in 1,353 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Up sizing study

Not a problam


__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing - Rx_ Politics & Current Events 24 06-21-2018 03:01 PM
British are falling out of love with pubs according to new study Rx_ The Watercooler 7 08-28-2015 04:45 AM
Trying to model this case study into an ERD Bycrim Tables 4 04-22-2013 08:10 PM
Autogenerating study ID number UCLA Lorna Forms 1 09-13-2008 11:21 AM
how to create study flashcards ijtrades Forms 0 11-09-2007 02:12 AM




All times are GMT -8. The time now is 06:05 PM.


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

Sponsored Links

How to advertise

Media Kit


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