Solve : Runtime error 3027?

1.	Solve : Runtime error 3027?
Answer» Hi guys, I need help figuring out how to fix this error messege that I'm getting on my pc. Runtime error 3027 can anybody help me with this fix!! thank you .. It might have helped if you had told us when this error happened, what program you were running, what you were trying to do, that sort of thing, you know? But no, we have to be mind readers! So, now you have to read my mind! It's thinking about a search engine. Its name begins with G. Hint: Quote Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. I'm sorry contrex ..you're right.. I'm using Access 2000 as my database..and every time I try to open a file in access I get this messege, it won't let me do any changes. Is this help?? OK you did your penance This is expected behaviour (it is meant to happen, it is not a fault). The reason it happens is: because of legal issues, Microsoft has disabled the functionality in Access that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access. Quote WORKAROUND To work around this expected behavior, use one of the following methods. Method 1: Use Microsoft Excel Open the linked Excel workbook in Microsoft Excel, and then make your changes to the workbook. When you have completed the changes, save the changes and then close the workbook. Method 2: Use OFFICE Access 2007, Access 2003, or Access 2002 Import the linked Excel workbook into Access, and then make your changes to the data. When you have completed the changes, export the data as an Excel .xls file. Link to Microsoft explanation and full workaround (Took me 10 seconds to find, by typing "Runtime error 3027" into Google!) http://support.microsoft.com/kb/904953 Thanks for the help contrex Promise to use Google more in the future! Hello! I am getting the same error, but my SCENARIO is different. I am running Access 2003. I have a VB line that is exporting the CONTENTS of a table into a text file. There is no writing/changing of excel files. Any suggestions?? DoCmd.TransferText acExportFixed, "CMS Generic Portfolio Import File Format", "CMSExportTable", "G:\SPBlend.prn", False Thanks for any help! Possibly something here will cast some light http://support.microsoft.com/kb/161252

Answer»

Hi guys,

I need help figuring out how to fix this error messege that I'm getting on my pc.

Runtime error 3027 can anybody help me with this fix!! thank you ..

It might have helped if you had told us when this error happened, what program you were running, what you were trying to do, that sort of thing, you know? But no, we have to be mind readers! So, now you have to read my mind! It's thinking about a search engine. Its name begins with G.

Hint:

Quote

Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook.

I'm sorry contrex ..you're right..

I'm using Access 2000 as my database..and every time I try to open a file in access
I get this messege, it won't let me do any changes. Is this help?? OK you did your penance

This is expected behaviour (it is meant to happen, it is not a fault). The reason it happens is: because of legal issues, Microsoft has disabled the functionality in Access that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access.

Quote

WORKAROUND

To work around this expected behavior, use one of the following methods.

Method 1: Use Microsoft Excel
Open the linked Excel workbook in Microsoft Excel, and then make your changes to the workbook. When you have completed the changes, save the changes and then close the workbook.

Method 2: Use OFFICE Access 2007, Access 2003, or Access 2002
Import the linked Excel workbook into Access, and then make your changes to the data. When you have completed the changes, export the data as an Excel .xls file.

Link to Microsoft explanation and full workaround (Took me 10 seconds to find, by typing "Runtime error 3027" into Google!)

http://support.microsoft.com/kb/904953

Thanks for the help contrex Promise to use Google more in the future!
Hello!
I am getting the same error, but my SCENARIO is different.

I am running Access 2003. I have a VB line that is exporting the CONTENTS of a table into a text file. There is no writing/changing of excel files. Any suggestions??

DoCmd.TransferText acExportFixed, "CMS Generic Portfolio Import File Format", "CMSExportTable", "G:\SPBlend.prn", False

Thanks for any help!

Possibly something here will cast some light

http://support.microsoft.com/kb/161252

Solve : Runtime error 3027?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment