I have a Microsoft Access database which I would like to split. I also have Excel spreadsheets with Microsoft queries set up to pull information from queries in the Access database.
When I tried splitting the database my Excel queries stopped working. If I tried to link them to the front end of the database they could not pull through the data from the back end. The back end only contains tables, not the Access Queries that I want to view in Excel.
Is there any way around this problem? My main reason for splitting the database was to facilitate access for remote users.