I have an MS Access 2000 database running on a Win XP Pro workstation that was pulling data from an external dBaseIII-format database using ODBC. That database has now been replaced with an MS SQLExpress database on an MS 2000 Small Business Server. I have re-established the external database links in the Access database using “Machine Data Source” SQL-ODBC links, and I can see the SQL data and run queries on it. But whenever I try to run an Access Visual Basic module from within the MS Access database (either a function I’ve written or even adding a new button to a form), Access throws up on me with a “Error accessing file. Network connection may have been lost” message. This is even for functions that don’t look at the SQL data! From that point on, my Access database becomes unstable, and starts acting crazy (e.g. not letting me delete queries, or no longer displaying forms, etc), and I have to abandon it for a previous version of the Access database. Any ideas from anyone would be most appreciated on how I can write, compile, and run my much-needed VB Access functions, especially those that do look at the external SQL data.
