November 4, 2021 at 4:36 pm
Upgraded from an Access 2010 ADP database, linked my tables, but I can't connect to the server when the main module is loaded. Can't figure out the change in the code.
November 4, 2021 at 4:56 pm
Upgraded from an Access 2010 ADP database, linked my tables, but I can't connect to the server when the main module is loaded. Can't figure out the change in the code.
Unless all you're looking for is sympathy, you'll need to provide more information than this. Existing code, error messages, etc.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 4, 2021 at 5:16 pm
Is there an actual error you are receiving? There's not enough information here.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 7:56 pm
Upgraded to Access 2016 (Not 365) connected to SQL Server 2019. I am able to link my tables, but when attempting to to open a Form, i receive an OBDC Call error. then I am prompted for the DSN. I select the same DSN I used to link the tables, but it's not accepted.
November 4, 2021 at 8:02 pm
The actual error would be much better. WHAT ODBC error? What SPECIFICALLY did it say?
How about a screen shot???
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 9:26 pm
That's all it says, OBDC Call error. there is no error number, nothing. It has to be my connection string, obviously not correct.
November 4, 2021 at 9:37 pm
That's all it says, OBDC Call error. there is no error number, nothing. It has to be my connection string, obviously not correct.
Is the version of Access 32, or 64 bit? You probably need the 64 bit version
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 4, 2021 at 9:57 pm
I am running ACCESS 32 bit and SQL Server 64 bit
November 4, 2021 at 10:36 pm
I am running ACCESS 32 bit and SQL Server 64 bit
That's your issue. It will not work
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply