LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 1
Default excel/access problem with linked table

Not sure if this is the right place or not but i'll give it a shot.

I have 2 spread sheets and a access data base. Basically what happens is a user clicks a button in spread sheet 1 it writes the information for that button into spreadsheet 2 which then is linked to my access data base. It all works fine as long as the database is not open when someone clicks submit on spreadsheet 1. If i have the database open and click on submit the following error comes up:
Run Time Error 1004

excel cannot open the file "filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and the file extension matches the format of the file

then i get the option to end or debug

any help would be greatly apperciated!
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel File Linked in Access nukeawhale Excel Discussion (Misc queries) 1 January 21st 06 02:41 AM
Excel to Access linked tables Keith Excel Discussion (Misc queries) 0 December 14th 05 10:37 PM
New Excel data does not appear in linked Access table JohnL Excel Discussion (Misc queries) 0 October 7th 05 04:31 PM
Problem with linked Excel table in a word Document jcarlos Excel Discussion (Misc queries) 1 August 5th 05 07:41 PM
HELP: Access table linked to Excel - calculated fields? K Zox Excel Worksheet Functions 3 November 12th 04 08:18 AM

All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"