If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Backend update
Don't know what you need. I'm using the code I downloaded to create/modify
the tables. I found that once the code had run it did not append to the table that recorded the latest ID of the table modifications therefore when the code ran it tried to recreate a table that already existed - alwasy starting at 1. I then added my own code to check if record count was 0 - if so add new record then use the ID as the value. Once the value had been entered into the upgrade progress table the original code worked (if dcount 0). However, to improve upgrades in the future how do I determine if a table exists before VBA tries to create it? "John W. Vinson" wrote in message ... On Sat, 3 May 2008 16:47:51 +1200, "Jason" wrote: I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? "Jason" wrote in message ... Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". "Jason" wrote in message ... Also the command RunCommand acCmdSaveRecord always generates an error "Jason" wrote in message ... I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). Thanks, J. Jason, you may be assuming that the volunteers here can see your computer monitor and read your mind concerning what you are trying to accomplish. Maybe some of the gurus around here can, but I certainly cannot. Please explain the context, what you're trying to accomplish, what steps you have taken to accomplish it, and the specific error messages you're getting. -- John W. Vinson [MVP] |
#12
|
|||
|
|||
Backend update
On Sun, 4 May 2008 14:11:15 +1200, "Jason" wrote:
Don't know what you need. I'm using the code I downloaded to create/modify the tables. "The" code. What code? You haven't indicated where you downloaded it from, or posted any of the code. I found that once the code had run it did not append to the table that recorded the latest ID of the table modifications therefore when the code ran it tried to recreate a table that already existed - alwasy starting at 1. I then added my own code to check if record count was 0 - if so add new record then use the ID as the value. Once the value had been entered into the upgrade progress table the original code worked (if dcount 0). However, to improve upgrades in the future how do I determine if a table exists before VBA tries to create it? Again, Jason: you are not the only person posting to this newsgroup. Maybe you have posted your code, a description of your table structure, and what specific opreations you're trying to carry out... but I'm sorry, as an unpaid volunteer I really don't have time or interest to Google search for all your prior postings. If you post a SPECIFIC question, *with code and a description of your tables*, I or another volunteer will be glad to try to help. But please reread the above with the assuimption that what you posted is *all* the information available to someone trying to help: someone who does not know your business, the structure of your tables, or the content of your code. Not much to go on, eh? -- John W. Vinson [MVP] |
#13
|
|||
|
|||
Backend update
I shall repost:
Jason, You can update the Front-End file easily by sending the client a new version. However, if you will need to make changes to the Back-End file you need a different method. Assuming that you cannot visit each client to make the necessary changes you need to add some code to the Front-End which will make the relevant changes to the Back-End files automatically. There is code at this site :- http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE%20Update%20Utilit y.mdb' which will do that for you. Just import the form, table and code module into your database, add one line of code to your 'start up' form and you are done. To add a new table or field to the Back-End you just call up the BE Update form, enter the details of the table, field, relationship, etc and the Back-End file is updated without affecting the client's existing data. You will also need to add relinking code to relink the Front-End file to the tables in the Back-End file. See this site to do that automatically :- http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb' There is full documentation on both sites to explain the procedure fully. HTH Peter Hibbs. On Thu, 1 May 2008 18:58:18 +1200, "Jason" wrote: It is split as you say the tables in the user mde is for temporary data and data i enter for look-ups etc. Since the data files have changed over time I have found the process of copying and importing easier. Can you post an example code where the table is checked and modified (i.e. fields added, modified or deleted). ALSO tables that are added Thanks, J "Larry Linson" wrote in message ... "Jason" wrote How do I upgrade existing data? A database upgrade i did involved copying the existing files using a batch file, then copy the new files over the existing files then a long routine in Access to import the old data into the new tables. Sounds as if you have not split your database into front end (queries, forms, reports, macros, and modules) and back end (tables, data, and relationships), with each user having a copy of the FE and the BE on a shared folder. -- The most common updates will be to the interface, so each user can just get a new copy, because it does not store data (other than, perhaps, some rarely- changing lookup tables -- state abbreviation and state name, for example). -- When you have to make a change in the data structure, the common approach (if you can't go to the location, and open the back end manually) is to write VBA code in DAO or ADO to modify the table design (if needed) and data in the shared back end, and update with any additional data that you are adding, and have one user or administrator at the production site execute that when they have exclusive access. There's other information about splitting and about an Auto FE Updater for use in multiuser environments at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm. Good luck with your projects. Larry Linson Microsoft Office Access MVP "John W. Vinson" wrote in message ... On Sun, 4 May 2008 14:11:15 +1200, "Jason" wrote: Don't know what you need. I'm using the code I downloaded to create/modify the tables. "The" code. What code? You haven't indicated where you downloaded it from, or posted any of the code. I found that once the code had run it did not append to the table that recorded the latest ID of the table modifications therefore when the code ran it tried to recreate a table that already existed - alwasy starting at 1. I then added my own code to check if record count was 0 - if so add new record then use the ID as the value. Once the value had been entered into the upgrade progress table the original code worked (if dcount 0). However, to improve upgrades in the future how do I determine if a table exists before VBA tries to create it? Again, Jason: you are not the only person posting to this newsgroup. Maybe you have posted your code, a description of your table structure, and what specific opreations you're trying to carry out... but I'm sorry, as an unpaid volunteer I really don't have time or interest to Google search for all your prior postings. If you post a SPECIFIC question, *with code and a description of your tables*, I or another volunteer will be glad to try to help. But please reread the above with the assuimption that what you posted is *all* the information available to someone trying to help: someone who does not know your business, the structure of your tables, or the content of your code. Not much to go on, eh? -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|