Creating New Database Group in Access 2003

[Guest]

Hi,

I am trying to create a new Group on the Database window however when I
right click in the Group window the 'New Group' option, along with all other
Group options, are greyed out.

Does anyone know whether there is a setting that needs to be changed to
allow for Groups to be created or whether I can try something else?

Many Thanks
Renee

 

[Guest]

Hi Renee,

Two possibilities include:

1.) The Read-only file attribute has been set.
2.) The file is in the .mde format. You need to start with a .mdb file.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thanks Tom. It is in .mde format at the moment.

The access database uses a lot of ODBC links etc so I'm ok to start again
with a new .mdb file and relink the tables etc but for some reason it won't
let me link the form that's being used in the .mde file currently. Do you
know of a way to import it into my new database?

Many Thanks
Renee

 

[Guest]

Hi Renee,

I'm not sure what you mean by "link the form". Forms are not linked. Can't
you start from the source .mdb file that was used to create your .mde file?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[John W. Vinson]

The access database uses a lot of ODBC links etc so I'm ok to start again
with a new .mdb file and relink the tables etc but for some reason it won't
let me link the form that's being used in the .mde file currently. Do you
know of a way to import it into my new database?

You cannot link to nor import a form from a .mde file into a .mdb. When the
..mde file was created, Access *DELETED* all of the source code in the form. It
can't be imported because it simply no longer exists.

When a .mde is created, the developer has a responsibility to keep a copy of
the .mdb available for future development. Lacking that file means that the
form must be recreated from scratch.

John W. Vinson [MVP]