| Author |
Topic |
|
DAVIDLEX
Starting Member
13 Posts |
 Posted - 2006-03-27 : 13:10:00
|
HELP!I am in deep do-do. I was to write a db to help with many functions of our office. I asked the web manager if I could link mty mdb file to the webserver, he said it was possible. Now I am 15 days shy of my deadline and he is now telling me I can no longer link my database due to security issues and that I must use SQL... I am not familiar with a SQL environment..... Please help!!!!I made many forms in access to make my db really interactive like an software application and are wondering how to use data access pages with SQl to not loose my hard work.Here is what I am given to complete my task:1. Set up a new web site (and corresponding test site) independent from my current public site. 2. Got SQL Enterprise Manager 3. Was given db_owner privileges to a blank database using Network accountI will get fired if I can not make this work. I have 3 small children and a wife that will be devestated if that happens. Please help me with any programming that you know that will link my data access pages to SQL and/or any programming you think my benefit me in making this possible.I really appreciate it. I am a very scared daddy right now and have no where to turn. Please HELP!!!! Lex |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 13:38:06
|
| 2000Lex |
 |
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 13:39:06
|
| As of right now I do not have the tools...Lex |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-03-27 : 13:41:18
|
If this is a creative plea to have someone do a homework assignment for you it's the best one I've seen yet.  It seems like you proposed (and got approval for) a solution, then they changed their mind about the architecture. Wouldn't a reasonable company recognize that as good reason for an adjustment to the schedule? You may want to raise that argument to help buy some time while you work out a solution.Be One with the OptimizerTG |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-27 : 13:48:57
|
quote:
Originally posted by DAVIDLEXI will get fired if I can not make this work. I have 3 small children and a wife that will be devestated if that happens.
not to mention you will get an F on your homework assignment. nice try.-ec |
|
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 13:53:13
|
| I wish it was only a homework assignment. I work for the government and I had talked with our web manager about 3 months ago in regards to having the mdb as the source for my pages. This was fine at that time from his end, now he is saying that he never said that. So basically 3 months of work is now... nothing. My manager for this task has already been promoting it out via newsletters and our website with our date. She will not budge since she was given the deadline from me and she put our programs rep. on the line. Basically the only way I can change or not meet the date is by getting fired and they can make reasons that it will not be released due to me being released, if that makes sense. I am beyond desperate. I have 3 kids, a wife and a mortgage. I have never worked with SQL and when I open it up (I got the data from my mdb in it) but other than that, I have no idea what to do. I am completely lost. If it wasn't for my wife crying when I told her the news today, I would have some pride left... But as of right now, I don't.Lex |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-27 : 13:55:31
|
| You guys are SO skeptical. This doesn't sound like a homework assignment to me, not only due to the complexity of the issue, but also because the poster hasn't really asked an answerable question yet.Lex, can you convert your application from and Access Database to an Access Data Project? Are you forms created in the Access environment which users will open, or do they need to be accessed via web pages? |
|
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 14:05:32
|
| Thank you so much for your post, I appreciate you understanding that this is not some homework assignment. This is my livelyhood.Are you forms created in the Access environment which users will open, or do they need to be accessed via web pages?I can convert my application to a Access Data Project and my forms are created in both the data access environment as well as data access pages which would have been accessed via web pages.Again, thank you.Lex |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-27 : 14:11:39
|
quote:
Originally posted by blindman
You guys are SO skeptical. This doesn't sound like a homework assignment to me, not only due to the complexity of the issue, but also because the poster hasn't really asked an answerable question yet.
yeah, I just thought he was laying it on kinda thick with the bit about getting fired...-ec |
|
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 14:18:55
|
| Getting fired is a reality for me right now, sorry. I have no paper trial with my conversation with him. I found out this morning when I wanted to upload my materials and start testing it on the test server, when he said you can not loan mdb files, all applications need to be run from the SQL server. He set me up and that is where I am. It was basically broken down like this, either you have it working as scheduled or find another job. I am a contractor and will be replaced. My access db is really good. They really loved it! It really has hit me like a ton of bricks that this change might make me loose the one job I loved. I am not trying to get sympathy, I am just letting you know what I am facing as a man and father. I happened to find this site and am thankful for any help you 'all can bring me. This is all foreign to me.Lex |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-27 : 15:36:25
|
quote:
Originally posted by DAVIDLEXIt was basically broken down like this, either you have it working as scheduled or find another job.
I sincerely hope that you are looking for alternate employment anyway, as this does NOT sound like the type of work environment you want to be in long-term (or even medium-term). Jump ship the first chance you get, and don't give them any more than the minimum notice, IMHO.That said, how large is your Access database. And I don't mean MB, I mean how many tables/views/forms/reports. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2006-03-27 : 16:27:35
|
| I have tried the upsizing wizard on 5 seperate DBs.Trying to fix what it breaks takes more time than codeing from scratch.There is no quick fix for this.Start by creating an .adp in access with a new db the same name as your access DB.Then layout your new tables useing your old ones as a guide MAke sure to use the same names.View your access querries in SQL view and use that to create stored procidures with the same names.Last export your forms into the new .adp JimUsers <> Logic |
|
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 17:13:35
|
quote:
Originally posted by blindman
quote:
Originally posted by DAVIDLEXIt was basically broken down like this, either you have it working as scheduled or find another job.
I sincerely hope that you are looking for alternate employment anyway, as this does NOT sound like the type of work environment you want to be in long-term (or even medium-term). Jump ship the first chance you get, and don't give them any more than the minimum notice, IMHO.That said, how large is your Access database. And I don't mean MB, I mean how many tables/views/forms/reports.
I am having my wife look as we speak, lol (my first laugh of the day). 29 tables, 214 queries, 348 forms, and 380+ preset reports as well as ad hoc.I am tired thinking about it... My wife keeps telling me to quit now because she hates the way I am being treated... I keep telling her, you don't give up just because there are obstacles blocking you. You remain on your foundation when you have your family to feed.But if something comes along... It's hard to work with a team over 2 years and have the key players change and the new people basically want to hire their own people... So they are not forgiving at all to say the least.Lex |
|
|
|
DAVIDLEX
Starting Member
13 Posts |
Posted - 2006-03-27 : 17:14:26
|
quote:
Originally posted by JimL
I have tried the upsizing wizard on 5 seperate DBs.Trying to fix what it breaks takes more time than codeing from scratch.There is no quick fix for this.Start by creating an .adp in access with a new db the same name as your access DB.Then layout your new tables useing your old ones as a guide MAke sure to use the same names.View your access querries in SQL view and use that to create stored procidures with the same names.Last export your forms into the new .adp JimUsers <> Logic
Thank you Jim, I will try this right now and let you know what happens!Lex |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-27 : 18:01:56
|
| 29 tables is not too big a task to upsize.Now, 214 queries, 348 forms, and 380+ preset reports as well as ad hoc? That is HUGE?Serious question here: Presumably they want/need this application. Are they actually prepared to fire you toss all the expense of creating this down the drain? It's not like they could hire a new person who could just step in and take over something of this magnitude. Maybe you should call their bluff...The good news is that your existing forms and reports should work reasonably well within an Access Data Project linked to a SQL Server backend. Also, upsizing the 29 tables should be easy and the upsizing wizard should be able to almost all of it for you.The bad news is that if you want any sort of performance or enterprise scalability you will need to convert those queries to views. Most will be easy, but their are bound to be some gotchas. And that is what we are here for. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-27 : 18:04:52
|
quote:
Originally posted by DAVIDLEX... My wife keeps telling me to quit now because she hates the way I am being treated...
Sounds like good advice to me.You could also use it as a negotiating tactic. Along the lines of "If you are not going to give me a reasonable chance to complete this project, I can walk right now, and you can finish it yourself." And if you really feel bold, "Since you are taking that attitude, I want more money and some guarantees to finish this project."It's tough to do, but any negotiation has to allow for the possibility of it going either way. If you feel you can't say no, that is when you get the worst deal. Sometimes you have to say no even when you can't afford to say no.Anyway, good luck on your situation, no matter how it goes.CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-27 : 18:07:02
|
| As a side note, you say this is all related to a new management team?And you are currently a contractor?You can pretty much bet they are going to can you when you finish the project anyway. That's why they want you to hurry up.What? You were expecting thanks? |
|
|
|
jhermiz
3564 Posts |
Posted - 2006-03-27 : 20:37:30
|
I love reading blindman's responses, they seem to be blunt and to the point ;).
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-27 : 23:11:45
|
quote:
Originally posted by jhermiz
I love reading blindman's responses, they seem to be blunt and to the point ;).
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
'been a long time since I was accused of having too much subtlety. |
|
|
|
Next Page
|
CLUELESS - Help this panicked dad!