Go Back   Access World Forums > Apps and Windows > Other Software

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-10-2019, 03:03 PM   #16
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Connecting Access Database with other software

Thank you all for the advises - we are slowly coming to the end.

Vendor told me that I should refer to the ODBC which is already configured.
They advised me to follow this instruction:

support.office.com/en-us/article/import-or-link-to-data-in-an-sql-server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e

For time being I got stuck at the point 2. Create DNS file, because on the available DNS drivers list, ODBC Driver 13 for SQL Server doesn't exist. Do you have any clue why?

Should I ask vendor for an additional information?

Thank you in advance.

Blancorn is offline   Reply With Quote
Old 06-10-2019, 04:26 PM   #17
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,607
Thanks: 89
Thanked 1,492 Times in 1,408 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Connecting Access Database with other software

Quote:
Originally Posted by Blancorn View Post
For time being I got stuck at the point 2. Create DNS file, because on the available DNS drivers list, ODBC Driver 13 for SQL Server doesn't exist. Do you have any clue why?
Because it is not installed on your PC. You should be able to get it from Microsoft.
Galaxiom is offline   Reply With Quote
Old 06-24-2019, 04:03 AM   #18
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Connecting Access Database with other software

Thank you all for the support.
We are very close to the happy end.

I have DSN file and can see table list from desired database.

Unfortunatelly when I choose tables to be imported/connected I get another error:
"Reserved error (-7748); there is no message for this error"

Do you have any clue how to manage this?

Blancorn is offline   Reply With Quote
Old 06-25-2019, 01:46 PM   #19
dynamictiger
Newly Registered User
 
Join Date: Feb 2002
Location: Perth
Posts: 261
Thanks: 11
Thanked 1 Time in 1 Post
dynamictiger
Re: Connecting Access Database with other software

May helphttp://www.accessrepairnrecovery.com...reserved-error
__________________
Perth, the most isolated capital in the world
dynamictiger is offline   Reply With Quote
The Following User Says Thank You to dynamictiger For This Useful Post:
Blancorn (07-21-2019)
Old 07-07-2019, 02:10 PM   #20
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Connecting Access Database with other software

Thank you for this link.
I was trying to apply the fix described there:

Quote:
Fixes For “Reserved Error -7748” in MS Access 2003, 2007, and 2010
You must keep a proper backup of the registry before making any changes.

In order to resolve this error, set WorkArounds2=8192 for the affected data source. This can be done by using the Registry Editor (RegEdit).

1. Run RegEdit

2. Search the ODBC DSN in the Registry:

For a USER Data Source, go to HKEY_CURRENT_USER -> Software -> ODBC -> ODBC.INI -> YourDataSourceName

For a SYSTEM Data Source, go to HKEY_LOCAL_MACHINE -> Software -> ODBC -> ODBC.INI -> YourDataSourceName

For 32-bit applications (ODBC drivers) on 64-bit Windows, (MACHINE) Data Source, go to

HKEY_LOCAL_MACHINE -> Software -> Wow6432Node -> ODBC -> ODBC.INI -> YourDataSourceName

3. tap to the folder for your data source, from the menu select:

Edit -> New -> String Value

4. Assigned name to the new string value to be WorkArounds2

5. Make a double tap on the WorkArounds2 in the right hand panel as this will opens up a dialog box with the data value field.

6. Change the data value to 8192 (The string value that must be added to Windows XP SP2 and Progress 10.1A02 is WorkArounds2=40960)

7. Click OK

8. Close RegEdit

If you are using Windows 95 and 98 then you need to reboot, then only the change done in settings will get into effect.
Unfortunatelly I cannot find my DSN file in the registry (see screen attached).


Do you know what should I do, to see my DNS there?
Attached Images
File Type: jpg Rejestr.jpg (97.7 KB, 13 views)
Blancorn is offline   Reply With Quote
Old 07-21-2019, 10:15 AM   #21
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Connecting Access Database with other software

Quote:
Originally Posted by dynamictiger View Post
Finally I was able to apply this fix. Thank you!

Blancorn 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
Creating stand alone software from access database? crododo General 3 05-03-2013 06:57 PM
Question Who owns Access database if part of software? fatfreddy General 1 06-21-2011 12:03 PM
Connecting with a back end access database dvdw Modules & VBA 4 04-15-2009 07:24 AM
Connecting Outlook's contacts to Access database ekta Forms 10 10-30-2003 08:33 AM
Connecting to another access database. peters Forms 1 06-27-2001 01:00 AM




All times are GMT -8. The time now is 06:10 AM.


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