separating database from its mdw

[everhopefull]

That subject line probably doesn't really explain it !

I am doing some support for a database that has group level security (I can do the support and make the changes they want but I'm not so hot on the security side of it ! Anyway when I'm in the office that's fine, but when I want to work offline at home I can't open the database because I'm not logging into the server obviously and it seems to be looking for that.

I have the database. I also have the mdw file with the user and groups permissions etc.. How do I separate the database away from this so that I can open it? or how do I open it? I have username and password for admin but I don't think that's any use to me? cos I don't really know how to log on off site...So if there is anything I can do can you please let me know in simple step by step instructions !

many tks

 

[everhopefull]

Great I'll try that thanks !

 

[everhopefull]

ok I shouldn't have been so hasty in my reply ! how do I create a shortcut? I tried creating a shortcut on the desktop and then just changing the target path to your suggestion above (with my parameters) but it says it's not valid and won't allow me? Did you mean something else by a shortcut?

tks

 

[ghudson]

Your target value must point to the location of the MSACCESS.EXE file, the location of the workgroup MDW file and the location of the MDB file. Like this... [all on one line and each string in quotes, but not the switches]...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "X:\WorkgroupFile.mdw" "X:\DatabaseFile.mdb" /user UserName

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

 

[everhopefull]

Thanks for that I'll give it a go. I'm usually really good at searching and have found most of my answers that way, but for this one I didn't really know how to search cos I wasn't sure how it would be worded !

tks

 

[everhopefull]

Thank you so much that worked beautifully !!

 

[ghudson]

You are welcome

 

[everhopefull]

ok I'm back !! While I can now open the database, unfortunately it won't let me make changes to it as it keeps saying I don't have exclusive access to it. How do I get around that? I noticed the same thing happens when I am onsite even if I make sure no-one else has it opened?

tks

 

[everhopefull]

sri I should add, I tried putting a /excl switch at the end but it says I don't have permission to open it for exclusive access

 

[ghudson]

You need to have full file rights [open/add/edit/delete] to the directory that the db is located in. Then I suggest that you open the db, open the *.ldb [record locking] file that is created weh you open a db using a text editor like WordPad and see which computers are listed in the *.ldb file. All of those computers must close the db and reboot their computers to release the lock they have on the db.