I have created this spiffy db in Access 97 and must now move it into Access 2000. When I try to import it, I get an error message that says I do not have privileges to import, link, or do anything else to the tables. I created the db! Why can't I import it?
1997 vs 2000 Security
- Thread starter slrphd
- Start date
- Local time
- Today, 05:34
- Joined
- Feb 28, 2001
- Messages
- 30,567
You probably need to go back in through AC97, use Tools >> Security >> Permissions to make the objects in the table public. Oh, another "gotcha" - did you remember to convert the workgroup file while you were at it? That might do it all by itself. The workgroup file can be converted just like an Access database.
RE: Security 97 to 2K
Thanks for both comments. I change permissions on the old database and that helped some but I clearly have additional problems outside the security realm that I need to resolve in order to proceed. With regard to the Security FAQ, I had previously worked through Jack MacDonald's write-up on security and found it to be helpful and instructive. Since his opinion of the security FAQ seemed to be less than sanguine, I had not done much with but I shall. I am guilty of allowing one person's opinion have too much sway. Thanks, again.
Thanks for both comments. I change permissions on the old database and that helped some but I clearly have additional problems outside the security realm that I need to resolve in order to proceed. With regard to the Security FAQ, I had previously worked through Jack MacDonald's write-up on security and found it to be helpful and instructive. Since his opinion of the security FAQ seemed to be less than sanguine, I had not done much with but I shall. I am guilty of allowing one person's opinion have too much sway. Thanks, again.
