Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

Table " cannot be found

VB6 DESIGNERS & CRYSTAL REPORT9
ERROR: Table " cannot be found!
I have tried everthing I know to solve this problem including:
 CurrentDataBaseName=F:\JEMSWIN\JEMSVB\JEMSDB.MDB
frmRecPrinting.Report11.Database.Tables(1).SetLogOnInfo "", CurrentDataBaseName, "", DBPassword
 frmRecPrinting.Report11.Database.Tables(1).Location = CurrentDataBaseName
set frmRecPrinting.Report11=nothing
DOEVENTS
SLEEP(100)
Report11.VerifyOnEveryPrint = True
Report11.DiscardSavedData
Problem occurs when the database changes locations. When you look at the designer, database location remains in default location and Verfiy on Every print is checked. If in the designer, you reset the database location, then this stuff works, but that won't work when the package is deployed.
What causes this error and how can it be fixed?
0
Bandit88_Johnson
Asked:
Bandit88_Johnson
  • 2
1 Solution
 
jrm213jrm213Commented:
Hi,

I don't know if this will help or not but I don't think that your parameters for setlogoninfo are valid

I believe the parameters are server, database, user, password

so you are trying to connect to the database with a password but no user

0
 
fadlounCommented:
what is the exact error message you are getting
0
 
Bandit88_JohnsonAuthor Commented:
Error is -  THE TABLE " CANNOT BE FOUND
jrm213jrm213: - I hope you are incorrect in the syntax as my software runs on many different servers as multiuser stuff whose names are unknown to me. Please reply back on this matter if you are correct.
This is so crazy as many reports issue the above error - immediately run it again and it works.
No VB code issued seems to change the default database location of the Designer. If you manually set it in stone inside the designer - it seems to work correctly everytime.
0
 
jrm213jrm213Commented:
Hi,

Ok it looks like in Crystal 9 you are not supposed to use SetLogonInfo anymore, and it was deprecated in Crystal 10. They recommend the following instead of setlogon info, hope this helps.

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2012058&sliceId=&dialogID=4520925&stateId=1%200%204522120
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now