MS Access Crashing out when accessing MSSQL and MDB linked tables

[ShaneBrennan]

Hi Everyone

This is a really wiered problem I've having and I can not figure out why the problem is occuring.

basically, I have a front end DB with links to backend MDBs and a MSSQL server - works great as long as the form I am looking at only contains tables from the MDB or tables from the MSSQL server. If I try to display info from both MSSQL and MDB together - MSAccess Crashed spectacularly and wants to repair itself!

On my development PC - it works fine - no problems

On the live PC - that is where I get the errors.


My Configuration:
-----------------
MSAccess 2002
MSSQL Server: MSSQL sqlExpress 9.0.3054
ODBC: using MS SQL Native Client - 09.00.3042

On Live PC
----------
MSAccess: 2003
MSSQL Server: MSSQL 2000 Server
ODBC: SQL Server 2000.85.1128.00


Has anyone seen a similar problem?

Thank you in advance for any help given


Shane Brennan

 

[ca8msm]

Try forum702 or forum701


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[ShaneBrennan]

Thank you ca8msm I'll give them a try

Shane Brennan