I created a db on my local drive that once complete needs to be accessible to a few hundred users across the globe. It's a relatively simple search form that starts out by pulling data in from a warehouse via ODBC. I checked for compatibility issues and there several, the most common one is "table has to have a primary key". I can't make any changes to tables that come from the data warehouse. Here are my questions:
1. Should I write a macro to import the tables in from the warehouse, localize them & then modify them to add a primary key?
2. Is publishing my db to Sharepoint via Access Services the best way to go? If not, what is?
1. Should I write a macro to import the tables in from the warehouse, localize them & then modify them to add a primary key?
2. Is publishing my db to Sharepoint via Access Services the best way to go? If not, what is?