By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,708 Members | 1,687 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,708 IT Pros & Developers. It's quick & easy.

Saving MS Access Dbase to CD & Verifying it Works !

P: n/a
I have a question about saving an MS Access program to CD and verifyng
that the program works after being saved.

Here is my situation, I have a person who developed an application for
me using MS Access 2003 and the person will be transferring ownership
to me. The developer will be giving me a CD with Access DBase source
code on it. How do I verify that he gives me everthing I need to run
the application once the developer departs. Are there certain files I
should look for ? Is there a simple way to make sure i get the
complete working app the person created ? How do I ensure I have the
root password to the MS Access application and Dbase ?
The MS Access Dbase is a front end, used for report generation.
Currently the DBase is password protected
The MS Access app, pulls data to fill its tables from a SQL database and then MS Access is used to generate reports

I would truly appreciate any help you can give me. I do not want to
get stuck out there without the complete application I have paid for.

Sep 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<ch**************@yahoo.comschreef in bericht news:11**********************@m73g2000cwd.googlegr oups.com...
>I have a question about saving an MS Access program to CD and verifyng
that the program works after being saved.

Here is my situation, I have a person who developed an application for
me using MS Access 2003 and the person will be transferring ownership
to me. The developer will be giving me a CD with Access DBase source
code on it. How do I verify that he gives me everthing I need to run
the application once the developer departs. Are there certain files I
should look for ? Is there a simple way to make sure i get the
complete working app the person created ? How do I ensure I have the
root password to the MS Access application and Dbase ?
>The MS Access Dbase is a front end, used for report generation.
Currently the DBase is password protected
The MS Access app, pulls data to fill its tables from a SQL database and then MS Access is used to generate reports

I would truly appreciate any help you can give me. I do not want to
get stuck out there without the complete application I have paid for.
First: You can not run the app from the CD. The mdb on the CD will only be your backup...

You mainly have to know for sure that you get the access mdb-file (NOT an mde!)
Some apps may need additional files other apps not...
I guess in your case of a report-generator front end, no other files are used.

The mdb-file contains *everything* including sourcecode.

If the only protection is a database password, than you only need to know the password.
If the database is a secured one with user level security (ULS) applied, than you also need the workgroup-information-file (WIF) and admin-login info
If ULS is the case (which I don't think reading your post) you must be able to change and/or recreate the security.
You need not only the file (WIF), but also the exact information that was filled in when the file was created.
(But neither a database password nor ULS is *real* protection...)

So:
Install the mdb which is on the CD (just copy the file)
Start the app, hit F11, look if you can get in the design of any form or module.
If so, you have the mdb which is *everything*.
If not you might have an mde (renamed as mdb)
If you get a message about 'not enough rights' than ULS is applied.

In any case you could ask the developer to explain and document the 'code-secrets' ...
If the app is more or less complex and or critical for your organisation than you might need full documentation...

Arno R


Sep 8 '06 #2

P: n/a
<ch**************@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
>

I would truly appreciate any help you can give me. I do not want to
get stuck out there without the complete application I have paid for.
In addition to Arno's response, test your application thoroughly for
run-time errors. It is possible to store code in a library mde file which,
if you don't have (access to) it will cause your app to fail. It isn't a
likely scenario but just something to bear in mind.

Keith.
www.keithwilby.com
Sep 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.