Search results

I think I will have to do the 'try it and listen for the screaming' method unfortunately. There are over 1000 users with access to the directory and I don't have any interest in contacting all of them. Thanks for the reply and confirming my suspicions.

Hi, I am re-doing an Access 2007 database and I need to find files that are pulling data from it. How do I explain this. The people that designed this system connect excel files and other access dbs to the tables in this access db and use these in pivot tables/charts etc. When I recreate the...

I will make that work. Was hoping to be able to pass this off to different people to run each month but no luck now haha. Thanks.

Hi, I am probably making this much more difficult than it needs to be but hopefully someone out there has an answer. I have an excel data file that is updated monthly (and I am not able to have the source file format changed of course) that will be my linked table for Access 2007. The file...

Thanks Pat. When I re-read my post, I didn't really explain what I meant properly. What I have in excel (2007) is a connection query similar to this: SELECT * FROM `S:\Folder\MonthlyData.accdb`.`MyTable` There are 20 columns, (A-T) and the access table is updated with an append query to add...

I am having a similar issue, however I am not importing but have created a table in excel that links to my table in access. When the data is refreshed each month, the table data order changes. What shows up after refreshing the connection in excel is in both a different order than the previous...