I embarrassed to say it's taken me this long to convert from A4 to A5.
I am in the process of recreating my forms, reports, etc. and have even managed to create a few scripts that work. I'm doing all this on my computer at home. So, far I've only worked with one A4 database, but I have several that I use, mostly for lookups in forms.
At the office, all these files will be on the server. I haven't created any lookups in my forms because I don't know how the drive paths will convert over. I understand that all my old A4 databases will become A5 tables, but when I copy the whole thing over to the network, will the locations of the lookup tables be changed to reference the server path instead of my local drive's path? I know this was always a problem with A4. And when I create a script that opens a database, will I have to change all the paths when I move everything to the server? Is my best bet to back everything on my local drive up and then restore it to the server?
Also, I have records in all the databases, but it's not the current data. When I convert everything over, I was going to empty all the tables and append the latest data from the A4 databases that are on the server now and then move them all to an archive directory. Is this the smartest way to get the data in there?
Thanks for your help.
Linda
I am in the process of recreating my forms, reports, etc. and have even managed to create a few scripts that work. I'm doing all this on my computer at home. So, far I've only worked with one A4 database, but I have several that I use, mostly for lookups in forms.
At the office, all these files will be on the server. I haven't created any lookups in my forms because I don't know how the drive paths will convert over. I understand that all my old A4 databases will become A5 tables, but when I copy the whole thing over to the network, will the locations of the lookup tables be changed to reference the server path instead of my local drive's path? I know this was always a problem with A4. And when I create a script that opens a database, will I have to change all the paths when I move everything to the server? Is my best bet to back everything on my local drive up and then restore it to the server?
Also, I have records in all the databases, but it's not the current data. When I convert everything over, I was going to empty all the tables and append the latest data from the A4 databases that are on the server now and then move them all to an archive directory. Is this the smartest way to get the data in there?
Thanks for your help.
Linda
Comment