Question about Objects and linking Please read

[Philly44]

Ok heres my problem. I have setup a front end that access some spreadsheets so users can view some data in an easy to read format. I am doing by using an Excel object on a form and displaying named ranges specified in the code. The problem I am having is when the Me.Object.Action = acOLECreateLink is called it prompts me to as to whether I want the data updated or not. Its always going be yes but I would like to no if I can stop it from asking and just update.
I thought I could use a macro to do this but I don't seem to be able to use Macros on the system this is on and I really doubt that I would be able to convinve the Net admin to allow them.

Any suggestions, thoughts or leeds on this would be realy appreciated

Thanx for reading this and helping if you can

 

[MichaelRed]

Why are you doing the link via code? If you just use the Spreadsheets as tables, you can provide a static link and they will "appear" to be just tables in the Access database window. If you are building Forms and reports based on their content, these will always have the 'updated' data and thus there is NO problem.

See, I did Read it!

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[jitter]

I know this works for supressing the pop up box when deleting but you might want to try it for your situation and see if it works.

Try the following on the excel.application object:

objExcel.DisplayAlerts = False


This may or may not work for you.

I do agree with MichaelRed though. Unless we are missing something that would be a good path to take.

 

[Philly44]

I wish I could to this the way you suggest, thats how I would have liked to have done it in the first place. However these spreadsheets are linked up the ying yang and completely full of formulas. When I have tried to link them into the database I get about 10 tables created just to report the conversion errors. Also the layout of the spreadsheets aren't exactly uniform(I wish) They are setup to look like tables similar to that of that of Word. I will try the coding suggestion though and let you know.

Thanx