RE: [MS_AccessPros] SQL backend moved, the forms are still looking for the old server

 

Hi Marybeth

 

It would help us a bit if you can give us the version of Access, the version of SQL Server, and which ODBC driver you are using. Lots of different combinations can cause different headaches.

 

Regards,

Bill Mosca

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, February 21, 2019 11:20 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] SQL backend moved, the forms are still looking for the old server

 

 

Afternoon wise ones,

 

Two weeks ago, the PTB decided to move  to another more updated SQL server.  Since my front end is in access and the SQL database team doesn’t know about it to help, it took a lot of digging and finally get the connections for the tables to work.  Today, I opened one of my most used forms and it keeps triggering a SQL connection error message.  I don’t understand why the frontend should be looking at the server since the table link is correct.  Do you all have any advice?  I can get to the form with the data showing but it takes repeated canceling the server error messages and then Access will hang.  Please help

 

Marybeth

 

__._,_.___

---

Posted by: "Bill Mosca" <wrmosca@comcast.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___