| Author |
 Topic  |
|
|
seahorse
Senior Member
USA
1075 Posts |
 Posted - 01 June 2004 : 23:24:15
|
Hi Folks,
I've put a lot of time into building the database for my web site and was wondering if it was possible to use that database as the foundation for an Access based application? If it is possible, would I be able to keep the data in that appliation from being copied or decompiled by the people who buy the app?
Any advice or suggestions would be greatly appreciated.
|
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 02 June 2004 : 00:39:34
|
| What kind of database? MSSQL or Access? If I understand correctly, you should be able to do it with either or db platform. Access works really nice with MSSQL too. As for being decompiled...couldn't tell ya. I've done some "fairly" complex things in access but never really took the time to look at that. |
Erick
Snowmobile Fanatics
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 02 June 2004 : 10:03:17
|
Yes it is possible, you can protect the database so that it can only be opened by your app by setting up a login user. When you set security on the access db it creates an mde file which contains the security inf for the database, if you then try to open it it will require a username/password to gain access.
You couldn't really do it with SQL since you couldn't distribute it easily as an application. |
|
|
|
seahorse
Senior Member
USA
1075 Posts |
Posted - 02 June 2004 : 22:14:33
|
Thanks Huw, Erick!
Hmmm...That's good to know.
So if i were to have an Access application made, I could burn it on to a CD-ROM and distribute it like any other application? Do you think that there'd be a need for creating my own software license key(s) to prevent copying, etc?
Thanks for the help.
|
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 03 June 2004 : 04:03:36
|
In essence yes, but whether it will work from CD will depend what your app does/is. As for licences/keys that's entirely up to you, for something small with a limited market it may not be worth the effort.
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 03 June 2004 : 05:23:54
|
| Just be aware though that Access passwords aren't exactly super secure, software like http://www.lostpassword.com/access.htm makes it a pretty trivial task to get the password info from the DB. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
seahorse
Senior Member
USA
1075 Posts |
Posted - 03 June 2004 : 23:27:35
|
Thanks, Gremlin. That's good to know too.
Are there any additional more secure methods of protecting the data in such an application?
Right now my DB is accessable for free via my site, so in a way if someone wanted to steal the data it's already publicly available. That said, if I did release my DB as a kind of CD-ROM desk reference and someone was able to hack it, it'd make it pretty easy to reproduce my web site...
|
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
| |
Topic |
|
Topic Locked
