MS Access having error when creating web form

Asked By maustuart 10 points N/A Posted on - 02/12/2012

Hello.

I have found this error while trying to create a web form:

Error:

Microsoft Access

There was an error creating your form.

Some fields may have been skipped because there was en error getting informaticn about them or because they didnt fit on the form.

OK

After clicking OK, I found the web form in edit mode but I'm unable to save it. 

Response needed. 

Thanks.

 

• Status: Open
• Question Views: 1089
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By vickss 0 points N/A #96552

MS Access having error when creating web form

Normally when this message comes up while you are trying to convert from one version of access to another it signifies that you database could be partly corrupt.

You will need to decompile a copy of your database.

You will first need to make a copy of your mdb file, while not running access

Compact:

In access 2010, on the database tools ribbon, compact and repair database

For access 2007, select the office button on the top left corner of the access window, after this select on manage and then compact.

After all this you need to close access and open up the command line interface usually the run command should do the trick and then enter the following command:  "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\My Documents\MyDatabase.mdb"

Carry out the compaction routine again then try your conversion.

All the best.

About vickss

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: MS Access