Recently we migrated to a new hard- and software environment. Also, all data
has moved to a new network drive, with a new name. We have one mdb and an
associated mdw that now gives us trouble. If the users try to open the mdb
they get the message (translated from Dutch):
"you do not have the correct authorisations for the use of object 'G:\...
\OurFileName.md b '. Contact you system manager or the person who has made
the object, to establish the correct authorisations for you."
We suspect that there is hard path reference in the mdb that points to the
old location of
the mdw (with the old drive's name). I have never worked with
'authorisations ' or working grouops and the builder of this application is
gone and can not be reached.
Does anyone have an idea on how we can get the mdb to run again? Even if we
would lose the whole autorisation and workgroup functionality in this mdb,
that would be better than nothing being able to access the mdb at all.
Temporarily moving back to the old network drive is not an option.
Thanks in advance,
john 5 1482
John wrote:
Recently we migrated to a new hard- and software environment. Also, all data
has moved to a new network drive, with a new name. We have one mdb and an
associated mdw that now gives us trouble. If the users try to open the mdb
they get the message (translated from Dutch):
"you do not have the correct authorisations for the use of object 'G:\...
\OurFileName.md b '. Contact you system manager or the person who has made
the object, to establish the correct authorisations for you."
We suspect that there is hard path reference in the mdb that points to the
old location of
the mdw (with the old drive's name). I have never worked with
'authorisations ' or working grouops and the builder of this application is
gone and can not be reached.
Does anyone have an idea on how we can get the mdb to run again? Even if we
would lose the whole autorisation and workgroup functionality in this mdb,
that would be better than nothing being able to access the mdb at all.
Temporarily moving back to the old network drive is not an option.
Thanks in advance,
john
Either way you still have to know how to access the security settings.
You did not mention the database and version or anything like that so
you are probably not going to get much usable help. A lot depends on
why you split the database up on the two drives. If they are in two
separate databases you may have two separate sets of security. Some
networking server software would let you join the two drives into one
volume and treat it all as one location or object if it was on the same
server.
My suggestion is hire a consultant that knows the database and/or
application or some kind of professional outfit that can make some
suggestions or help you to accomplish what you want to do. It may save
you money and time in the long run. You dont want to find out months
from now that you are going to have redo your conversion because you
have missing writes to the table and corrupt data.
Thanks for your reply.
You did not mention the database and version or anything like that so you
are probably not going to get much usable help.
It's an Access 2000 mdb and we now use Access 2002.
A lot depends on why you split the database up on the two drives. If they
are in two separate databases you may have two separate sets of security.
Some networking server software would let you join the two drives into one
volume and treat it all as one location or object if it was on the same
server.
I don't know how things were made on the former server or why. I only know
that the mdb and mdw are both in the same folder. This morning a co worker
copied the mdb and mdw to a C-drive and simulated the old path with the dos
substitute command. That didn't change anything: same message.
Seems we have to inform Houston and bring in the helicopters to hunt down
the creator of this database :-)
john
"Last Boy Scout" <Ba*****@whiteh ouse.govschreef in bericht
news:Ey******** ********@newsfe 04.lga...
John wrote:
>Recently we migrated to a new hard- and software environment. Also, all data has moved to a new network drive, with a new name. We have one mdb and an associated mdw that now gives us trouble. If the users try to open the mdb they get the message (translated from Dutch):
"you do not have the correct authorisations for the use of object 'G:\... \OurFileName.m db '. Contact you system manager or the person who has made the object, to establish the correct authorisations for you."
We suspect that there is hard path reference in the mdb that points to the old location of the mdw (with the old drive's name). I have never worked with 'authorisation s' or working grouops and the builder of this application is gone and can not be reached.
Does anyone have an idea on how we can get the mdb to run again? Even if we would lose the whole autorisation and workgroup functionality in this mdb, that would be better than nothing being able to access the mdb at all.
Temporarily moving back to the old network drive is not an option.
Thanks in advance, john
Either way you still have to know how to access the security settings. You
did not mention the database and version or anything like that so you are
probably not going to get much usable help. A lot depends on why you
split the database up on the two drives. If they are in two separate
databases you may have two separate sets of security. Some networking
server software would let you join the two drives into one volume and
treat it all as one location or object if it was on the same server.
My suggestion is hire a consultant that knows the database and/or
application or some kind of professional outfit that can make some
suggestions or help you to accomplish what you want to do. It may save
you money and time in the long run. You dont want to find out months from
now that you are going to have redo your conversion because you have
missing writes to the table and corrupt data.
Actually, it may be that all you need to do is to use the Linked Table
Manager to relink the tables to the "back end" database in its new location.
Each user will have to have Create, Delete, Read, and Write access to the
folder where the back end datastore is stored. The messages you are seeing
do not _necessarily_ indicate a problem with Access security.
If you will search at http://support.microsoft.com for the "Orders and
Solutions Sample Database", the Solutions sample (which hasn't been updated
since Access 2000, but still is very useful) has an example of relinking
tables at startup. On my linked databases, I also employ the solution
donated by Ken Getz, that is available to the Access user community at http://www.mvps.org/access/api/api0001.htm to allow the user to browse and
find the backend.
Larry Linson
Microsoft Access MVP
"John" <jo@hn.comwro te in message
news:f0******** ***@textnews.wa nadoo.nl...
Thanks for your reply.
>You did not mention the database and version or anything like that so you are probably not going to get much usable help.
It's an Access 2000 mdb and we now use Access 2002.
>A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.
I don't know how things were made on the former server or why. I only know
that the mdb and mdw are both in the same folder. This morning a co worker
copied the mdb and mdw to a C-drive and simulated the old path with the
dos substitute command. That didn't change anything: same message.
Seems we have to inform Houston and bring in the helicopters to hunt down
the creator of this database :-)
john
"Last Boy Scout" <Ba*****@whiteh ouse.govschreef in bericht
news:Ey******** ********@newsfe 04.lga...
>John wrote:
>>Recently we migrated to a new hard- and software environment. Also, all data has moved to a new network drive, with a new name. We have one mdb and an associated mdw that now gives us trouble. If the users try to open the mdb they get the message (translated from Dutch):
"you do not have the correct authorisations for the use of object 'G:\... \OurFileName.md b '. Contact you system manager or the person who has made the object, to establish the correct authorisations for you."
We suspect that there is hard path reference in the mdb that points to the old location of the mdw (with the old drive's name). I have never worked with 'authorisatio ns' or working grouops and the builder of this application is gone and can not be reached.
Does anyone have an idea on how we can get the mdb to run again? Even if we would lose the whole autorisation and workgroup functionality in this mdb, that would be better than nothing being able to access the mdb at all.
Temporarily moving back to the old network drive is not an option.
Thanks in advance, john
Either way you still have to know how to access the security settings. You did not mention the database and version or anything like that so you are probably not going to get much usable help. A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.
My suggestion is hire a consultant that knows the database and/or application or some kind of professional outfit that can make some suggestions or help you to accomplish what you want to do. It may save you money and time in the long run. You dont want to find out months from now that you are going to have redo your conversion because you have missing writes to the table and corrupt data.
Thanks! That sounds hopeful. I'll check it out.
"Larry Linson" <bo*****@localh ost.notschreef in bericht
news:krzWh.609$ nR1.521@trnddc0 6...
Actually, it may be that all you need to do is to use the Linked Table
Manager to relink the tables to the "back end" database in its new
location. Each user will have to have Create, Delete, Read, and Write
access to the folder where the back end datastore is stored. The messages
you are seeing do not _necessarily_ indicate a problem with Access
security.
If you will search at http://support.microsoft.com for the "Orders and
Solutions Sample Database", the Solutions sample (which hasn't been
updated since Access 2000, but still is very useful) has an example of
relinking tables at startup. On my linked databases, I also employ the
solution donated by Ken Getz, that is available to the Access user
community at http://www.mvps.org/access/api/api0001.htm to allow the user
to browse and find the backend.
Larry Linson
Microsoft Access MVP
"John" <jo@hn.comwro te in message
news:f0******** ***@textnews.wa nadoo.nl...
>Thanks for your reply.
>>You did not mention the database and version or anything like that so you are probably not going to get much usable help.
It's an Access 2000 mdb and we now use Access 2002.
>>A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.
I don't know how things were made on the former server or why. I only know that the mdb and mdw are both in the same folder. This morning a co worker copied the mdb and mdw to a C-drive and simulated the old path with the dos substitute command. That didn't change anything: same message.
Seems we have to inform Houston and bring in the helicopters to hunt down the creator of this database :-)
john
"Last Boy Scout" <Ba*****@whiteh ouse.govschreef in bericht news:Ey******* *********@newsf e04.lga...
>>John wrote: Recently we migrated to a new hard- and software environment. Also, all data has moved to a new network drive, with a new name. We have one mdb and an associated mdw that now gives us trouble. If the users try to open the mdb they get the message (translated from Dutch):
"you do not have the correct authorisations for the use of object 'G:\... \OurFileName.md b '. Contact you system manager or the person who has made the object, to establish the correct authorisations for you."
We suspect that there is hard path reference in the mdb that points to the old location of the mdw (with the old drive's name). I have never worked with 'authorisati ons' or working grouops and the builder of this application is gone and can not be reached.
Does anyone have an idea on how we can get the mdb to run again? Even if we would lose the whole autorisation and workgroup functionality in this mdb, that would be better than nothing being able to access the mdb at all.
Temporaril y moving back to the old network drive is not an option.
Thanks in advance, john Either way you still have to know how to access the security settings. You did not mention the database and version or anything like that so you are probably not going to get much usable help. A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.
My suggestion is hire a consultant that knows the database and/or application or some kind of professional outfit that can make some suggestions or help you to accomplish what you want to do. It may save you money and time in the long run. You dont want to find out months from now that you are going to have redo your conversion because you have missing writes to the table and corrupt data.
In our citrix-environment users can't make short cuts with reference to the
Access-exe. One of our administrators made a vbs script that does reference
to the Access-exe, the mdw location, and the mdb location and made the
application works again.
Thanks,
john
"John" <jo@hn.comschre ef in bericht
news:f0******** ***@textnews.wa nadoo.nl...
Thanks! That sounds hopeful. I'll check it out.
"Larry Linson" <bo*****@localh ost.notschreef in bericht
news:krzWh.609$ nR1.521@trnddc0 6...
>Actually, it may be that all you need to do is to use the Linked Table Manager to relink the tables to the "back end" database in its new location. Each user will have to have Create, Delete, Read, and Write access to the folder where the back end datastore is stored. The messages you are seeing do not _necessarily_ indicate a problem with Access security.
If you will search at http://support.microsoft.com for the "Orders and Solutions Sample Database", the Solutions sample (which hasn't been updated since Access 2000, but still is very useful) has an example of relinking tables at startup. On my linked databases, I also employ the solution donated by Ken Getz, that is available to the Access user community at http://www.mvps.org/access/api/api0001.htm to allow the user to browse and find the backend.
Larry Linson Microsoft Access MVP
"John" <jo@hn.comwro te in message news:f0******* ****@textnews.w anadoo.nl...
>>Thanks for your reply.
You did not mention the database and version or anything like that so you are probably not going to get much usable help.
It's an Access 2000 mdb and we now use Access 2002.
A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.
I don't know how things were made on the former server or why. I only know that the mdb and mdw are both in the same folder. This morning a co worker copied the mdb and mdw to a C-drive and simulated the old path with the dos substitute command. That didn't change anything: same message.
Seems we have to inform Houston and bring in the helicopters to hunt down the creator of this database :-)
john
"Last Boy Scout" <Ba*****@whiteh ouse.govschreef in bericht news:Ey****** **********@news fe04.lga... John wrote: Recently we migrated to a new hard- and software environment. Also, all data has moved to a new network drive, with a new name. We have one mdb and an associated mdw that now gives us trouble. If the users try to open the mdb they get the message (translated from Dutch): > "you do not have the correct authorisations for the use of object 'G:\... \OurFileName.md b '. Contact you system manager or the person who has made the object, to establish the correct authorisations for you." > We suspect that there is hard path reference in the mdb that points to the old location of the mdw (with the old drive's name). I have never worked with 'authorisat ions' or working grouops and the builder of this applicati on is gone and can not be reached. > Does anyone have an idea on how we can get the mdb to run again? Even if we would lose the whole autorisation and workgroup functionality in this mdb, that would be better than nothing being able to access the mdb at all. > Temporari ly moving back to the old network drive is not an option. > Thanks in advance, john Either way you still have to know how to access the security settings. You did not mention the database and version or anything like that so you are probably not going to get much usable help. A lot depends on why you split the database up on the two drives. If they are in two separate databases you may have two separate sets of security. Some networking server software would let you join the two drives into one volume and treat it all as one location or object if it was on the same server.
My suggestion is hire a consultant that knows the database and/or applicatio n or some kind of professional outfit that can make some suggestion s or help you to accomplish what you want to do. It may save you money and time in the long run. You dont want to find out months from now that you are going to have redo your conversion because you have missing writes to the table and corrupt data.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Paddy McCarthy |
last post by:
Frustrated at being prevented from using Python at work I went
gunning for Perl.
Time to roll out some useless Google statistics to make me feel
better
Google Phrase count
------------- -----
"prefer perl to python" 26
"prefers perl to python" 0
|
by: susmita_ganguly |
last post by:
Hi
I am trying to upgrade from oracle 8i to oracle 9i on the same server
..I don't know much abt migration .
Can anyone help me out.
Thanks.
Susmita
|
by: Jep |
last post by:
Any help or advice appreciated.
We have just installed and configured a new DB2 v.8.1 with latest
FixPack. Just a few days later it dies and now we have a DB that is
totally unusable.
- - - -
It went all wrong one morning when connecting gave us this msg:
|
by: Abram Friesen |
last post by:
Hi,
I'm a developer for a software application vendor, and our application
makes use of a customer-maintained Oracle 8i/9i database. We've had a
customer request to support DB2 database, and I'm looking into the
feasibility of migration. Our application runs on NT Server and, the
DB2 database would be in some cases on a separate AIX machine, in
other cases on an AS/400.
There are two problems we are running into, both relating to our...
|
by: sac |
last post by:
I am using DB2 v8.1 on UNIX.
A few weeks ago the DBAs carried out node migration activity on the
database.
After the node migration I observed that the queries that execute on
temporary tables show extreme poor performance. One of the query was
partly optimized by declaring a partitioning key on the temporary
table. However it still takes longer than before the node migration.
I would appreciate if I could get information on the...
| |
by: rob |
last post by:
Dear All,
I have a very small test project to convert asp to asp.net using the
Microsoft/Artisan ASP to ASP.NET Migration Assistant
(http://msdn.microsoft.com/asp.net/using/migrating/aspmig/aspmigasst/default
..aspx). Everything works fine when my include file is in the same directory
as the asp file that includes the include file. What I am having trouble
with is that the migration tool doesn't see my include file when it resids
in a...
|
by: Bonggoy Cruz |
last post by:
We have a fairly big size ASP.NET web application that was written VB.NET.
We are in the process converting the web project.
We used the migration wizard included in VS 2005. I followed step by step
guide outlined in here:
http://msdn.microsoft.com/asp.net/reference/migration/upgrade/default.aspx?pull=/library/en-us/dnaspp/html/webprojectsvs05.asp.
I was able to convert the project without any problem.
Compiling and building them is...
|
by: Shawnk |
last post by:
Some Sr. colleges and I have had an on going discussion relative to when and
if
C# will ever support 'true' multiple inheritance.
Relevant to this, I wanted to query the C# community (the 'target' programming
community herein) to get some community input and verify (or not) the
following
two statements.
Few programmers (3 to7%) UNDERSTAND 'Strategic Functional Migration
|
by: Frinavale |
last post by:
I have been researching the best approach to migrating a VB6 application into a VB.NET application. There is a lot of information out there but most of it recommends that you "train in the migration process before jumping into it". One site even recommends that this training process should take at least 2-3 weeks. I'm not sure how you can train for such a process...but maybe I'll find something while I'm researching.
I was wondering if anyone...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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
| |