Making A Enduser Version Of The Database?
Mar 23, 2008
How do I make my database so only the creator (myself) can edit the tables, forms etc and other users see an interface starting with the switchboard, which they can't use any database tools except what the forms allow them to do?
Basically some kind of user permissions.
Thanks.
View Replies
ADVERTISEMENT
May 22, 2006
I have recently inheritied a database and find that there are functional differences between different versions of the database. The database contains over 30 very large tables and I am unable to find the differences between the versions. I need a process or tool that I can use to compare the different versions to find the table/record/field differences. I am up against a deadline and am needing a solution ASAP.
View 1 Replies
View Related
Feb 11, 2014
I am working on a section of code that when a user clicks a button it looks at a table called TBLVersion and increments the version number. The version number format is 1.0.1 what I need the code to do is increment the last digit by one for example to "1.0.2". I got the flowing code to work in excel but could not figure out how to translate it to access.
=LEN(A1)-SEARCH(".",A1,SEARCH(".",A1)+1)
=RIGHT(A1,B1)
View 1 Replies
View Related
Sep 2, 2014
I have been trying to come up with a solution for a problem I am having for a while to no avail. We have a backend database that stores various tables full of data. We then have a custom Excel Ribbon that connects to the database and pulls in the different tables depending on the user selection form the ribbon. Everything is working well on that end. The problem I am running into though is that in the development phase of the ribbon and database we had multiple versions and so there are still some people who are using old versions of the ribbon and therefore not connecting properly to the database. Is there some type of code I can add into the database and ribbon where it checks for a specific version to ensure the user is using the most recent version?
Basically, before any type of query is run to connect to the database the ribbon would have some sort of label on it somewhere and the database would check for that label and if it is correct, the code proceeds and if not a message box appears that tells the user they are not using the most current version of the ribbon and exits the sub?
View 5 Replies
View Related
Oct 22, 2012
I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.
View 1 Replies
View Related
Nov 2, 2005
I am looking to design a simple stock database for work. This is just an idea at the moment, unless I can get my head round this problem.
I have throught that I can have 3 tables
NEW STOCK(this is where you enter all new and existing stock is)
USED STOCK(this is where all the stock that has been sold used for whatever reason is entered)
ACTUAL STOCK(this is where the items in NEW STOCK have the items sold in USED STOCK deducted from them to give you the ACTUAL STOCK)
PLEASE HELP ME, am I completely on the wrong line or can I do this?
Would be good if I didnt have to use SQL, VBA etc...
View 2 Replies
View Related
Nov 14, 2006
Ive just started creating the table..and Ive put fields like name/address etc as text but there are a few fields that need you to select an option...so i want to use the "lookup wizard" to create a listbox or combo box dont know which is best.. BUT the problem is when I select lookup wizard it says "unable to start lookup wizard. The lookup wizard doesnt apply to fields of this data type".
Why does it say that?
View 6 Replies
View Related
Jun 5, 2006
I need help making a front and back end to my database. How should I do it!?!? All I know is what I should put in the front end and what goes in the back end. The rest needs to be explained to me somehow...
View 3 Replies
View Related
Aug 9, 2007
Hi,
I have discovered a problem with my database and wonder if anyone here can point me to the best solution...
The problem is this... when I took our company database over about 3 years ago it was around 45MB... now it is almost 350MB and growing steadily.
I have today discovered the main cause of this... the audit trails on a couple of the tables. If I remove these 2 fields only from the database it cuts it down to under 100MB. The Audit trail is quite important for us and so I'd like to keep it if I can. It is stored in a memo data type (the data is well over the 255 char limit of a text box). Is there any other better way to store this data or is there anything I can do to reduce the size of the memo data type?
Any advice would be greatly appreciated!
View 2 Replies
View Related
Mar 15, 2015
If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it would still work? If not, how would I do such a thing.
View 4 Replies
View Related
Apr 28, 2012
We have a shared personnel access database for our department. Another department is wanting to use the same database. Is there a way to go about deleting all the info and making a template to give the other dept to use?
View 5 Replies
View Related
Oct 29, 2013
As my database is growing and hold more and more data i want to make a daily backup to the local hard disk (it works on a network now) automatically.The way i want it to work is as follows :
When a user quits the application i want to check if there is a copy already existing with the date of today.
If it does it skips the copy process and just quits.
If it doesn't, i want it to make a backup in a directory. if the directory doesn't exist it must be made.
The backup file name must hold the date of today off course.
I realize that i have to have a procedure to delete obsolete (outdated) backups as well, but ill worry about that later.
Off course Ive tried this a few times, otherwise i wouldnt ask it here. But i seem to fail every time..
View 5 Replies
View Related
Dec 6, 2012
there is a need to make access database (access 2007) accessible over net. I know Access Database is not web based application. So I want to know if there is any way of making it accessible via net.
View 1 Replies
View Related
Jul 23, 2015
I need to start using the database I've created (desktop database). However, I don't want my current version to be the final version.
Should I create another file to work in and use the old version for data entry? When I am ready to start using my new version, is it easy enough to transfer all the data from the old?
View 3 Replies
View Related
Feb 14, 2013
I have created a database of club members in Access 2010. Each day I need to generate a report of who comes to the club. Up to this point I have been using an Excel spread sheet of members that I copy and paste to new daily spreadsheets each day. how to do this.
View 5 Replies
View Related
Feb 7, 2015
I've created and tested my database. What step or steps do I take now to make it so it's a program that only shows the forms and menu's I created, not all the Tables, Queries etc and the formatting options? Is there a link that explains what to do step by step?
View 2 Replies
View Related
Feb 21, 2014
I've been requested to make a bird count database.
The bird count data has been recorded on monthly papers like this:
[bird name] [week 1][week 2][week 3][week4]
The number of birds sighted for a given week is written in the [week x] columns.
What I need to do is make another column that shows whichever number is highest from columns [week 1], [week 2], [week 3], [week 4].
So for example:
Blackbird: Week1: 4, Week2: 2, Week3: 6, Week4: 2
highest: =6
View 5 Replies
View Related
Mar 28, 2005
;) Hey everybody,
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
Thanks
gunwax
View 9 Replies
View Related
May 20, 2005
Are there any issues with converting an older 97 database to 2003? Is it a straight conversion, or will there be differences that affect the way the database will run if converted? I've read somewhere that it is possible to use the newer version to open the database w/o converting it. It seems silly to have to install 97 on a new computer in order to view the db.
View 4 Replies
View Related
May 31, 2005
Hi.
Will a database created in Win Xp using Access 2003 work on machine running Win 2000 Pro and Access 2000?
Thanx
View 3 Replies
View Related
Jul 16, 2005
Very General Question
What version of Access do you use?
And if you use Access 97, why do you choose to use that over that of Access 2000 or higher?
I am curious to find out the reasons.
As for me, I use Access 2003 all around.
View 4 Replies
View Related
Aug 15, 2005
Help!
I just created a calendar pop-up for data entry in Access Version 2002 and it does not work with Access 2003. Any help from anybody would be appreciated!
View 9 Replies
View Related
Sep 26, 2005
An application that I made was created in Access 2000 as I was told that all users had at least this or newer. Of course a user with 97 popped up. Instead of having them purchase 2000 or newer I converted my app to 97 version. I expected troubles with references. So far this has only been a phone conversation and I plan on going there later today. The user says hitting alt/F11 does nothing... no code window comes up. I had her look through the menus for the code window but she says there is nothing there. She is getting runtime 3433 (she thinks) and unrecognized database format when trying to open a form. The database did open when holding the shift key though.
Before I go there, how do I open the code window for 97?
Any other suggestions? I bet this is a reference thing but there may be a problem with their access install too. There are 2 users at this location with the same issues... at least it sounds like it.
View 4 Replies
View Related
Nov 23, 2005
how do i go about this
i'm unable to do any upgrade of this version of access on my machine running windows XP, it is only possible on a machine running windows 2000.
what do i need to do to be able to tweak reports and forms and stuff.
Thanks
Happy thanksgivings
View 4 Replies
View Related
Dec 17, 2006
Hello All
I have a database which is use at busy times to run the delivery side of our Floristry business. The orders are entered,assigned to a delivery area, address labels printed. When it comes to delivery day orders are selected from the list ticked off then printed a make a list for the driver.
It was built using Access 97 when it first came out. Since then the software was upgraded to Access 2000 many mods have been made each year to improve the performance and the number of things it can do. It now has about 15 tables and a lot of queries.
Not being an expert with Access a lot of the design has been on a trial and error basis. Put it another way the main form has many hidden fields to make things work behind the scenes. But it does most of what I want it to.
I have now go to the point where the main query is saying that I can't add any more features because I have to many fields in it.
So the time has come to look at re building it for a number of reasons.
1. It is a stand alone database on one Pc.......... I would like to have it on a network to 3 or 4 Pc's around the shop.
2. Some of it needs to be redesigned to take out my ( it might not be the way a designer would it but it does work) type bits.
3 I would like to be able to use the system for all orders received on a day to day basis. So it will need to be used by other people.
My question today is
Should I be looking to rebuilt it using Access 2003 + the extra software so that i can run it on more than one PC.
Or would it be better to wait few months till Acess 2007 comes out and start from scratch.
thanks
Kevin.
View 4 Replies
View Related
Feb 5, 2007
Here is a question.
I go to the menu bar, Help->About MS Access
It's shown Microsoft Access 2002 SP3
This is MS Access 2002 Version, right.
But, at the top it is shown (Access 2000 file format)
Why do I use 2000 file format in Access 2002 version?
View 3 Replies
View Related