SQL Tables not Refreshing

[denileigh]

I have an Access 2010 Front End with SQL Express (I think) backend. I've recently updated the front end of the database.

For some reason now I get this error on a query and in a form, "OBDC-connection to SQL ServerSERVER\SQLEXPRESS' failed.

When I refresh the tables - everything works but I have to refresh them nonstop. Will it not do it by istelf.

BTW - I'm totally new to the SQL thing so I don't always totally understand right off the bat.

Thanks in advance for your help.

 

[WayneRyan]

denileigh,

All of my examples are at work, but this should help:

http://www.codeproject.com/Tips/646080/Migrating-ACCESS-Jet-data-to-SQL-Server

Wayne