Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 1st, 2006, 07:30 AM
Registered User
 
Join Date: Nov 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Compact Database

I'm having trouble with an access 97 database, when I try to compact I get the following error

'Record(s) can't be read; no read permission on 'C:\Documents.....Master_Data.mdb'

There is definately read permission because other than this issue the DB works fine.

Also Excel files i've set up to read from the database by importing as external data can no longer read the data, they come up with the following error upon refreshing.

'Data could not be retrieved from the database. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again.

I've tried following advice on the ms website and giving read permissions to user groups but this isn't working, anyone got any idea's, i'm guessing the two errors are linked to the same issue.

tx

edit

It also gives me this error when trying to copy info from a table

'the microsoft jet database engine stopped the process because you and another user are attempting to change data at the same time'

Despite me being the only person in the database.
 
Old December 1st, 2006, 09:27 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Are you opening the database as Exclusive?

Open Access, then click File > Open, then browse to the file, then in the lower right corner, select Open Exclusive.

In the worst case, copy and paste the data from the tables to Excel.

HTH

mmcdonal
 
Old December 1st, 2006, 12:04 PM
Registered User
 
Join Date: Nov 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Exclusive mode doesn't work for compacting the database.

I've figured out what the second problem was now, a comments field that is formatted as a memo field was causing the export to crash so i've removed the field from the query. I need to get it back in again so will have to figure that out, does anyone know if memo fields can't be exported once one of the records contains more than 255 char's or is it something else that will be causing the problem, I would have thought the field would just be truncated which is fine.

BTW copying and pasting the info to Excel would of course work but this is info required by a lot of people and needs to be a live export, essentially the excel spreadsheet is a way for people who don't need to be in the access db to view the information, a read only viewer.
 
Old December 1st, 2006, 12:16 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Memo fields can be problematic, but will transfer with code. I have moved memo fields in Access and blob fields in SQL with VBA and all the characters move.



mmcdonal
 
Old July 5th, 2008, 02:27 AM
Registered User
 
Join Date: Apr 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This error comes due to missing refrences or corruption in database. You can import your database to new blank database using tool>import option. If still you get error then use access repair software to repair your database.
http://www.repair-access-file.com






Similar Threads
Thread Thread Starter Forum Replies Last Post
Compact and Repair Access Database raguapk VB How-To 8 May 23rd, 2013 10:00 AM
Compact Access Database tang_moor VB Databases Basics 1 February 10th, 2007 04:10 PM
Compact Access Database tang_moor Access VBA 0 January 30th, 2007 02:38 PM
Compact Access Database lai_ccca Access VBA 0 January 9th, 2004 08:41 PM
compact access database hellobookus Access VBA 2 January 5th, 2004 06:51 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.