General Concept question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,

Hypothetically...

If someone does development offline on another computer and then copy the
front-end that was developped back onto the network...should it work OR does
the *.mdw file need to be copied over as well?

I am asking because I did development work and for some unknown reason my
users, non-admin, recieve an error 3033 going on about the Msys... tbl....
And I have never played with any system tables!

Thank you,

Daniel
 
If you are making changes to the design of objects, including changing
permissions, then all of that is stored in the mdb file, so only it needs to
be copied.

If, however, you are making changes that affect the mdw like,
adding/deleting users, adding/deleting groups, changing the groups that
users are members of, changing passwords, then all of that is stored in the
mdw and you need to copy the mdw as well. It is best to make these changes
in the 'live' mdw though, or you'll overwrite existing passwords.

As for error 3033 see http://www.jmwild.com/MSysTables.htm
 
Joan,

1. I created a Report which dynamically changes a qrydef. It work fine for
me as the admin but not for any other group?

Your website does not mention issue with access 2000, are there none?



2. I am working on/with Access 2003, however the database is running on
office 2000, is this an issue? Should I be concerned?

Thank you,

Daniel
 
Daniel said:
Joan,

1. I created a Report which dynamically changes a qrydef. It work
fine for me as the admin but not for any other group?
Click to expand...

Users need modify design permission on that query.
Your website does not mention issue with access 2000, are there none?
Click to expand...

I'll change the website. The issue mentioned about 97 applies to all
versions.
2. I am working on/with Access 2003, however the database is running
on office 2000, is this an issue? Should I be concerned?
Click to expand...

I don't think you'll have a problem.
 
Back
Top