Run-time error 3051

[talus14]

I have a database which is using an excel spreadsheet as a source file for some of its fields and calculations , due to the nature of the spreadsheet I need several users on at once.

I have pinpointed which section is giving me this error its a sub form that uses some data from and external spreadsheet to perform calculations in a query. Is there anyway I can solve this ?

Cheers

Talus

 

[oumahexi]

It may be that your query is too big or too complex. Or, it could be a network issue.

 

[talus14]

well I just opened it twice on one computer to test it so networking shouldnt be a problem, and ive tried it on multiple computers..hmm

so the query being too complex while using files from excel can cause an 3051 error?

 

[boblarson]

well I just opened it twice on one computer to test it so networking shouldnt be a problem, and ive tried it on multiple computers..hmm

so the query being too complex while using files from excel can cause an 3051 error?

Can you state the error DESCRIPTION? Just a number isn't all that helpful at times (I don't know about you, but I can remember some of the errors but not all of them).

 

[boblarson]

Okay, I just Googled it and found it. Is this database SPLIT with a copy of the frontend on EACH user's machine and the backend on the server?

 

[talus14]

yes the database is definatly split with the data held in the back database and the front end with the forms and some of the queries.

this error states that the spreadsheet is being exclusively used by another person , ive set the spreadsheet to shared etc with no success

 

[boblarson]

yes the database is definatly split with the data held in the back database and the front end with the forms and some of the queries.

this error states that the spreadsheet is being exclusively used by another person , ive set the spreadsheet to shared etc with no success

I've never had a linked spreadsheet work where you had more than one user use it at a time. I stopped linking to them a long time ago because of that. When Access has it open, users can't open the spreadsheet for editing and if the spreadsheet is open when Access fires up it doesn't like that and says so.