Recent content by amegahed3

Thanks for your help. No, unfortunately rebooting didn't help at all. The database and GLPK code are both located on my personal machine (not connected to any servers). Any ideas on how to close the connection after calling it each time though? Aly

Thanks a lot for your reply, DJKARL. No, it's not that big at all actually. It's only about 200 MB. Any ideas?

Hi all, I connect to Access from an open source optimization language (GLPK) through ODBC, in order to read some data, which I use as model inputs in GLPK and then I make the GLPK writes outputs back to Access. I use Access 2007 and windows xp.This has been working pretty well, but now for a...

Well, after MANY trials and asking different people, I was able to get the correct code. Here it is for anyone's reference: table x3_iii {j in TF, k in C, p in P, t in T: x3[j,k,p,t]>0} OUT 'ODBC' 'FileDSN=.\d2.dsn' 'UPDATE ((Channels a INNER JOIN ChannelPeriodProducts b' 'ON a.ChannelID...

Actually I asked a glpk expert (actually the developer of it) and he couldn't help me saying that it is more of an SQL problem. Also, I'm TOTALLY open to ANY code that would do what I want to do it. That is why I described in detail what I wanted to do. So could you please help me (weither...

Hi All, I'm trying to write values back to an access database from an open source mathematical programming language (called glpk) using ODBC. I succeeded in doing so in most variables except one. The problem is described below: The following code gets an error when writing the data...

Thanks a lot. I really appreciate your help. I already sent you an email with my database, and would appreciate your comments about it via email. I don't really have much experience in databases. So, how would you direct me in that case? Thanks, Aly

Hi, Thanks a lot for your kind reply. As for the problem with my database, first, yes, sure, I'd appreciate it if you could suggest some readings about that for me. Second, it would be REALLY great if you could look over my database and let me know of your suggestions. Could you send me your...

Hi! Thanks a lot for your reply. All what you said made sense and was very helpful. My questions/comments now are as follows: 1. You said that the big number of tables and relationships is extreme, and that I can use the "rules of data normalization to get to 3NF". What is that exactly? I...

Hi All, I'm not an expert in Access, and appreciate it a lot if anyone can help me answering the following questions/problems (I use Access 2007 by the way): 1. How can I export the tables structure (including all relationships) to a word, visio, similar office file or a pdf file? I tried...