viewing database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi. i am creating a database of old exam questions with solutions. there
are alot of questions and for each question there are 4 choices. the user
can pick one of the answers and my database will then display the correct
choice. i am designing it now but i also want to be able to see if the
features i have implemented are actually working. is there any way to run
the database so i can see if it is working as planned? i hope this makes
sense cuz it kinda hard to explain. please reply to this post if you are not
sure of what i am saying.

thanks.
 
hi. i am creating a database of old exam questions with solutions. there
are alot of questions and for each question there are 4 choices. the user
can pick one of the answers and my database will then display the correct
choice. i am designing it now but i also want to be able to see if the
features i have implemented are actually working. is there any way to run
the database so i can see if it is working as planned? i hope this makes
sense cuz it kinda hard to explain. please reply to this post if you are not
sure of what i am saying.

thanks.
Click to expand...

No, I'm not at all sure what you're saying!

If you can design the database, you can open the database. And if you
can't open the database (you don't "run" a database, it's not an
executable program), then your users won't be able to do so either.

Please explain what your database contains: tables, obviously, but
what else? a Form? Some VBA code to control what the user sees?

John W. Vinson[MVP]
 
You should be able to run your DB with test data. Test you
'features'with the test data, or, is there something you are no
telling us
 
thanks for your reply John.

basically here is the problem. i am designing a program but the actual
programming is being done by someone else who is no longer associated with
the project so now i am stuck with his work and i am trying to make sense of
it. he put a timer in the program so that the program expires after a
certain time. now that the program has expired i can't use it so i am trying
to reset the date so i can use it again. why the programmer did this is
beyond me!!! it was never supposed to be a part of the design!!

i was looking through the database and i found out where the expiration date
is stored. the problem is that there is no save feature enabled. the
database is in access 97 and i am using access 2002. once i can save the
database with the new date then i should be able to use the program again.
how come the save is not working? how can i save the database with the new
expiration date?

i hope this clarifies the situation more.

thanks again.
 
thanks for your reply John.

basically here is the problem. i am designing a program
Click to expand...

What kind of program? Visual Basic? C#? An Access database
application? a "program" in a business sense, rather than a computer
program?
but the actual
programming is being done by someone else who is no longer associated with
the project so now i am stuck with his work and i am trying to make sense of
it. he put a timer in the program so that the program expires after a
certain time. now that the program has expired i can't use it so i am trying
to reset the date so i can use it again. why the programmer did this is
beyond me!!! it was never supposed to be a part of the design!!
Click to expand...

You'll have to ask the programmer.
i was looking through the database and i found out where the expiration date
is stored. the problem is that there is no save feature enabled. the
database is in access 97 and i am using access 2002. once i can save the
database with the new date then i should be able to use the program again.
how come the save is not working? how can i save the database with the new
expiration date?
Click to expand...

Depending on how clever the programmer was, it may be very, very
difficult to unlock this. It sounds like s/he did it this way
specifically to prevent others from using the database without
permission.

Two quick things to try (which probably won't work, depending on how
much work the programmer did):

1 - Hold down the SHIFT key to bypass the automatic start code. If
they went to the trouble to put in a kill-timer, this probably won't
work.

2 - If it doesn't, create a new, empty Access database, and copy and
paste the following code into a new Module:

Public Sub ClearLockout()
Dim db As DAO.Database
Dim wk As DAO.Workspace
Dim prp As DAO.Property
Dim strDB As String
strDB = InputBox("Enter full path name to database")
Set wk = DBEngine(0)
Set db = wk.OpenDatabase(strDB)
On Error Resume Next
db.Properties("AllowBypassKey") = True
Debug.Print Err.Number
End Sub

Select Debug... Compile <your database>; save the module (under some
name other than ClearLockout, maybe basUtilities). In the Immediate
window type

ClearLockout

and enter the path and filename of the mdb file in response to the
prompt. Then go back to step 1.

3 - If that doesn't work either, you'll probably need to persuade the
developer to unlock it for you, or hire professional help... or
rebuild the app.


John W. Vinson[MVP]
 
Back
Top