Can't view forms and queries in MS Access 2016
We are doing an MS Access to Oracle conversion and I am on step one: Researching and capturing all the forms, queries, and the rest of the table definitions in Access. I have transferred both the main and split database (.accdb) to my local drive. However, I am unable to view or open the forms and most of the queries in Access because they reside in a folder on a shared drive that I do not have permission to.
Instead of giving me permission, the directions given to me:
You have to change the pointer in access to point to where you put the file on your hard drive. (Where I transferred both the main/split DBs)
I have no earthly idea how to go about this and it's embarrassing. Will anyone please elaborate on how to do this in Access?
Thanks
If I am understanding you correctly, you have a split MS Access database, consisting of a front end (FE.accdb) containing the queries, forms, reports and modules (and possibly some static tables), and a back end (BE.accdb) containing the tables.
Now that you have moved both of these files away from the "live" environment, the front end can no longer see the original back end, as it is stored in a place where you don't have permissions to access it, and you need to point it to your local copy of the back end.
If this is the case, open the front end, and select "External Data" from the menu at the top of Access. Then select "Linked Table Manager", which will bring up a screen like the one below:
Click on "Select All", and then "Relink". Choose the location of your copy of the back end, and click "Open" to start relinking.
Regards,
- Combine rows if the dates exist in another row
- Distinguish between two maximum values in a column with Power Query
- Power Query Conditional JOIN - JOIN with WHERE clause
- Calculate combinations for a range of text values in excel
- How to update a column's values in Power BI M Language
- What's the difference between DAX and Power Query (or M)?
- Sorting issue when consolidating monthly data into a year to date file. Using query, sorting by day, time, and letter
- Power Query `List.Generate` runs too slow
- Custom Colum based on specific dates in powerquery
- How do I properly use table.group in a PowerQuery query to dynamically summarize different rows and columns?
- Excel Power Query syntax issue transform multiple columns of records
- How to capitalize only first letter of a sentence
- Power Query Import For Power BI with group by on SelectRows
- Get data from config table cell when loading data source with power query
- Translate Excel Formula into Power Query
- Counting matching pairs of letters in lists of bigrams in Power Query M
- Bigrams of a string in Power Query M
- Power Query code to refer to another query (and how buffering works)
- M code for the equivalent of of Left (string, len(string)-11)
- How to add a missing column to the Transform Sample File
- How to add or insert ' (single quotes) for every string in a list in which strings are separated by commas in Power Query
- Power BI M code Split column from Lowercase to Uppercase won't include diacritics (accents)
- M Code(Power Query) to Remove Empty columns that runs fast
- How to find the value with date closest to another date
- Error when build AOSP 14 - internal error: undefined variable CTS_TEST_SUITES_DEFAULT
- Call a table using a dynamic identifier
- Problem getting the value from a cell using M in excel
- How to rename columns based on the data within them in Power Query M?
- Power Query return a field name based on parameter
- Power Query: after combining 2 tables got something strange