Programming access 2002 from 97

[Guest]

I am having more reference issues I am guessing. I have the following
statement: DoCmd.GoToControl Me![comp_id].name
fn_Autokeys ("^'")
I receive a compile error message: Sub or function not defined
for:"fn_Autokeys("^'")"
The references I have selected are as followed: Visual Basic for
Applications, Microsoft Access 10.0 Object library, OLE Automation and
Microsoft DAO 3.6 Object library. I am also getting a compile error where the
previous code word is "replace". I am working on that issue now too. Any
feedback is greatly appreciated.

 

[Douglas J. Steele]

You can't program Access 2002 from Access 97.

Access 97 cannot work with any other version of the Microsoft Access Object
Library than 8.0.

 

[Guest]

That I realize. But the conversion was done from 97 into a 2000 version than
upgrade into 2002. The refrences selected were listed on the tech site, of
course I cannot locate the article number. But I am impressed that you are
the guy who responded. I need a little more detail. Are the refrences I
listed conflicting with my 2002 version or is it the language that is the
conflict becuase it is related to the 97 version. I could really use some
insight and from what I have heard you are the go to guy. Thanks Doug.

 

[Douglas J. Steele]

You're going to have to post a little more details.

If you're actually trying to get this code to run under Access 97, I think
you're out of luck.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

That I realize. But the conversion was done from 97 into a 2000 version
than
upgrade into 2002. The refrences selected were listed on the tech site, of
course I cannot locate the article number. But I am impressed that you are
the guy who responded. I need a little more detail. Are the refrences I
listed conflicting with my 2002 version or is it the language that is the
conflict becuase it is related to the 97 version. I could really use some
insight and from what I have heard you are the go to guy. Thanks Doug.

I am having more reference issues I am guessing. I have the following
statement: DoCmd.GoToControl Me![comp_id].name
fn_Autokeys ("^'")
I receive a compile error message: Sub or function not defined
for:"fn_Autokeys("^'")"
The references I have selected are as followed: Visual Basic for
Applications, Microsoft Access 10.0 Object library, OLE Automation and
Microsoft DAO 3.6 Object library. I am also getting a compile error where
the
previous code word is "replace". I am working on that issue now too. Any
feedback is greatly appreciated.

 

[Guest]

I have a new question. Security was recently placed on a database I created
and now I no longer have permissions to change a darn thing. How can I break
the code? I was told to search for:.MDB Security removal*. I located 1
article but can no longer find it. Any ideas or tools you can give me to
assist? In the mean time we are waiting on Visual Source Safe to maintain the
security and update changes as needed. Thanks.

 

[Tim Ferguson]

I have a new question. Security was recently placed on a database I
created and now I no longer have permissions to change a darn thing.
How can I break the code? I was told to search for:.MDB Security
removal*. I located 1 article but can no longer find it.

1) if the security was deliberate, you need to approach the new
administrator/ owner and get yourself added to an appropriate group with
r/w/d permissions on everything.

2) If it was accidental (these things to happen) then you will have to go
back to an intact backup that is not linked to a workgroup file. You did
keep one didn't you..?

There are apparently tools available for hacking Access User Level security
-- try googling for "Hack Access Security" or something.

Hope that helps


Tim F

 

[Guest]

Actually it was done by my boss. But I was brought into fix it. I will see
what I can find out. Thanks for the feedback. And yes i kept and unsecured
copy ;0)