So /u/ButtercupsUncle proposed just having the SQL e-mailed to him and then recreating the query. There are some tools that allow him to see the data, but not the objects. The point here is the /u/access4access has a database he needs to read. TL DR: Gonna make a Virtualbox/Win7 VM to be safe that the client doesn't send me incorrect or incomplete set of queries.Īnd you're saying that that would be simpler than just creating a virtual machine and opening the ACCDB file on the VM with the queries and tables in tact? Frankly, I fail to see the logic here. So it might sound weird, but I'd rather build a VM myself, than put the burden of responsibility on the client to extract every query, without error, without my ability to validate he did the right thing. In my experience, the heavier the technical load I give the client, the more I pay for it later, unless they have demonstrated good skill in the area already. That said, I don't want to ask the client for too much. So they want out of MS Access, meaning, I have no obligation to use Access any longer than it takes for me to get the information I need. The impetus for the conversion was that the client is wanting to write automations that update the data dynamically and has a web friendly view for customers. The project itself will be built in a MySQL, Python/Django, jQuery stack (very light view and front end) So I will have to rewrite all the queries into MySQL and I plan to abstract some of the calculations and place them into some Python classes if I see a lot of calculations happening in the queries. This looks like it will be pretty helpful for my guide. I've built out more VM's than I can count, and as such I don't tread lightly because it can be time consuming, but also, if that's the solution, I can have something up pretty quickly. I have a legit Windows 7 ISO and product key now, as well as a Office 365 license with Access. I've basically made up my mind to make a Windows VM in Virtualbox since I've used Virtualbox a bunch in the past to make Vagrant/Linux boxes. Technically, having the SQL statements e-mailed to you would work, if you didn't want to also run the original queries in Access.Ī bit more context for my situation, mostly for a point of information. Just wanted to point this out so I didn't leave you with the impression that a VM was the only way to go. So, while my original presumption (that your end product would be in Access) was wrong, you may still need to run a VM if you want to be able to compare your test results to the original without bothering the current user. And to do that, you'd either need to get the current user to run your test queries for you and then send you the results, or (wait for it.) build a VM and run Access on your VM. That being said, though, as you note here, you want to be able to see the original results as they currently are in Access, so you can compare your Django query results to them. If not, then the Access tables can be exported to Excel or CSV, and then imported into another format. And you should be able to connect your Django project to the Access data. You have access to the tables themselves through the tools you tried. So, with that in mind, if you want to rebuild the queries in Django, then, as BcU said, you can have the user e-mail you the SQL statements and convert those to the dialect of SQL that Django uses. For some reason I missed that in your original post. However, as the other two pointed out to me, your end result will be in Django, not Access. Thus, I said the only way to run Access on a Mac is through a VM, which is correct. Just want to offer a partial retraction of what I suggested.Īs I just noted to /u/ButtercupsUncle and /u/dsvella, when I suggested a VM, I was under the mistaken notion that your end product would be in Access. Is exporting queries to Word as easy as it looks? It might be easier to ask to have them export to Word. Results were that all three Mac Apps showed the metadata table and nothing elseĬan any of you verify that the queries are being exported incorrectly?Īlso, I am thinking if I have to go back and ask for another export anyway. I have opened the file in these three applications: I am suspicious that my client did not export the queries correctly, but I’m not very familiar with Access (it’s been ~10 years), and being on a Mac I’m at a bit of a disadvantage to not have actual Access right now. My client has sent over a file that is supposed to hold the queries I need, but only appears to contain some metadata and nothing else. I have an Access Office 365 login, but not have any fast Windows based solutions around me. I have a project where I’m converting an Access database with forms and queries to be a Django web tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |