July 2, 2008 at 4:33 pm
Okay, so I came in Monday and my boss said that he wanted me to port our Access 2003 DB into SQL Express 2005. I've never used this software before, but gamely said o.k.. Two days later, I have been able to expand the DB into SQL Express 2005 with most of my tables in tact.
I have also been re-aligning the old relationships and I'm getting there.
The most recent challenge is to get the forms to work properly. The forms in Access are our current front end interfaces. As I normalized our tables I have had to go back and re-associate the forms with the new table names. All has gone well until I discovered that the old drop down menus that I used to help restrict entry from the users have gone away. When I go in to modify the drop downs, I am told that Access 2003 is not able to make those kinds of modifications.
Any ideas?
July 8, 2008 at 2:41 pm
If you were setting permissions using Access, you really can't do that to sql server linked tables. You will have to set permissions in SQL server; which means setting up your users in SQL server. There are 2 ways to go about doing that, but I won't discuss that unless this is what you meant by your menus not working.
July 9, 2008 at 10:02 am
First, I recommend using an Access project, instead of an Access database linked to SQL. An Access project (adp file) will use the SQL database for all of its tables, procs, etc. I ran such an application for 6 years, and it worked very well.
Access has a bunch of data in the help files, and even an upsizing wizard, for converting Access databases to Access projects on SQL Server.
Once you do that, you can base the drop-downs on either tables, views or (often the best option) stored procs.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 15, 2008 at 10:46 am
Thanks for the help. I used the upsizing wizard and converted the DB to and ADB for the front end work. It has been an interesting process to say the least. Building in drop downs on the Access side has been a confusing process for me. In the old db, building a drop down to control data was fairly straight forward, but that no longer seems to be the case.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply