New to access and in dire need of help

[danx213]

I recently took over this office that uses Access and the old IT guy here set up a user for the access database and now they have new computers and I need to add new users to the database so that they can read and modify it, please help!

[Datagopherdan]

Are you sure that you're using Access 2007? User groups and permissions are not available in that version.

[NTC]

A correction to the previous post; Access2007.accdb format does not support the User based security - but importantly - Access2007.mdb continues to support it.

An .mdb from an earlier version, opened up in Access07 continues to be an .mdb format.

Access07 can work either format.

Having said that however, I can't really answer your question as you've kind of confused the story...while the computers may be new, it seems you would have the same issue if you need to add new users and don't know anything about Access's User based security...so it wouldn't seem like the issue is the newness of the computers.....

I don't think an explanation of User based security can work well in a user forum...I would quick go get an Access2003 book and an Access2007 book and look at the section on this topic.....

[Datagopherdan]

A correction to your post. It's not Access 2007, it's a previous version that you're converting to. You're running it in Access 2007, which can support the previous versions with the mdb format but it will not have all the options that are available through Access 2007 such as file attachments, multi-valued fields etc. Once you convert it, you don't need Access 2007 to run it. If you're converting to 2002/2003, you would be able to open it up with those version of Access. So, what you have is a previous version of Access being ran through Access 2007.

If it's just a matter of your company having Office 2007 and you're running a previous version of Access then it should be relatively easy. Having new computers installed can definitely have an effect on the users especially if there wasn't a shortcut to the database that used the mdw file and instead the user's default workgroups were set to the database's workgroups. That being the case, they're not going to get a login screen when they try to open the database because their default workgroup is going to be different with the new computers. Actually, even if they had shortcuts for the database, that would cause an effect to because the location of Microsoft Access is used in the shortcut, so if it was installed in a different directory then it's not going to work.

A correction to the previous post; Access2007.accdb format does not support the User based security - but importantly - Access2007.mdb continues to support it.

An .mdb from an earlier version, opened up in Access07 continues to be an .mdb format.

Access07 can work either format.

Having said that however, I can't really answer your question as you've kind of confused the story...while the computers may be new, it seems you would have the same issue if you need to add new users and don't know anything about Access's User based security...so it wouldn't seem like the issue is the newness of the computers.....

I don't think an explanation of User based security can work well in a user forum...I would quick go get an Access2003 book and an Access2007 book and look at the section on this topic.....

[danx213]

Uh I am not quite to sure but I believe so, the previous IT guy made a database and added users to the database so that they can make changes and also view the database for the company. But now they have new computers and those need to be able to access the database as well and I have no idea on how to approach this situation, the file format is .mdb

many thanks in advance

Are you sure that you're using Access 2007? User groups and permissions are not available in that version.

[Datagopherdan]

What you're going to need to do is get one of those shortcuts that was working and copy the full path. You will be able to see where the MDW file is. It should be on a network drive, so you won't need to do anything with it. Find where the installation of Microsoft Access is on the new computers, the easiest way to do this would be just create a shortcut to Access. Typically, it's in C:\Program Files\Microsoft Office.

Now look at the shortcut that you C&Ped, it should look something like this.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\SomeFolder\YourFE.mdb" /wrkgrp "N:\MyMDWFile\MyWorkgroup.mdw"

You would replace the C:\Program Files\Microsoft Office\Office portion with the directory path of where Access 2007 was installed to. Hopefully, you do have shortcuts that were created, which will make this very easy to do.

Uh I am not quite to sure but I believe so, the previous IT guy made a database and added users to the database so that they can make changes and also view the database for the company. But now they have new computers and those need to be able to access the database as well and I have no idea on how to approach this situation, the file format is .mdb

many thanks in advance

[allykid]

Dan, I am trying to get my shortcut to work for a similar situation... however, my workgroup doesn't open when the shortcut opens. It defaults the user to their personal workgroup.

Any suggestions?