Jet Database Error Follow

0
Avatar
Legacy Poster

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.

 

 

3 comments

0
Avatar
Legacy Poster
Comment actions Permalink

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
Avatar
Michael Toupin (mtoupin
Comment actions Permalink

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
Avatar
Legacy Poster
Comment actions Permalink

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.

Thanks

Please sign in to leave a comment.