moving a 2000 DB from one workgroup to a new one

[mav51 via AccessMonster.com]

I created a small database that my boss now wants to have usernames/passwords
for. The problem is that we already use an secure Access database for
another, unrelated purpose. I think (after browsing here for awhile) that
the simplest way would be to create a new .mdw with it's own set of
usernames/permissions and use shortcuts to join the appropriate .mdw when
opening one of the database.
My problem is that the database was created when I was in the first workgroup
and when I create a new one and join it I don't have permission to modify
anything in the database. I've tried importing the structure only but it
still won't let me. I'd rather not have to recreate the new database
manually.
Any ideas?
Thanks!

 

[Joan Wild]

Since you created it while logged in to the first secure mdw, the database is owned by that username.

If you really want a separate secure mdw for this mdb, you'll need to either
1. temporarily grant the users group permission on everything; create your new mdw, new mdb while logged in as a new user, and then import everything; then go back and remove all permissions from the Users Group again.
OR
2. create your new mdw. Create that exact same user in the first secure mdw as well (same name/PID), and put them in the Admins group. Create a new mdb while using your new mdw, and import everything. Then you can delete the user from the first secure mdw.

 

[mav51 via AccessMonster.com]

Thanks, I think I'll be giving option 2 a try and let you know how it goes.

Since you created it while logged in to the first secure mdw, the database is owned by that username.

If you really want a separate secure mdw for this mdb, you'll need to either
1. temporarily grant the users group permission on everything; create your new mdw, new mdb while logged in as a new user, and then import everything; then go back and remove all permissions from the Users Group again.
OR
2. create your new mdw. Create that exact same user in the first secure mdw as well (same name/PID), and put them in the Admins group. Create a new mdb while using your new mdw, and import everything. Then you can delete the user from the first secure mdw.

I created a small database that my boss now wants to have usernames/passwords
for. The problem is that we already use an secure Access database for

[quoted text clipped - 9 lines]

Any ideas?
Thanks!

 

[mav51 via AccessMonster.com]

That seemed to have done the trick. The switchboard no longer works but it's
not an big deal to recreate that.

Thanks again.

Since you created it while logged in to the first secure mdw, the database is owned by that username.

If you really want a separate secure mdw for this mdb, you'll need to either
1. temporarily grant the users group permission on everything; create your new mdw, new mdb while logged in as a new user, and then import everything; then go back and remove all permissions from the Users Group again.
OR
2. create your new mdw. Create that exact same user in the first secure mdw as well (same name/PID), and put them in the Admins group. Create a new mdb while using your new mdw, and import everything. Then you can delete the user from the first secure mdw.

I created a small database that my boss now wants to have usernames/passwords
for. The problem is that we already use an secure Access database for

[quoted text clipped - 9 lines]

Any ideas?
Thanks!

 

[mav51 via AccessMonster.com]

Hi there, I may have spoken too soon when I said it was working fine. All
the forms, queries, etc seem to have been imported fine (I followed your 2nd
suggestion) but none of the class objects seem to have been imported nor can
I export them from the old one and into the new one. When I open the project
window, I can see all of the forms I created under 'Microsoft Access Class
Objects but instead of the code I wrote I get the following error "Error
access file. Network connection may have been lost."
I tried creating another new blank db and reimporting everything again but no
luck.
Thanks.

Since you created it while logged in to the first secure mdw, the database is owned by that username.

If you really want a separate secure mdw for this mdb, you'll need to either
1. temporarily grant the users group permission on everything; create your new mdw, new mdb while logged in as a new user, and then import everything; then go back and remove all permissions from the Users Group again.
OR
2. create your new mdw. Create that exact same user in the first secure mdw as well (same name/PID), and put them in the Admins group. Create a new mdb while using your new mdw, and import everything. Then you can delete the user from the first secure mdw.

I created a small database that my boss now wants to have usernames/passwords
for. The problem is that we already use an secure Access database for

[quoted text clipped - 9 lines]

Any ideas?
Thanks!

 

