Please Help!!!!

[KellyW]

I have a linked Excel table and run 5 queries off this linked table, everything runs fine, but when I try to run my reports I get the Link Table Specification does not exist.

My reports run off my queries, which run fine so I don't understand it at all. If I change the specs it works the first time and then not again. Please some help, I have a lot riding on this.
Thank you
Kellyw

 

[Ziggy]

How did you link the table and where are you changing the spec? I have linked tables I have never seen any spec to change.
I only change the location using the linked table manager?


Ziggy

 

[Dugantrain]

In the meantime, if you need a cheap solution to save your ****, just make those five queries Make-Table queries; that way they'll make tables in the database with the same data as what's in the Excel worksheets (except, of course, the data will be disconnected from the Spreadsheets and won't be Updated when the Spreadsheet is updated). You can use these tables as your source Data for your Reports. Like I said, it's cheap, but it'll get you what you need until you can trouble-shoot your queries.

 

[KellyW]

Thanks, but when I do the make - table queries, I get an error message saying, Numeric Overflow.
My database works aslong as I don't close Access or shut down my PC, so I think that when I close access, it does something that changes the Linked Table????
Have reinstalled Access and still no luck?????

 

[bat17]

Rather than deleteing the tables just clear them then they should keep there data types ready for the next lot of data.
Also Check out this article


HTH

Peter

 

[Ziggy]

See also the MS help site for the solution to the Overflow error.

http://support.microsoft.com/default.aspx?scid=kb;en-us;815277&Product=acc2000



Ziggy

 

[Excelguru]

If your linked tables are from a network drive, Access may be searching for your links on the wrong drive. This is common on a system that creates network drive letters automatically.

Good luck...

JT