Jet Database Error
Using the .net SDK I've been able open and print format without any issues. This time I attempted to open a format that connects to an excel spreadsheet(database) for parameters and got the following error( attached)
Is this error on the .net side? I have no problem opening the format from Bartender interface etc.
-
This is a limitation in Excel and a great reason why it should not be used as a "database". Only one user can have an excel file open at any given time. If a user has the file open and you try and BarTender tries to open it, it will throw that error. You get a similar message if you try and open it from your desktop while someone else has it open.
Would you like to open a read only copy or notify the user? ... something along those lines.
0 -
This could as well be something to do with the fact that you're calling a user mapped drive (S:\) instead of using it's UNC path. Remember that maps are interactive user specific and therefore may not work if you're calling them from a non-interactive user from the SDK. Try using the UNC path and see if you have the same error.
0 -
Yes that is true...so is it a PrintPreview thing then since the format opens fine until you try to do a print Preview.
Sharing that file doesn't help either! Looks like we'll have to create new table in SQL DB for them.
Thanks0
Please sign in to leave a comment.
Comments
3 comments