Tony's Microsoft Access Blog : Windows Vista

Windows Vista: Access may stop responding when you open a remote database

Tony — Mon, 18 Aug 2008 21:38:58 GMT

Windows Vista: Access may stop responding when you open a remote database

SYMPTOMS

In Windows Vista, Microsoft Office Access may stop responding when you open a remote database that is already open on another Windows Vista-based computer.

Note This problem occurs on any flat file database. For example, this problem occurs on Foxpro database files.

Thanks to Skunk who posted this resolution in the Microsoft newsgroups.

Applications Referencing the ADOX Library Fail Under Windows Vista

Tony — Fri, 18 Jan 2008 01:19:28 GMT

Fellow Access MVP Bill Mosca noticed the following article: Applications Referencing the ADOX Library Fail Under Windows Vista.

I once tried using ADOX to reset the seed of an autonumber primary key on a table at a clients but it died on some message so I never bothered with it again. See Resetting AutoNumbers by Allen Browne. As far as I know this is the only useful thing that ADO does that DAO doesn't when it comes to Jet databases.