I have a database in which Access is automatically generating a
sequence of Admin tables. It is due to the ODBC error (which I
haven't found yet) listed in the table. Access seems to generate
these indefinitely, it looks like this in my listing of tables:
Admin - 00
Admin - 01
Admin - 02
Admin - 03
Admin - 04
....and so on (it got up to 47 before I noticed, LOL)
Why do these get generated? Is there an option to turn this "feature"
off? What's funny is I don't get an error box on the window that is
generating the errors, these Admin tables just get created silently.
Each table has one record in it, the ODBC error:
01003 - 8153 - [Microsoft][ODBC SQL Server Driver][SQL Server]Warning:
Null value is eliminated by an aggregate or other SET operation.
I am using Access 2003.
Any insight would be appreciated. I've been using Access for a long
time and I've never seen this before. 7 6478
On 17 Apr 2007 06:57:43 -0700, n00b <ad****@email.c omwrote:
I'm 99 percent sure these tables are generated by your app, not by
Access.
-Tom.
>I have a database in which Access is automatically generating a sequence of Admin tables. It is due to the ODBC error (which I haven't found yet) listed in the table. Access seems to generate these indefinitely, it looks like this in my listing of tables:
Admin - 00 Admin - 01 Admin - 02 Admin - 03 Admin - 04
...and so on (it got up to 47 before I noticed, LOL)
Why do these get generated? Is there an option to turn this "feature" off? What's funny is I don't get an error box on the window that is generating the errors, these Admin tables just get created silently.
Each table has one record in it, the ODBC error:
01003 - 8153 - [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
I am using Access 2003.
Any insight would be appreciated. I've been using Access for a long time and I've never seen this before.
On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
On 17 Apr 2007 06:57:43 -0700, n00b <adv...@email.c omwrote:
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.
"n00b" <ad****@email.c omwrote in message
news:11******** *************@b 75g2000hsg.goog legroups.com...
On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
>On 17 Apr 2007 06:57:43 -0700, n00b <adv...@email.c omwrote:
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 "automatica lly" 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
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 "automatica lly" 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
Thanks for your help, the log messages setting makes that happen, just
what I needed to know. I see that now in the help like you said.
Much appreciated!
On Tue, 17 Apr 2007 16:01:00 +0100, "Keith Wilby" <he**@there.com >
wrote:
Sweet. I had no idea about this option. Just felt it wasn't a
system-generated table. Turns out it was :-)
-Tom.
>"n00b" <ad****@email.c omwrote in message news:11******* **************@ b75g2000hsg.goo glegroups.com.. .
>On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
>>On 17 Apr 2007 06:57:43 -0700, n00b <adv...@email.c omwrote:
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 "automatica lly" 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
"Tom van Stiphout" <no************ *@cox.netwrote in message
news:vs******** *************** *********@4ax.c om...
On Tue, 17 Apr 2007 16:01:00 +0100, "Keith Wilby" <he**@there.com >
wrote:
Sweet. I had no idea about this option. Just felt it wasn't a
system-generated table. Turns out it was :-)
Hi Tom, see my "pass through query" threads. If it wasn't for all the
trouble I was having I wouldn't have known about that option either.
There's always something new to learn :-)
Keith.
"n00b" <ad****@email.c omwrote in message
news:11******** **************@ b58g2000hsg.goo glegroups.com.. .
>
Thanks for your help, the log messages setting makes that happen, just
what I needed to know. I see that now in the help like you said.
Much appreciated!
No problem, glad to help.
Keith. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Perttu Pulkkinen |
last post by:
Hi all freaks!
I have been thinking hard, what would be good solution for a
straight-forward content management. I want to forget polls and forms etc..
and concentrate first only on different kinds of pages.
I came up with this approach in "nightly vision", wich felt very flexible.
ADMIN FORMS
**************
|
by: Google Mike |
last post by:
You know, while working on my moonlight corporation's LAMP project at
home this weekend, I couldn't help but wonder if people writing similar
projects are solving similar problems with having to complete the
project by building an installer and building the user/group
administration piece of it.
The thought came to me that it would be great if LAMP developers,
whether they used MySQL or PostgreSQL, could just simply write the
project to...
|
by: Stephan Neuhaus |
last post by:
Hi all.
I'm having a problem that's driving me nuts. I am not familiar with
Access, but I have read the FAQ, searched google, read the Access
Security FAQ, and looked at the Access Web, to no avail. Briefly, the
problem is this:
I'm having an old Access 2.0 database that I want to convert to Access
2000 on a different computer. The reason why the new database is on a
different computer is that the old database runs under Windows 95a...
|
by: Karam Chand |
last post by:
Hello,
My linux admin left the job. We had a PostgreSQL
installed under his username. He used to maintain it.
Now I am looking at the Linux box and I am just a
super duper newbie in Linux administration.
The previosu admin had a database created under his
name coz PostgreSQL dosnt allow root database.
|
by: AnhTai |
last post by:
Hi all,
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install
from blastwave). This is my first time with MySQL so I don't have any
exp with it.
I have some troubles as:
- I set password for root account via this command:
# mysql -h atlantis -u root mysql
| |
by: luckysingh |
last post by:
I've tried searching alot on the net but am not able to find how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates.
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help
Cheers
Lucky
|
by: Rahul Babbar |
last post by:
Hi,
I have two users, both of which are part of db2grp1, which is the
admin user.
db2grp1 has atleast 2 users, user1 and user2.
I create a table in user2, name it table2.
When i try to delete the contents of that table through user1, it does
delete.
I tried various ways like
"Revoke Delete on user2.table2 from user1"
|
by: gangac |
last post by:
I am currently working on an ms access application for a large insurance
company which generates reports for the user after the user inputs/select
some data....
Unfortunately the application has already been built - and till now we used
to run the application/reports by logging in as admin.. however, we now want
that users login to the database as a 'user' with limited privileges- but
the vba code, which is locked to run with privileges...
|
by: aklein |
last post by:
I was given a database to update and am running into the following
problem:
The database appears to have been secured using Access security (it is
an MDB, not MDE). Every form etc that I try to open (in the
development environment) gives me 2 messages:
1) "You do not have exclusive access to the database at this time
etc."
2) "You don't have permission to read frmWhatever... etc."
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |