Reading records without security

[Ramesh]

Hi,

I have a database with security enabled on my system. Now the problem is I
am unable to open this database outside the LAN. Is it possible to open
this database and move some data to another file which i can take home to
work?
Also i need an application to access the database file but does not have the
provision for username and password.

I tried creating a new database and import the data from the secure
database. But still doesnt work.

Any help please.

Thanks
Ramesh

 

[Rob Parker]

Ramesh,

If this is YOUR database, then you should know how to do what you are
asking.

If it's a secured database to which you have access for certain actions,
then it seems that the security provided by the Access user-level security
model is doing its job. And, if that's the case, and you really do
have/need legitimate reasons to do what you are asking about, then talk to
the database administrator.

Rob

 

[Scott McDaniel]

Hi,

I have a database with security enabled on my system. Now the problem is I
am unable to open this database outside the LAN. Is it possible to open
this database and move some data to another file which i can take home to

When you say "security enabled on my system", do you mean you've secured the database with ULS, or are you referring to
something else? If you're using ULS, then you'll need the database and workgroup (.mdw) file used when securing the
database, as well as a valid username/password. The simplest way to open a secured database is by creating a shortcut,
with the target set something like this:

"full path to msaccess.exe" "full path to your database" /wrkgrp "full path to your workgroup file"

work?
Also i need an application to access the database file but does not have the
provision for username and password.

Not sure what you're asking for ... if you need an external application to use the database, then you'll need to
configure the external app to use the correct workgroup file and username/password (or have the user enter those creds
when starting). If this is a VB app (or something similar) and you're using ADO to connect, you'd set the ConnectString
property of that object to reflect the workgroup you want to use; see this site for the proper connect string syntax:

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet

If you're connecting in a different manner, you'll need to give more info. If your external app has no provisions for
connecting to a secured Access/Jet database, then you're out of luck, unless the developer is willing to provide that
functionality.

I tried creating a new database and import the data from the secure
database. But still doesnt work.

Any help please.

Thanks
Ramesh

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Ramesh]

Thanks Scott and Rob for your inputs,

Let me see if i got it clear and also make myself more clear.

If i need to work on the database outside the network, can i copy simply the
database along with the mdw file onto my laptop, and would i be able to work
on it at home?

The other application i referred to is a messaging software which sends
reads mobile numbers from the database and sends out SMS messages. Now this
software does not know how to logon. Is there a way i could just export the
phone numbers out from the database so that this software could access it
without logging on with username and password.

I have all admin access to the database.

Thanks
Ramesh

 

[Scott McDaniel]

Thanks Scott and Rob for your inputs,

Let me see if i got it clear and also make myself more clear.

If i need to work on the database outside the network, can i copy simply the
database along with the mdw file onto my laptop, and would i be able to work
on it at home?

Yes, assuming you open Access with the correct mdw file (and you have the needed username/password).

The other application i referred to is a messaging software which sends
reads mobile numbers from the database and sends out SMS messages. Now this
software does not know how to logon. Is there a way i could just export the
phone numbers out from the database so that this software could access it
without logging on with username and password.

If you can log into the Access database, then you can export the table to an external, unsecured database ... if it were
me, I'd do this while logged in as the Admin user, otherwise you might find that the new database with your phone
numbers would also be unreadable by the SMS program. Can your SMS program use a textfile to read the numbers? If so,
that'd be the simplest way to do it ...

I have all admin access to the database.

Thanks
Ramesh

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Ramesh]

Yes, assuming you open Access with the correct mdw file (and you have the
needed username/password).

Great ... wud it be sufficient if i place the correct mdw file in the same
folder as the database? is there any path pointing configuration to do? am
sorry am asking without trying it out. will have to try tonight at home but
thought i d clarify.>

If you can log into the Access database, then you can export the table to
an external, unsecured database ... if it were
me, I'd do this while logged in as the Admin user, otherwise you might
find that the new database with your phone
numbers would also be unreadable by the SMS program. Can your SMS program
use a textfile to read the numbers? If so,
that'd be the simplest way to do it ...

EXACTLY what i want to do is to export the phone numbers to an external
unsecured database. Wud be great if you cud help with that. When am logged
as an admin user and export the numbers to another file, that file still
turns out to be secured. How can i get this external file to be unsecured?
This is my original problem.

Thanks for all your help so far.