convert access 97 to 2002, security and compile problem

[Guest]

Hi

I would like to convert two database files (in Access 97) to Access 2002. The first file includes the data. The second file includes the data entry interfaces. The second file is linked to the tables in the first file. The two files are both secured and on the same computer and we use the same System.mdw for them. Recently, I tried to move the two files to a new computer and tried to convert them into Access 2002. Here are the problems I encountered

1. securit
The creator of the two files no longer works here and we do not have the password for the Admin account, but I have an account which belongs to the Admins group and I can open the two database files, see all the objects and designs with my login name and password on the old computer without any problem
I copied the two files to our new computer, and tried to open them. At first, I didn't use the old System.mdw. It was strange that the first database file appeared to be insecured. I opened it without seeing the logon dialog. I also tried to open it on some other computers and it was the same case. I guessed that was because the user Admin has a blank password, but I was wrong. After I joined in the workgroup of the old System.mdw, I tried to login by using the username Admin and the blank password, but I couldn't log in. Then why I could open the first database file without the original System.mdw and the login procedure? It is even strange that it is not the same case with the second database file. When I tried to open the second database file, after I logged in, there popped out the message
“The current user account doesn’t have permission to convert or enable this database….â€
I thought that I belong to the Admins group and I should have all the permissions. But it appeared that I was wrong. Could anyone tell me what permissions I don’t have and is there anything I can do to have those permissions

2. compil
Anyway, I tried to solve the permission problem by creating a new database on the old computer. I imported all the tables, queries, forms, modules, reports, macros. And then I copied the new database file to the new computer. This time I could convert it. However, there was some compile errors. I had forgot to compile the database file before I copied it. I then tried to compile the old database file in Access 97 on the old computer. But I still got compile error that read like this
“Compile error: Only comments may appear after End Sub, End Function, or End Propertyâ€. The code that caused the trouble was a declaration lin
“Dim varGotoI11, varGotoI29, varGotoI30 As Booleanâ€, which was written between two subs in Form_XXX: Class Module. I don’t know much about Visual Basic but my guess is this is the declaration of variables that are used in several Subs. It appears OK to me. In addition, I didn’t see these codes in the Objects – Modules. My question is: are these visual basic codes generated by Access automatically or written by the file creator? If they are automatically generated, why they have compile errors? If they are generated by the file creator, where are all the visual basic codes located? I need to go through them and debug, right? Additional information: The user of the data entry files never reported any problem; the database may have been converted from Access 95 to Access 97

Thanks for your help

xy

 

[david epsom dot com dot au]

was strange that the first database file appeared to be insecured. I
opened it without seeing the logon dialog. I

1) This is not strange, this is the way WorkGroup security works
when it is not properly configured.
Access workgroup security is very difficult to explain properly.
You need to read the security FAQ several times, and follow the
steps mechanically.
http://support.microsoft.com/support/access/content/secfaq.asp


2. compile

“Dim varGotoI11, varGotoI29, varGotoI30 As Boolean”, which was written

between two subs in Form_XXX: Class Module. I don’t know much about Visual
Basic but my guess is this is the declaration of variables that are used in
several Subs. It appears OK to me.

It's sort of OK. You can't use those variables, you can't compile
with code like that, and you can't make an MDE like that,
and uncompiled code runs slower. But it doesn't prevent your
code from running. Also, the declaration looks like it was broken
anyway: the author probably wanted three Boolean variables, but
he has declared one Boolean and two Variants.

Since the variables are not used (they can't be), delete the declaration.

(david)

Hi.

I would like to convert two database files (in Access 97) to Access 2002.

The first file includes the data. The second file includes the data entry
interfaces. The second file is linked to the tables in the first file. The
two files are both secured and on the same computer and we use the same
System.mdw for them. Recently, I tried to move the two files to a new
computer and tried to convert them into Access 2002. Here are the problems
I encountered:

1. security
The creator of the two files no longer works here and we do not have the

password for the Admin account, but I have an account which belongs to the
Admins group and I can open the two database files, see all the objects and
designs with my login name and password on the old computer without any
problem.

I copied the two files to our new computer, and tried to open them. At

first, I didn't use the old System.mdw. It was strange that the first
database file appeared to be insecured. I opened it without seeing the
logon dialog. I also tried to open it on some other computers and it was
the same case. I guessed that was because the user Admin has a blank
password, but I was wrong. After I joined in the workgroup of the old
System.mdw, I tried to login by using the username Admin and the blank
password, but I couldn't log in. Then why I could open the first database
file without the original System.mdw and the login procedure? It is even
strange that it is not the same case with the second database file. When I
tried to open the second database file, after I logged in, there popped out
the message:

“The current user account doesn’t have permission to convert or enable this database….”
I thought that I belong to the Admins group and I should have all the

permissions. But it appeared that I was wrong. Could anyone tell me what
permissions I don’t have and is there anything I can do to have those
permissions?

2. compile
Anyway, I tried to solve the permission problem by creating a new database

on the old computer. I imported all the tables, queries, forms, modules,
reports, macros. And then I copied the new database file to the new
computer. This time I could convert it. However, there was some compile
errors. I had forgot to compile the database file before I copied it. I
then tried to compile the old database file in Access 97 on the old
computer. But I still got compile error that read like this:

“Compile error: Only comments may appear after End Sub, End Function, or

End Property”. The code that caused the trouble was a declaration line

“Dim varGotoI11, varGotoI29, varGotoI30 As Boolean”, which was written

between two subs in Form_XXX: Class Module. I don’t know much about Visual
Basic but my guess is this is the declaration of variables that are used in
several Subs. It appears OK to me. In addition, I didn’t see these codes
in the Objects – Modules. My question is: are these visual basic codes
generated by Access automatically or written by the file creator? If they
are automatically generated, why they have compile errors? If they are
generated by the file creator, where are all the visual basic codes located?
I need to go through them and debug, right? Additional information: The
user of the data entry files never reported any problem; the database may
have been converted from Access 95 to Access 97.