[Joan Wild]

Where are you seeing 'Microsoft Access Class Objects'?

Just import all the forms and modules. Then compact the database. Then debug/Compile the project.

--
Joan Wild
Microsoft Access MVP

Hi there, I may have spoken too soon when I said it was working fine. All
the forms, queries, etc seem to have been imported fine (I followed your 2nd
suggestion) but none of the class objects seem to have been imported nor can
I export them from the old one and into the new one. When I open the project
window, I can see all of the forms I created under 'Microsoft Access Class
Objects but instead of the code I wrote I get the following error "Error
access file. Network connection may have been lost."
I tried creating another new blank db and reimporting everything again but no
luck.
Thanks.

Since you created it while logged in to the first secure mdw, the database is owned by that username.

If you really want a separate secure mdw for this mdb, you'll need to either
1. temporarily grant the users group permission on everything; create your new mdw, new mdb while logged in as a new user, and then import everything; then go back and remove all permissions from the Users Group again.
OR
2. create your new mdw. Create that exact same user in the first secure mdw as well (same name/PID), and put them in the Admins group. Create a new mdb while using your new mdw, and import everything. Then you can delete the user from the first secure mdw.

I created a small database that my boss now wants to have usernames/passwords
for. The problem is that we already use an secure Access database for

[quoted text clipped - 9 lines]

Any ideas?
Thanks!

 

[mav51 via AccessMonster.com]

I imported all the forms, tables and queries and tried the compact/repair
after but now if I try and look at the code behind any of the buttons on the
forms(even if it's a button to simply close the form) I get the error I
mentioned. I tried re-creating the buttons but still get the same error.
I see the 'Microsoft Access Class Objects' when I try to edit the event
prodecdure for the 'On Click' event of the button I'm trying to edit or
create.

Where are you seeing 'Microsoft Access Class Objects'?

Just import all the forms and modules. Then compact the database. Then debug/Compile the project.

Hi there, I may have spoken too soon when I said it was working fine. All
the forms, queries, etc seem to have been imported fine (I followed your 2nd

[quoted text clipped - 19 lines]

 

[mav51 via AccessMonster.com]

I imported all the forms, tables and queries and tried the compact/repair
after but now if I try and look at the code behind any of the buttons on the
forms(even if it's a button to simply close the form) I get the error I
mentioned. I tried re-creating the buttons but still get the same error.
I see the 'Microsoft Access Class Objects' when I try to edit the event
prodecdure for the 'On Click' event of the button I'm trying to edit or
create.

Where are you seeing 'Microsoft Access Class Objects'?

Just import all the forms and modules. Then compact the database. Then debug/Compile the project.

Hi there, I may have spoken too soon when I said it was working fine. All
the forms, queries, etc seem to have been imported fine (I followed your 2nd

[quoted text clipped - 19 lines]

 

[Joan Wild]

Immediately after importing all the tables/queries/forms/reports/modules, and then compact/repair, hit Ctrl-G and then Debug menu...Compile.

If you get any errors, you need to fix them, then compile again. Once it compiles, hit the Save button and close the window Then compact again.

I have a feeling you'll get errors on the compile. If so, go to Tools, References and uncheck anything marked missing. Try the compile again.

--
Joan Wild
Microsoft Access MVP

I imported all the forms, tables and queries and tried the compact/repair
after but now if I try and look at the code behind any of the buttons on the
forms(even if it's a button to simply close the form) I get the error I
mentioned. I tried re-creating the buttons but still get the same error.
I see the 'Microsoft Access Class Objects' when I try to edit the event
prodecdure for the 'On Click' event of the button I'm trying to edit or
create.

Where are you seeing 'Microsoft Access Class Objects'?

Just import all the forms and modules. Then compact the database. Then debug/Compile the project.

Hi there, I may have spoken too soon when I said it was working fine. All
the forms, queries, etc seem to have been imported fine (I followed your 2nd

[quoted text clipped - 19 lines]

Any ideas?
Thanks!