473,385 Members | 1,640 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Admin Tables to avoid hardcoding data?


Hi There,

I am creating a ms access database where I want to design admin forms that
can be used to enter in all the relevant information by the user instead of
me feeding in the data (don't want to hard code anything so the users of the
application can easily make changes later). What is the best way to design
such a system? Do you have suggestions on what would be good books or
internet sites on this subject?

Thanks so much,
Smriti
Nov 13 '05 #1
1 1233
I'm afraid there's not enough information here for me to answer. It is
possible to control a good deal of an application via data stored in
tables -- unsurprisingly, we call that "table-driven".

But it is certainly not feasible to give them all the flexibility of Access
itself in that manner. To do that you give them Access itself and teach them
how to use it. "Not hard coding anything" would seem to imply this is what
you had in mind.

Somewhere in between, there is a point where "table driven" is useful. To
determine whether is seems so would require a good deal more detail on your
part.

Larry Linson
Microsoft Access MVP

"Smriti Dev" <sm********@utoronto.ca> wrote in message
news:II********@campus-news-reading.utoronto.ca...

Hi There,

I am creating a ms access database where I want to design admin forms that can be used to enter in all the relevant information by the user instead of me feeding in the data (don't want to hard code anything so the users of the application can easily make changes later). What is the best way to design
such a system? Do you have suggestions on what would be good books or
internet sites on this subject?

Thanks so much,
Smriti

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
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...
2
by: windandwaves | last post by:
Hi Folk I am an PHP novice. Right now, I am redeveloping the wheel by creating my own type of PHP MyAdmin tool for my clients so that they can manage some data. A good exercise, but probably...
1
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...
10
by: Robert | last post by:
How do you get an accurate count of the number of records returned from a query when using linked tables. I have an access 2003 database as a front end to another access 2003 database that...
7
by: n00b | last post by:
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...
5
by: Troels Arvin | last post by:
Hello, Every so often, I'm asked to help people recover data from tables that were either dropped or where to much data was DELETEed. The complications related to restoring data are a problem....
0
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...
7
by: mukeshrasm | last post by:
i want to give admin the facility to add item in the existing menu without doing any hardcoding. he may fill the form that will prompt below which item he wants to add submenu or want to add main...
2
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.