I've got a problem with trying to import objects into a certain Access Database. Whenever I try to import a report, form or a module I get the error "Record(s) can't be read; no read permission on 'MSysModules' ", I click ok to this and another error comes up "Object Invalid or no longer set", I click OK to this one and I get an application error telling me that certain memory could not be 'read', and advising me to click OK to terminate the application or cancel to debug the application! Here I click Cancel (why not, hey?!?) and visual C++ opens with an error that says: "Unhandled Exception in MSAccess.exe (VBA332.dll); 0xC0000005:Access Violation".
I click ok here and it lets me debug access (?). As i don't know C++, this isn't much good to me.
All I want to do is import a report!!
Anyway, a little background: I'm running NT SP4, the database I'm trying to import to is on an NT server and the database I'm trying to import from is on my PC. I have full access to the database I'm trying to import to (in fact, I'm the owner of the database). I've tried doing this on other NT machines and a WIN95 machine all with the same result. I can create objects of any kind in the database, I can edit whatever I want, but I just can't import.
Now, as far as i know MSysModules is a system table that seems to store details of all the modules in the database. To start with I thought that there was some buggy problem with access securities or something, but it's not even using a security file!
To start with I couldn't open MSysModules directly, so I went into the User & Group Permissions section and gave every group & user administration access to everything.
This seemed to alow me to open the table, but it didn't fix the problem.
Can anyone help???
thanks in advance,