|
 |
access thread: Read-only Help
Message #1 by "DON LOWE" <donlowe@s...> on Thu, 22 Nov 2001 19:36:34 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0026_01C1738C.FEBE8900
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
I have made up a database and copied it to a friends computer, where it
is read only.
I transferred it by burning the database onto a CD, and then copying
from the CD to his computer.
Can any one advise how I can make the Database Read-Write on the second
computer?
Appreciations for any help in advance.
Regards
Don
Message #2 by "John Ruff" <papparuff@c...> on Thu, 22 Nov 2001 11:10:56 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0003_01C17346.5C1BB830
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Don,
Go to the database and right-click it, select properties and see if the
Read Only option is checked. If it is, uncheck it.
John V. Ruff - The Eternal Optimist :-)
-----Original Message-----
From: DON LOWE [mailto:donlowe@s...]
Sent: Thursday, November 22, 2001 10:37 AM
To: Access
Subject: [access] Read-only Help
I have made up a database and copied it to a friends computer, where it
is read only.
I transferred it by burning the database onto a CD, and then copying
from the CD to his computer.
Can any one advise how I can make the Database Read-Write on the second
computer?
Appreciations for any help in advance.
Regards
Don
Message #3 by "DON LOWE" <donlowe@s...> on Fri, 23 Nov 2001 08:16:13 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C173F7.1D9C8D80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
John
Thank you once again for your help. I am unable to change the setting in
the CD or the second computer.
I think this problem comes about when I copy the program onto the CD.
The CD writers on the two computers are not compatible if one just
formats the CD then copies the Database. I had to go a stage further and
prepare the CD so it could be read from any CD-Rom or Writer.
Possibly I will have to take the CD writer from my computer and install
it on the second computer, this will be cumbersome and I am hoping to
find an easier way around the problem.
Is there any other approach that you can think of.
Regards
Don
Message #4 by Walt Morgan <wmorgan@s...> on Fri, 23 Nov 2001 06:24:37 -0600
|
|
You can use the ATTRIB.EXE:
Example: Attrib -R <drive:\folder\FILENAME.EXT>
Message #5 by "John Ruff" <papparuff@c...> on Fri, 23 Nov 2001 10:14:55 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0017_01C17407.B36C8030
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Don,
You cannot change the property for the file on the CD. Does the program
on the second computer have the Read Only property checked off? (Again,
go to the folder the program is located, right-click the program and
select Properties.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: DON LOWE [mailto:donlowe@s...]
Sent: Thursday, November 22, 2001 11:16 PM
To: Access
Subject: [access] RE: Read-only Help
John
Thank you once again for your help. I am unable to change the setting in
the CD or the second computer.
I think this problem comes about when I copy the program onto the CD.
The CD writers on the two computers are not compatible if one just
formats the CD then copies the Database. I had to go a stage further and
prepare the CD so it could be read from any CD-Rom or Writer.
Possibly I will have to take the CD writer from my computer and install
it on the second computer, this will be cumbersome and I am hoping to
find an easier way around the problem.
Is there any other approach that you can think of.
Regards
Don
Message #6 by "Adeyemi Ajao" <adeyemiajao@h...> on Sat, 24 Nov 2001 03:19:28 +0000
|
|
I have problem converting my database files to Access database files.
I was able to convert the file into Excel and an attempt to convert from
there into Access only created link to the excel file. This is not what i
want.
Any help would be appreciated.
With love from,
Yemi
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Message #7 by "John Ruff" <papparuff@c...> on Fri, 23 Nov 2001 23:03:13 -0800
|
|
If this is a one-time import then go to File>Get External Data>Import,
select the file to import and then follow the prompts. I would suggest
importing to a new table, then append the data in your new table to the
table you actually want to store the data.
If this is going to be a recurring event, go to help and check-out
docmd.transferspreadsheet.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: Adeyemi Ajao [mailto:adeyemiajao@h...]
Sent: Friday, November 23, 2001 7:19 PM
To: Access
Subject: [access] RE: Read-only Help
I have problem converting my database files to Access database files. I
was able to convert the file into Excel and an attempt to convert from
there into Access only created link to the excel file. This is not what
i
want.
Any help would be appreciated.
With love from,
Yemi
_________________________________________________________________
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
---
You are currently subscribed to access as: papparuff@c... To
unsubscribe send a blank email to $subst('Email.Unsub')
Message #8 by "Adeyemi Ajao" <adeyemiajao@h...> on Sat, 24 Nov 2001 11:36:28 +0000
|
|
Thank you very much John Ruff. Your solution is perfect and my problem
solved. Once again i am grateful.
Yemi
>From: "John Ruff" <papparuff@c...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] RE: Read-only Help
>Date: Fri, 23 Nov 2001 23:03:13 -0800
>
>If this is a one-time import then go to File>Get External Data>Import,
>select the file to import and then follow the prompts. I would suggest
>importing to a new table, then append the data in your new table to the
>table you actually want to store the data.
>
>If this is going to be a recurring event, go to help and check-out
>docmd.transferspreadsheet.
>
>John Ruff - The Eternal Optimist :-)
>
>
>
>-----Original Message-----
>From: Adeyemi Ajao [mailto:adeyemiajao@h...]
>Sent: Friday, November 23, 2001 7:19 PM
>To: Access
>Subject: [access] RE: Read-only Help
>
>
>I have problem converting my database files to Access database files. I
>was able to convert the file into Excel and an attempt to convert from
>there into Access only created link to the excel file. This is not what
>i
>want.
>Any help would be appreciated.
>
>With love from,
>Yemi
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
>
>
>---
>You are currently subscribed to access as: papparuff@c... To
>unsubscribe send a blank email to $subst('Email.Unsub')
>
>
>
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
|
|
 |