[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1838
  • Last Modified:

Using a 2003 mdw file in Access 2007

I have changed a mdw file from an Access 2003 database, I emailed the changed mdw file down to the client and they want to use this file, previously we went to Tools, Security, Join Workgroup but their is no facility for doing this, please can anyone tell me how this works in 2007
0
AnnetteDavid
Asked:
AnnetteDavid
  • 2
  • 2
  • 2
  • +1
1 Solution
 
Gustav BrockCIOCommented:
The previous Access security has simply been removed in A2007.
Too bad. No solution I know of.

/gustav
0
 
Gustav BrockCIOCommented:
0
 
wiswalldCommented:
Welcome to the world of Access 2007 and all the bugs people keep finding
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
This link may help:

http://support.microsoft.com/kb/918583  'Workgroup Administrator utility in Access 2007

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Also see:

http://msdn2.microsoft.com/en-us/library/bb421308.aspx   'Security considerations

And you will need these also (updated often):

Bug lists for A2007 - a good reference in general:

http://allenbrowne.com/Access2007.html#Bugs   'A2007 bug list

http://accessjunkie.com/kb.aspx

http://support.microsoft.com/ph/11265

mx
0
 
AnnetteDavidAuthor Commented:
Thanks folks so much for your comments above, I have been away, back now and will read the articles you have mentioned and then comment again.  So dissapointed that there isnt an easy way out of this but appreciate your comments
0
 
AnnetteDavidAuthor Commented:
Hi DatabaseMX, many thanks for your comments and the links.  I have found the answer in your link 'Workgroup Administrator utility in Access 2007 - many thanks, I created and ran a RunCommand Macro and it worked perfectly.  I will have to learn all about the new security measures in 2007 but this at least got me over the hurdle with a client.  Thank you again
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now