Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 17th, 2003, 11:37 AM
Registered User
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving Access 2000 database server

I am moving an Access 2000 database to a new server (from NT4 to XP), and am having problems getting the security to move over. I'm obviously missing a step. I've copied my .mdw file to the new server, and joined that workgroup with Workgroup Administrator. I then copied some of the original databases that are secured by this .mdw file on my original server. When I open one of those databases, I get no login prompt, and there are no users or groups. Help!
Old June 21st, 2003, 09:58 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

What you might want to do is open up Access with the workgroup actually specified - this is also handy for when you have multiple workgroup files - and if you have different versions of Access (eg both 97 and XP), it often reverts back to the standard mdw.

So - you should open access using the /wrkgrp switch - for example:
"C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" /WrkGrp "\\server\share\workgroupfile.mdw"
There are 10 kinds of people in the world - those who understand binary - and those with friends

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Backup database - SQL Server 2000 cancer10 SQL Language 2 March 1st, 2007 07:21 AM
Access to SQL Server 2000 jgferguson Access 3 December 1st, 2006 12:52 PM
Moving the database to another Server x_ray SQL Server 2000 10 February 4th, 2006 07:21 AM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM
Connecting to an Access 2000 database Jonny .NET Web Services 0 November 10th, 2003 03:13 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.