error during compact and repair!

User avatar
sal21
PlatinumLounger
Posts: 4360
Joined: 26 Apr 2010, 17:36

error during compact and repair!

Post by sal21 »

see image!

is a an Access 2000 type.

my action:
i have a blank databse 2000 type
select all from old database
right click in new blank database.
have variuos error!!!!
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78519
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: error during compact and repair!

Post by HansV »

Select File > Options.
Set "New database sort order" to "General - Legacy".
Click OK.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4360
Joined: 26 Apr 2010, 17:36

Re: error during compact and repair!

Post by sal21 »

HansV wrote:Select File > Options.
Set "New database sort order" to "General - Legacy".
Click OK.

not found...
seep by step with image from Option Menu?
Tks

attached my menu Option
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78519
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: error during compact and repair!

Post by HansV »

Set "Ordinamento nuovi database" to the second option (the one below "Generale").
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4360
Joined: 26 Apr 2010, 17:36

Re: error during compact and repair!

Post by sal21 »

HansV wrote:Set "Ordinamento nuovi database" to the second option (the one below "Generale").
OK FOUND AND SET IT !
tks.

But i can create a 2007 type of database and copy all from 2000 type Access Databse?

and

i can convert the 2000 type databse to 2007 type directlly from menu? or not?

User avatar
HansV
Administrator
Posts: 78519
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: error during compact and repair!

Post by HansV »

Open the Access 2000 (.mdb) database.

If you have Access 2007:
Click the Office button in the upper left corner.
Click 'Save As'.
Click 'Save the database in another format'.
Select Access 2007 format (.accdb).
Click Save.

If you have Access 2010 or later:
Select File.
Click 'Save As'.
Select 'Save Database As'.
Select 'Access Database (.accdb)'.
Click Save.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4360
Joined: 26 Apr 2010, 17:36

Re: error during compact and repair!

Post by sal21 »

HansV wrote:Open the Access 2000 (.mdb) database.

If you have Access 2007:
Click the Office button in the upper left corner.
Click 'Save As'.
Click 'Save the database in another format'.
Select Access 2007 format (.accdb).
Click Save.

If you have Access 2010 or later:
Select File.
Click 'Save As'.
Select 'Save Database As'.
Select 'Access Database (.accdb)'.
Click Save.
in save as have only.... see image
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78519
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: error during compact and repair!

Post by HansV »

What happens if you click Salva?
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4360
Joined: 26 Apr 2010, 17:36

Re: error during compact and repair!

Post by sal21 »

HansV wrote:What happens if you click Salva?
same type of mdb .mdb!

User avatar
HansV
Administrator
Posts: 78519
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: error during compact and repair!

Post by HansV »

Strange. I don't know what causes that.
Best wishes,
Hans