If you want to keep this import in a macro, have you tried to include your import specification name in the "Specification Name" option for the TransferText action? I remember years back having an import macro for which I was able to incorporate my import specification into the macro, it's just...
I ran into the same problem a while back setting up security for a database that would be used over the network.
My advice: don't use the user-level security wizard. Set up the security manually. I'm attaching the URL for a document that explains how and why...
Access 2007 employs a new file format/extension, .ACCDB or .ACCDE. This new file format does NOT use user-level security. If you want to open your older Access databases with Access 2007 and still have user-level security, make sure you keep it in a .mdb format. Otherwise, your .mdw files...
I verified that user Admin has a password, group Users has no permissions, user Admin has been removed from group Admins. Still had the problem, however I was able to implement user-level security successfully with a new test database created in an attempt to figure out my problem. I may have...
subs1678, let's step back for a moment. Are the folks using this database now happy with the results it's producing for them? Are there specific problems you've uncovered that need to be addressed? Your question is kind of wide-open at this point, we could give you hundreds of suggestions...
Joe, thanks for your response.
I removed rights from the Users group, and I removed Admin from the Admins group. Access will not let me remove Admin from the Users group, it says everyone must be a member of the users group. When I try joining a different workgroup file, I do it using the...
I'm preparing to distribute a secured Access DB via our company's network. I have set up user-level security using the security wizard, removed user "admin" from the Admins group, established the user "Administrator" as the new administrator, and set object permissions for my different groups...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.