It doesn't seem to come up when I run LVS with other layouts; however, I can't seem to get rid of it. When RVE opens a warning pops up. The warning says: Database cannot be opened XDB Database not available. No comparison was made. I'm not sure...
If possible, make an MDE file out of your database. An MDE file cannot become decompiled, so your Visual Basic code always runs at top speed. Additionally, since no source code is stored in the MDE file, the database loads faster and uses less memory. ...
;Binary data cannot be inserted into a table directly using the ;INSERT INTO or UPDATE SQL queries. For more information, ; Only In InsertInToTable Func And In UpdateRowData Func $hDatabase = MsiOpenDatabase("MsiDB.Msi",2) ;2 CREATE MsiDB CreateTable($hDatabase,"Identity","Id INT,Name...
Every table in your database should have a primary key. This allows your database application to quickly locate specific records. Additionally, you cannot create secondary indexes on a table's fields unless that table has a Primary Key.
If possible, make an MDE file out of your database. An MDE file cannot become decompiled, so your Visual Basic code always runs at top speed. Additionally, since no source code is stored in the MDE file, the database loads faster and uses less memory. ...