Windows 10 
Access 2016
Greetings,
A friend of mine brought me an old Access database (prog.mdb), I do not know the Access version, I believe it is Access 2000, but I am not sure. He asked me to do some minor modifications. Unfortunately, I could not open Forms, or Reports, or Modules in Design Mode. I do not see the Design Mode option when I right click on the objects.
However, I can view Tables, and Queries in Design Mode. It is only the Forms, Reports, and Modules that I am having problem with.
FYI, I open the database (prog.mdb) while pressing the Shift Key. I tried to play around with user permissions, and I see that the Admin account has all the privileges, including viewing Forms in Design Mode. I login as Admin, but still can not view Forms in design Mode. I tried to export forms to a new database, but I receive this message “You can't import, export, create, modify, or rename andy forms, reports, pages or modules in an ACCDE, MDE, or ADE database.”. When I export a table, no errors occur, and the table is exported successfully to a new database. Only Forms and Reports would not export to the new database.
I have done lots of research in the net, but unfortunately, I could not solve the problem. I must access the forms in Design Mode to do the modifications required. Any help would be appreciated.
Many thanks.
Reply With Quote
