Access Application Version

  • Thread starter Thread starter Faze
  • Start date Start date
F

Faze

Hi,

I have recently taken over an old Access database (97) for a small company,
and I am updating it to 2007. Admittedly, Access is not my forte, so I would
appreciate any help or insight you can lend on this...

On the switchboard there is what appears to be a simple expression that
returns the application version ( =DLookUp("[AppVer]","USysLicInt") ). The
problem is, there is no USysLicInt table, nor a reference to one in any of
the VB forms. I can't get rid of this expression as it breaks the
switchboard, and I can't track down the AppVer or USysLicInt any where in the
app... When I build a new application for deployment with the Package
Solution wizard, there are fields to enter build versions (major, minor,
etc), but even these do not populate this hidden "table" with the appropriate
data.

What should I do to fix this, input the proper version number for my build,
and track down hidden data elements in the future?

TIA!
 
See this link for info on USys tables:

http://www.eggheadcafe.com/software/aspnet/29234217/usys-tables-in-access-200.aspx

These are hidden 'system' tables that are created by the user. That link
tells you how to unhide them. It sounds like it's different in 2007 than 2000
(I'm using 2000). It's possible that when you convert to 2007 the USys tables
aren't kept, I'm not sure. But if you still have a 97 version of your DB you
should be able to import them into your 2007 DB. In the older versions of
Access, to see hidden tables you go to Tools, Options, then to the View tab,
and check the boxes to show System and Hidden objects. If you still have the
97 version of the app (I hope you took a backup!) I'd go into the 97 DB and
show all hidden and systme objects and see if you see that table there. If
so, then I'd try Importing it into the 2007 version. If you try the import
and the hidden tables don't show up in the list, then I'd just re-craete the
table manually. There's probably not a whole lot in it. My guess is someone
created a hidden user table that tracks various application parameters. Based
 
Hey Jim,

Thanks for the help! That was exactly what I needed. Ironically, I had
unhidden system tables at some point, but didn't currently have them visible.
There was only the version information in that table as you guessed.

Regards,
Joe (Ann Arbor)
 
Faze said:
I have recently taken over an old Access database (97) for a small company,
and I am updating it to 2007. Admittedly, Access is not my forte, so I would
appreciate any help or insight you can lend on this...

On the switchboard there is what appears to be a simple expression that
returns the application version ( =DLookUp("[AppVer]","USysLicInt") ). The
problem is, there is no USysLicInt table, nor a reference to one in any of
the VB forms. I can't get rid of this expression as it breaks the
switchboard, and I can't track down the AppVer or USysLicInt any where in the
app... When I build a new application for deployment with the Package
Solution wizard, there are fields to enter build versions (major, minor,
etc), but even these do not populate this hidden "table" with the appropriate
data.

What should I do to fix this, input the proper version number for my build,
and track down hidden data elements in the future?
Click to expand...


A table named USys... would be a developer created table.
It is probably hidden along with the built-in system tables,
which you can display in the database window using the Tools
= Options menu item.

If the table really doesn't exist, then recreate it.
 
Ann Arbor, huh? I'm right down the road (guess you noticed that by the 'In
Novi'). Went to U-M (well, the Dearborn campus) way back when. I never heard
of USys tables before, so I learned something new. Just did a Google search
 
Yeah, I noticed the 'in Novi'... figured you had to be in MI. My Google
searches were too explicit... USysLic and USysLicInt produced no Google
results at all. I'll remember your method of trimming the name down in the
future.

Thanks again!
 
Thanks Marshall... You are exactly right.

Cheers,
Joe
--
C# .Net Developer


Marshall Barton said:
Faze said:
I have recently taken over an old Access database (97) for a small company,
and I am updating it to 2007. Admittedly, Access is not my forte, so I would
appreciate any help or insight you can lend on this...

On the switchboard there is what appears to be a simple expression that
returns the application version ( =DLookUp("[AppVer]","USysLicInt") ). The
problem is, there is no USysLicInt table, nor a reference to one in any of
the VB forms. I can't get rid of this expression as it breaks the
switchboard, and I can't track down the AppVer or USysLicInt any where in the
app... When I build a new application for deployment with the Package
Solution wizard, there are fields to enter build versions (major, minor,
etc), but even these do not populate this hidden "table" with the appropriate
data.

What should I do to fix this, input the proper version number for my build,
and track down hidden data elements in the future?
Click to expand...


A table named USys... would be a developer created table.
It is probably hidden along with the built-in system tables,
which you can display in the database window using the Tools
= Options menu item.

If the table really doesn't exist, then recreate it.
Click to expand...
 
Back
Top