CompactDatabase under Vista

I'm also having a problem with Vista, VB6 and database creation.

I've been creating an Access db in the app directory. Works fine in all OS's except Vista. The message is: "database already exists." A check of the app directory shows no db.

Where is it created under Vista. More important, how can I change my code so that it works with Vista and is backwards compatible?

Post split to new thread.


Where is your app.path?

Wouldn't we need to see your code to determine that?

Yes, posting the relevant code is good too but the location is the main issue here as it may not be in a location where the user has write permissions to.