I'm currently running a database which is bringing data from an excel file. I want to be able to open this as a read only file as i am having problems opening the (excel) file when the database is running (It will not open when you click the file but does display the file in my database (The file is being displayed in a subform)). I have been told that if i open the file as a read only file this will solve my problems but i am unsure as to what code to use or where to put it?
The reason for wanting to have both viewed is so that the user can be running the database which is displaying the excel file but they can then call the actual file by click a command button which opens the file in excel to be edited!
Thanks for any HELP!!:banghead::banghead::banghead:
The reason for wanting to have both viewed is so that the user can be running the database which is displaying the excel file but they can then call the actual file by click a command button which opens the file in excel to be edited!
Thanks for any HELP!!:banghead::banghead::banghead: