Hi Forum, although I have a fair bit of experience with Access & VBA on a stand-alone workstation I have run into an area which finds me a bit lacking, namely linking tables with an OBBC Data Source/SQL server in a network environment. I have developed a database which I want to pull data into from our ERP App(Sage Office Line) which is Access based. I want to install this when finished onto 5 work stations. It calculates dealerships within a given radius of a given ZIP/Postcode and displays customer names and account info in an easy to read format and other functions that the ERP App is sadly lacking. I don't want the users to be able to change any of the information in the source database via the forms in my database, just view it. How can I ensure that this is the case? (I don't want to cause any problems with the ERP App, locking records etc, or my name will star with an "A" and end with "hole" ;-) Linking and copying the tables at run time is one way I suppose, but makes the start-up time too long. Can ODBC data sources be opened "read-only" how can I best achieve my aim?
Hey guys, thanks for the quick replies, as I said I am moving into new ground with SQL Server environment and ODBC sources here! Both replies seem to do the deal but if you could point me towards suitable articles / documentation / examples I can perhaps teach myself further. (I don't want to die stupid, and I don't want you to do all my work for me either ;-)