X
xyy
Hi,
I posted them in late afternoon yesterday and got some helpful suggestions from David. Thanks David. I repost it, hoping to get more answers.
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
I posted them in late afternoon yesterday and got some helpful suggestions from David. Thanks David. I repost it, hoping to get more answers.
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