Tried this on microsoft.publi c.access.gettin gstarted - 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? 9 5239
John <no****@plusnet .com> wrote in
news:iq******** *************** *********@4ax.c om: Tried this on microsoft.publi c.access.gettin gstarted - 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 <rq******@sympa tico.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
Bob Quintal <rq******@sympa tico.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,
Right Bob.
The whole day gone and I've still not cracked it.
To recap, I've an old computer (win98) on which I can look at data,
using the password, in an MS Access 97 database.
I've copied the Access file *.mdb and the system.mdw file from the old
to a new computer (win xp) running Access 97.
I found system.mdw (the only one of three that was likely - the others
were a Quicken file and a Money file) in c:\windows\syst em folder.
I've put the .mdw file into the same folder (not the system32) in the
new computer. I can open the database but when I try to open a table
I get the message "couldn't read definitions; no read definitions
permission for table or
query 'name of dataset'
I've tried renaming the workgroup on the new computer the same as on
the old. No change.
I've tried making the data (and mdw file) path identical in new and
old computers.
The only difference is that, on the old pc, Office is in its usual
place c:\program files etc whereas on my new machine I've put Office
in a different folder, c:\microsoft office etc.
I've combed the goups literature and I've run out of ideas.
If you have any more, please post.
--
John
John wrote: Bob Quintal <rq******@sympa tico.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,
Right Bob.
The whole day gone and I've still not cracked it.
To recap, I've an old computer (win98) on which I can look at data, using the password, in an MS Access 97 database.
I've copied the Access file *.mdb and the system.mdw file from the old to a new computer (win xp) running Access 97.
I found system.mdw (the only one of three that was likely - the others were a Quicken file and a Money file) in c:\windows\syst em folder.
Are you calling up the database via a shortcut? Check the command line used
to open the DB and see if it is referencing a workgroup file. Or, does the
password prompt come up for all MDBs? This would mean the workgroup is
attached statically so you need to open the Workgroup Administrator (look in
your office folder, actually it might be in the Windows system folder for
Access97....)
I've put the .mdw file into the same folder (not the system32) in the new computer. I can open the database but when I try to open a table I get the message "couldn't read definitions; no read definitions permission for table or query 'name of dataset'
I've tried renaming the workgroup on the new computer the same as on the old. No change.
I've tried making the data (and mdw file) path identical in new and old computers.
You still have to point Access to this workgroup file. You can either do
this via the Access command line
eg.
"C:\Program Files\Microsoft Office 2000\Office\MSA CCESS.EXE" "C:\Program
Files\BIGCare\B igCare.mde" /wrkgrp "C:\Documen ts and Settings\brad\M y
Documents\Minis try\BIGCare\Dat a\BigCare.mdw"
(You must use the full Office path)
, or use the Workgroup Administrator (part of Office) to point to it (But
you will need to point it back to the default system.mdw when using other
MDBs).
Putting it in the same folder does abssolutely nothing.
The only difference is that, on the old pc, Office is in its usual place c:\program files etc whereas on my new machine I've put Office in a different folder, c:\microsoft office etc.
Makes no difference. I run three versions of Office all in different
folders.
I've combed the goups literature and I've run out of ideas.
If you have any more, please post.
How big is the DB? If you are still having problems and if it's not too
large, ZIP it and send it to me. I will try to break the security and import
everything into a new DB without security. bradleyATcomcen DOTcomDOTau
This should be a very last resort and shouldn't be required given you still
have the original MDW available.
--
regards,
Br@dley
"Br@dley" <do***********@ google.com> wrote: Are you calling up the database via a shortcut? Check the command line used to open the DB and see if it is referencing a workgroup file. Or, does the password prompt come up for all MDBs? This would mean the workgroup is attached statically so you need to open the Workgroup Administrator (look in your office folder, actually it might be in the Windows system folder for Access97.... )
Two ways - starting Access 97, 'opening an existing database', choose
file. If I choose the sample, Northwind, all is normal. If I choose
the problematic database (Parish_99.mdb) , I'm asked for a password.
The PW gets me to a set of tabs. I select 'tables' and highlight
'households'. I click on 'open' and get the error message 'Couldn't
read definitions etc.'
I've made a shortcut to the target:
"C:\Microso ft Office\office\m saccess.exe"
"C:\A_Parish\Ru th\Register\Par ish\Parish_99.m db"
/wrkgrp c:\windows\syst em\system.mdw
and 'start in' "c:\microso ft office\office"
this opens Access 97 and asks for a password with the same result as
above.
So the results from the two methods are consistent. How big is the DB?
674k
If you are still having problems and if it's not too large, ZIP it and send it to me. I will try to break the security and import everything into a new DB without security. bradleyATcomcen DOTcomDOTau
This should be a very last resort and shouldn't be required given you still have the original MDW available.
Very kind offer and thankyou but I don't have permission to release
the data to anyone else. If we get desperate we'll have to start the
database again from scratch (aaaarghhh) as the ethics rule out
passing out the file.
Thanks for your help. Any other ideas? I'm troubled by the thought
that there are so many differences between the two situations in which
the database behaves differently. O.S., file structure, directory
structure, winodows workgroup name, windows administrator and so forth
but I've tried to simulate the same conditions as far as possible,
changing the name of my computer (and suffering grief from my backup
software which wants me to re-register :( ) and windows workgroup,
creating a windows guest with the same name and password as that on
the 'working' machine, using the shortcut to run the programme as a
win 98 programme.
Nothing works although I have had a few different error messages when
I try some of these wilder things.
It's as though there is a missing piece of information stored
somewhere on the original computer. Security schemes will see the end
of the world as we know it - I have enough problems remembering all
the security questions on my savings accounts :(
Sorry, I'm being a grumpy old man and shouldn't moan about 'progress'.
--
John
John wrote: "Br@dley" <do***********@ google.com> wrote:
Are you calling up the database via a shortcut? Check the command line used to open the DB and see if it is referencing a workgroup file. Or, does the password prompt come up for all MDBs? This would mean the workgroup is attached statically so you need to open the Workgroup Administrator (look in your office folder, actually it might be in the Windows system folder for Access97....) Two ways - starting Access 97, 'opening an existing database', choose file. If I choose the sample, Northwind, all is normal. If I choose the problematic database (Parish_99.mdb) , I'm asked for a password. The PW gets me to a set of tabs. I select 'tables' and highlight 'households'. I click on 'open' and get the error message 'Couldn't read definitions etc.'
Sounds like the original system.mdw has been modified wrongly?
Actually, are you only being asked for a password and not a username as
well? That'd be a database password rather than workgroup security....
Have you tried holding down the shift key before clicking OK after entering
the password? This will take you to the database window. Try this and open
the Access security dialogs and see if you can give yourself permissions to
everything... or open objects in design view.
I've made a shortcut to the target:
"C:\Microso ft Office\office\m saccess.exe" "C:\A_Parish\Ru th\Register\Par ish\Parish_99.m db" /wrkgrp c:\windows\syst em\system.mdw
and 'start in' "c:\microso ft office\office"
this opens Access 97 and asks for a password with the same result as above.
So the results from the two methods are consistent.
Sounds like you are logging in with a user/pass that doesn't have
permissions to everything? How big is the DB?
674k
If you are still having problems and if it's not too large, ZIP it and send it to me. I will try to break the security and import everything into a new DB without security. bradleyATcomcen DOTcomDOTau
This should be a very last resort and shouldn't be required given you still have the original MDW available.
Very kind offer and thankyou but I don't have permission to release the data to anyone else. If we get desperate we'll have to start the database again from scratch (aaaarghhh) as the ethics rule out passing out the file.
Fair enough. I hesitant to share the "hack" as well:)
Thanks for your help. Any other ideas? I'm troubled by the thought that there are so many differences between the two situations in which the database behaves differently.
That shouldn't matter. As long as you are pointing to the right workgroup
file and can log in as a user with permissions therre shouldn't be a
problem.
O.S., file structure, directory structure, winodows workgroup name, windows administrator and so forth but I've tried to simulate the same conditions as far as possible, changing the name of my computer (and suffering grief from my backup software which wants me to re-register :( ) and windows workgroup, creating a windows guest with the same name and password as that on the 'working' machine, using the shortcut to run the programme as a win 98 programme.
Nothing works although I have had a few different error messages when I try some of these wilder things.
It's as though there is a missing piece of information stored somewhere on the original computer. Security schemes will see the end of the world as we know it - I have enough problems remembering all the security questions on my savings accounts :(
Sorry, I'm being a grumpy old man and shouldn't moan about 'progress'.
I don't quite understand the problems you are having.
If you have the original workgroup file then it should work the same way if
you are using that workgroup file (either from the command-line or through
the workgroup adminstrator). It doesn't matter where the file is storeed on
the PC (or even on a network share).
--
regards,
Br@dley
"Br@dley" <do***********@ google.com> wrote: John wrote: "Br@dley" <do***********@ google.com> wrote:
Are you calling up the database via a shortcut? Check the command line used to open the DB and see if it is referencing a workgroup file. Or, does the password prompt come up for all MDBs? This would mean the workgroup is attached statically so you need to open the Workgroup Administrator (look in your office folder, actually it might be in the Windows system folder for Access97....) Two ways - starting Access 97, 'opening an existing database', choose file. If I choose the sample, Northwind, all is normal. If I choose the problematic database (Parish_99.mdb) , I'm asked for a password. The PW gets me to a set of tabs. I select 'tables' and highlight 'households'. I click on 'open' and get the error message 'Couldn't read definitions etc.'
Sounds like the original system.mdw has been modified wrongly?
Actually, are you only being asked for a password and not a username as well? That'd be a database password rather than workgroup security....
Yes, it is the database password, no username being asked for. Have you tried holding down the shift key before clicking OK after entering the password? This will take you to the database window. Try this and open the Access security dialogs and see if you can give yourself permissions to everything.. . or open objects in design view.
Shift key doesn't change anything. The correct pw simply reveals the
set of tabs including tables, queries etc. I've made a shortcut to the target:
"C:\Microso ft Office\office\m saccess.exe" "C:\A_Parish\Ru th\Register\Par ish\Parish_99.m db" /wrkgrp c:\windows\syst em\system.mdw
and 'start in' "c:\microso ft office\office"
this opens Access 97 and asks for a password with the same result as above.
So the results from the two methods are consistent. Sounds like you are logging in with a user/pass that doesn't have permissions to everything?
Doesn't have permissions to see *any* data other than the named groups
of data for which one can view tables, queries etc. If you have the original workgroup file then it should work the same way if you are using that workgroup file (either from the command-line or through the workgroup adminstrator). It doesn't matter where the file is storeed on the PC (or even on a network share).
OK, looks as though I've reached the end of the line.
On Tue, 11 Apr 2006 07:52:51 +1000, "Br@dley"
<do***********@ google.com> wrote: John wrote: Bob Quintal <rq******@sympa tico.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,
Right Bob.
The whole day gone and I've still not cracked it.
To recap, I've an old computer (win98) on which I can look at data, using the password, in an MS Access 97 database.
I've copied the Access file *.mdb and the system.mdw file from the old to a new computer (win xp) running Access 97.
I found system.mdw (the only one of three that was likely - the others were a Quicken file and a Money file) in c:\windows\syst em folder.
Are you calling up the database via a shortcut? Check the command line used to open the DB and see if it is referencing a workgroup file. Or, does the password prompt come up for all MDBs? This would mean the workgroup is attached statically so you need to open the Workgroup Administrator (look in your office folder, actually it might be in the Windows system folder for Access97.... )
I've put the .mdw file into the same folder (not the system32) in the new computer. I can open the database but when I try to open a table I get the message "couldn't read definitions; no read definitions permission for table or query 'name of dataset'
I've tried renaming the workgroup on the new computer the same as on the old. No change.
I've tried making the data (and mdw file) path identical in new and old computers.
You still have to point Access to this workgroup file. You can either do this via the Access command line
eg.
"C:\Program Files\Microsoft Office 2000\Office\MSA CCESS.EXE" "C:\Program Files\BIGCare\ BigCare.mde" /wrkgrp "C:\Documen ts and Settings\brad\M y Documents\Mini stry\BIGCare\Da ta\BigCare.mdw"
(You must use the full Office path)
I had the same problem and this worked. This is great info!
--
NewsGuy.Com 30Gb $9.95 Carry Forward and On Demand Bandwidth
John <no****@plusnet .com> wrote: OK, looks as though I've reached the end of the line.
Not true, fortunately.
Problem now solved.
For those who meet the same problem:
Recap - Secured database file on old win98se PC - I had user rights.
I copied the file to a new xp pc together with system.mdw (put in new
Windows/System folder). I could not access the database on the new PC
- 'couldn't read definitions; no read definitions permission for table
or query 'filename' . Attempts to enter the database on the new PC,
even with the securing originator's name and password, failed with the
same message.
Solution: Using the originator's identity (name and pw) open new
database on the old PC and 'file/get external data etc' to import the
original database stuff into the new. Transfer this database file and
system.mdw to new PC - all well. All that is now required is to
re-secure the new version on the new PC.
After I had done this, I found a MS FAQ with the official method of
de-securing a database http://support.microsoft.com/default...ent/secfaq.asp
item 34.
As another helpful aside, I spent 7 quid on a used copy of the MS
Access Bible, all 1000 pages of it - not one word about security!
Solution to that one is that you need 'the gold edition' of this
'bible', which has 1500 pages. :(
Thanks again for all the kindly help. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Hugh Welford |
last post by:
Hi, I have installed IIS5 on my machine so that I can do offline asp web
development. (using WIN XP PRO). My machine is called "development"
I have published an on-line working web to
http://development/websites/defaultwebsite/de-stress and copied on-line
working data to c:\inetpub\wwwroot\de-stress\data\schooldata.mdb
The database schooldata.mdb is in access97, and in its on-line existence
accepts both read and write access OK.
|
by: Fran Tirimo |
last post by:
I am developing a small website using ASP scripts to format data retrieved
from an Access database. It will run on a Windows 2003 server supporting
FrontPage extensions 2002 hosted by the company 1&1 with only limited server
configuration via a web based control panel.
My query relates to the ASP security model and how it relates to FrontPage
options for setting file access on a database file. If you know of any
online documentation...
|
by: John Salerno |
last post by:
I always read about how you need to set certain file permissions (for
cgi files, for example), but it's never been clear to me *how* you do
this. I know you can run the line
chmod 755 scriptname.py
but *where* do you run this? Is this done on your personal system, or on
the server? What if you are using Windows? If it's done on the server,
how do you do it?
|
by: IamKJVonly |
last post by:
I have office 97 which includes access97 and have built many access97 databases and use VB4 as the front end. I have just gotten a new computer which has 1 gig of memory on it and when I try to install office 97 on it. everything installs ok execpt access97 won't run.
I have since tried it on another machine and it seems to be a memory problem. If the computer's memory is more than 512megs. then access97 won't run.
Is there a patch or...
|
by: Rico |
last post by:
Hello,
I have an MDE application where I use a bound object frame to display an
image. This frame is updatable and bested on the contents of an OLE field.
My problem is, some images display as the image and some display as an icon
with the file name below. The process I'm following is as follows;
Right click
Choose "Insert Object..."
Select "Create from File"
| |
by: Jeremy.Campbell |
last post by:
I am trying to add a picture to a form that is visible depending on
certain criteria. The picture works perfectly on my computer, but on
other users computers this image is either black or scrambled. Can
someone please help!??!?
|
by: Adam Baker |
last post by:
Hello,
I'm writing a site where a handful of people will be able to edit
the content using PHP scripts (FCKeditor). The content is stored as
individual files in a directory. I'd like to validate the "editors"
using PHP, cookies, etc.
The question is what file permissions I need to allow for the
content to be writable by my PHP script. Do I really need to give
write permissions to the "other" group. Are all wikis really that
vulnerable?...
|
by: JimLad |
last post by:
Hi,
First of all I didn't design this website, but I have been asked to
fix it with the minimum fuss!
Website is using .NET on IIS6 with an Excel Interop to produce
reports. The website impersonates the user and anonymous access is
disabled. Once excel is loaded it stays loaded for the life of the web
application and is accessed through an application variable. As I say,
I didn't design this! Usage of website is very low - once a...
|
by: Pep |
last post by:
Firstly, I'm not sure if this is the right group for this query, so
please forgive me if I am wrong.
My problem is that most users I distribute my software to cannot
install it on their systems due to not having the correct
administrator rights. I'm perplexed over this as I cannot reasonably
ask corporations to allow the local secretary to have admin or power
user rights just to install my software.
My software is intended for user...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |