Old DAO Structures
Aug 4, 2005
A few years ago I upgraded a little software package that I had written to Access 97, without updating some of the old-fashioned methods and structures (eg. it still uses things like : Set workdynaset = db.Createdynaset("Client") ).
Due to problems that some potential customers have had loading the A97 runtime version of this software onto PCs with Access 2000 or Access 2000 runtimes, I have been trying to upgrade to an Access 2000 runtime version.
I have read all the various threads on DAO stuff and the need to select the appropriate references on the Tools menu.
My question is this. If I select " Microsoft DAO 3.6 Object Library ", will the VBA code compile without my having to convert all of the dynaset-type code to a more modern form ?
View Replies
Jul 30, 2006
I need help with my table structures. Attached is a Access 97 sample of my existing tables.
Questions
1) I need a new table that shows which BankRepID’s are assigned to each ClientID. Currently the relationship between the Banks and their BankReps is normalized.
But every time I create a table to assign BankReps to Clients I have noticed it becomes possible for the user to assign BankReps to Banks where they do not work.
How do I prevent this through normalization?
2) Because one Client can have many banks and one bank can have many clients I created a many to many relationship. Is this correct?
View 2 Replies
View Related
Jun 12, 2006
Hi everyone. Over the last couple months, this site has been a real lifesaver for me, just reading about similar problems to mine. This new problem, however, I have no idea how to search for.
I have a table in the following layout:
ID, FieldName, Value
10001, ID, 10001
10001, FIRSTNAME, Jonathan
10001, SURNAME, Reid
10001, ADDRESS, 10 Abbotsford Road
I need to be able to flip it around to be in the following layout
ID, FIRSTNAME, SURNAME, ADDRESS
10001, JONATHAN, REID, 10 Abbotsford Rd
The table is about 30 fields wide and about 450 records long, therefore I cannot do it manually.
I'd appreciate any help
View 4 Replies
View Related
Apr 4, 2008
I've spent most of the afternoon trying to find an answer to my question so please forgive me if I just didn't have the right keywords to find it via search.
I have several clients that use my database which is split into two parts, one of which is the data back end. At times I release upgrades to the whole package and must currently go through the process of having them get me the BE file and I manually make changes to tables and update data.
What I was hoping to do was create a seperate database that could link to the BE file, check for structure items and if they are missing add them. For instance if I have a new field I want to add to a table it will look for it, add it, and then if necessary add data. This way I could have one master file that I could send my clients and have them run it and not have to worry about the timing issues of transfering files back and forth.
Any guidance would be great. Not necessarily needing lengthy examples that would take a lot of your time to type out, simply want to know if it's possible and the basics that I can research and read up on.
Thank you in advance for your time! :)
View 1 Replies
View Related
Mar 13, 2013
I have an access application that I've developed and given to people and now i'd like to update it. I have a "master" database that I use for development and I would like to compare the users databases to this one and apply any changes that I've made to the database schema without having to remember all the new fields, tables and everything else I've added.
View 1 Replies
View Related
Jul 26, 2013
I'm trying to create an archiving routine as my database is becoming very large. For about 10 tables I want to shift certain records to an external database which would have the required 10 tables with the same table names and structure.
So far so good. I now want to automate everything using vba. I can see how to use the INSERT INTO statement but I don't want to have to name every field as there are hundreds. I just can't see how to do this.
If the table structures are identical how do I neatly shift a bunch of records from one to the other using code.
View 1 Replies
View Related
