Access 2K & Visual Studio

[Databaseguy]

Hey all. Haven't been around for a while.

Anyway.

If you have Visual Studio and Access 2K installed on the same machine, be sure to complile your code routinely. This is especiialy important immediately after you copy code, or any form or other object that has code.

If you fail to do so, Access will give you an error message " Network connection could not be found" and your database will be rendered useless. The only fix I have found once the DB reaches this state is to enter in to all of the modules, copy the code (not the module) and paste it into a new DB. Simply copying all of the objects into a new DB does not suffice, as the error propegates.

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[krsherm]

This is a known bug in A2K... searh the MSKB for specifics. It has to do with copying a form and not compiling your database before you save. Are you copying forms and then saving before you compile? This has bit me a couple of times.