Liz
In my experience, linked tables can't be imported if an index is messed up. Did you compact the source of the linked table or just the front end?
Bill
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> 2007, yes I do have a backup, and I can open the tables from the backup as well as the new one. I have the users back on and nobody is complaining.
>
> Weird. It was just to get myself a test copy of a linked table..., something I've done lots of times.
>
> I'll do a maketable query to accomplish the same thing.
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
> Sent: Wednesday, May 02, 2012 12:11 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Reserved error -1524
>
> Uh, oh. Which version of Access are you using, and do you have a backup? Can you open the compacted database and open the table?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> Sent: Wednesday, May 02, 2012 9:08 PM
> To: 'MS_Access_Professionals@yahoogroups.com'
> Subject: [MS_AccessPros] Reserved error -1524
>
>
> Pros,
>
> I just did a compact/repair on a database, yet when I try to import the table to another db I get reserved error -1524 there is no message for this error.
>
> Any ideas?
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
Tidak ada komentar:
Posting Komentar