By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Prompt to select excel spreadsheets in Access?

P: 1
I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom SQL Queries that I wrote for them. Right now I have them linked using the Linked Table Manager. Inside that there is an option to Always prompt for new location that appears to do nothing but make me currently reselect the worksheets.

Is there anyway to always make it prompt the user to select the excel spread sheets each time they open the Access file?
Feb 7 '12 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
You'd need to write some code to do it. There's nothing available automatically.

How to change BackEnd Database links (Access 2003) could help, in conjunction with Select a File or Folder using the FileDialog Object.
Feb 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.