|
Home > Archive > MS Access database support > April 2006 > Permissions trouble transferring Access97 file to new computer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Permissions trouble transferring Access97 file to new computer
|
|
|
| Tried this on microsoft.public.access.gettingstarted - no response -
perhaps more appropriate here.
I'm not a database user, simply helping someone get started with a new
computer.
The old computer (win98se) runs a database in MS Access 97 pro, with
all the attendant permissions etc. I can work on the database without
problems, once I've opened the file with the requisite user name and
password.
I cancelled the password and exported the access file to a new
filename and then loaded a copy into the new computer (xp) running
another copy of office 97 pro.
I'm able to start the database file on the new computer but no longer
have access to any of the components - eg, if I select a table to
open, I get:
couldn't read definitions; no read definitions permission for table or
query 'the filename'
I've spent some time amongst the various help items on security and,
frankly, I'm bewildered by the whole thing and haven't the time to
study it at length.
It seems that the key is to work at 'administration' level but I can't
work out how to do that.
Could someone please direct me to some *simple* recipe for letting my
friend operate her database on the new computer?
| |
| Bob Quintal 2006-04-07, 7:42 am |
| John <nospam@plusnet.com> wrote in
news:iq7c32ldbiru6sj
nn8ibp9pb521t623b85@
4ax.com:
> Tried this on microsoft.public.access.gettingstarted - no
> response - perhaps more appropriate here.
>
>
> I'm not a database user, simply helping someone get started
> with a new computer.
>
> The old computer (win98se) runs a database in MS Access 97
> pro, with all the attendant permissions etc. I can work on
> the database without problems, once I've opened the file with
> the requisite user name and password.
>
> I cancelled the password and exported the access file to a new
> filename and then loaded a copy into the new computer (xp)
> running another copy of office 97 pro.
>
> I'm able to start the database file on the new computer but no
> longer have access to any of the components - eg, if I select
> a table to open, I get:
>
> couldn't read definitions; no read definitions permission for
> table or query 'the filename'
>
> I've spent some time amongst the various help items on
> security and, frankly, I'm bewildered by the whole thing and
> haven't the time to study it at length.
>
> It seems that the key is to work at 'administration' level but
> I can't work out how to do that.
>
> Could someone please direct me to some *simple* recipe for
> letting my friend operate her database on the new computer?
>
Access stores the login information in a .mdw file.
Search for any .mdw files on the old computer. Most probably the
creator of the database just altered the system.mdw instead of
creating a separate .mdw for their application.
If there is only the one file, system.mdw, rename the file on
the new computer, copy the one from the old computer to the new,
then test to see if everything works.
If there are several .mdw files on the old computer, you'll need
to see which one is used for the database. Before discussing
this try the other option first. If that doesn't help, write
back,
--
Bob Quintal
PA is y I've altered my email address.
| |
|
| Bob Quintal <rquintal@sympatico.ca> wrote:
>Access stores the login information in a .mdw file.
>
>Search for any .mdw files on the old computer. Most probably the
>creator of the database just altered the system.mdw instead of
>creating a separate .mdw for their application.
>
>If there is only the one file, system.mdw, rename the file on
>the new computer, copy the one from the old computer to the new,
>then test to see if everything works.
>
>If there are several .mdw files on the old computer, you'll need
>to see which one is used for the database. Before discussing
>this try the other option first. If that doesn't help, write
>back,
Many thanks, Bob. I'll report back when I've had another shot at the
job in a few days time.
--
John
|
|
|
|
|