Question Locked

Access link to Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an excel spreadsheet which is linked to an Access database. when trying to modify the spreadsheet data by way of the access table, all i get is a beep. it will not allow anything to be entered. also, as long as the access table is open, I cannot open the spreadsheet externaly. it seems that something is locking the file but I cant figure out what it is. any ideas?

Dan

2 replies

by triathlete1981

did someone change the path to the link? are permissions appropriate for both the MDB and the Excel sheet?

This discussion is closed to new replies.