Re: Admin Tables



On Tue, 17 Apr 2007 16:01:00 +0100, "Keith Wilby" <here@xxxxxxxxx>
wrote:

Sweet. I had no idea about this option. Just felt it wasn't a
system-generated table. Turns out it was :-)

-Tom.



"n00b" <advinn@xxxxxxxxx> wrote in message
news:1176821217.543788.29000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7...@xxxxxxx> wrote:
On 17 Apr 2007 06:57:43 -0700, n00b <adv...@xxxxxxxxx> wrote:

I'm 99 percent sure these tables are generated by your app, not by
Access.

-Tom.


The app is Access, its a 100% Access application with links to SQL
Server. This access database is a front end, there is no application
outside of this database.


Access isn't an application as such, it's a tool to enable the user to build
a database application. Access won't do anything "automatically" unless
it's been programmed to do it. Looks to me like you have some pass-through
queries with the "Log Messages" option set to "yes". "Admin" is the default
username and that is why the tables are named as such.

Click in the "Log Messages" property of a pass-through query and press F1
for more info.

Keith.
www.keithwilby.com


.



Relevant Pages

  • Re: Admin Tables
    ... The app is Access, its a 100% Access application with links to SQL ... This access database is a front end, ... Click in the "Log Messages" property of a pass-through query and press F1 ...
    (comp.databases.ms-access)
  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)