Change Access db File Ext.?[RESOLVED]

[Nintendo_Wizard]

I am currently using an Access db for an application. How do I change the file ext. to something else so it can't be opened outside the app? If I change it will I have to reconfigure the OledbDataAdapter, Dataset, & OledbDataConnection? Thanks

[hellswraith]

Why don't you just set a password on it. That way if someone trys to open it, they would need the password. Your app can contain the password and connect with no problems. This would be a little more secure than just changing the file extension.

But, if you really want to change the file extension, you should probably on load, change the extension to .mdb and when your app ends, change it back to something else. This way your db code won't be affected. The database will be a .mdb file while the app is running, but be changed to something else when the app isn't running.

[Pirate]

you can use any ext. with Access DB .Before you change the ext. build the inner structure (tables - Columns),leave it empty, and then you can have ext. changed.When you want to access you DB , no need to change the ext. back to .mdb .

[Nintendo_Wizard]

WORKS GREAT! THANKS!