[AccessD] Coping a Table.

Jim Lawrence accessd at shaw.ca
Thu Sep 6 15:35:15 CDT 2007


Thanks Charlotte... will try that next but I hesitate to assume they are too
unknowledgeable. 

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, September 06, 2007 12:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Coping a Table.

Hmmn.  Are they actually extracting the file or just trying to use it
from within the zip?  The latter can tell them it's read only.  If
that's the case, extracting the mdb before trying to import it should
work.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, September 06, 2007 12:10 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Coping a Table.

Hi Charlotte:

I am just sending a zip as an attachment to an email. It should be as
simple as to open the destination MDB, save the attachment to a
directory, unzip it, open the source MDB and drag and drop. 

...but for some reason the new table appears to arrive 'locked'???

Of course you never know what is really happening at the other end.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Thursday, September 06, 2007 10:22 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Coping a Table.

How are you sending it?  If you put it on a CD, it will be normally
readonly by default and they have to copy it to their hard drive and set
the read-only file attribute to false. 

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, September 06, 2007 9:37 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Coping a Table.

Hi All:

I have been sending a single table, in a new MDB, to a client so they
can copy it into their MDB. They report that the table is locked and
they can not copy it. We have gone through this process a couple of
times and I am not sure what is going on.

I have just suggested a Make-Table query and hopefully that will solve
the problem. 

Has anyone else ran across this problem before and found a solution or a
reason.

TIA
Jim

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list