[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

can't overwrite table or query

Posted on 2010-04-06
2
Medium Priority
?
2,585 Views
Last Modified: 2013-11-28
Hello,
I have database with 1 table-
When I am trying to import an excel sheet with new data -I recieve error 'can't overwrite table or query'.
can my problem be with database or the data I am trying to import in?
I follow this same process on a number of small databases I have weekly and daily- I do not understand why I am getting this error.
thank you
0
Comment
Question by:davetough
2 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 2000 total points
ID: 29902175
Is the table a regular access table? Linked?

Gary
0
 

Author Comment

by:davetough
ID: 29902723
I just realized my start up form is open and is connected to the table in a way that if open is causing error.
thanks
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question