Convert Access App To C#

[Kevin Marois]

This is more of an Access question, but I don't see a forum here for Access... One of my clients has asked me to upsize an Access application to C#/SQL. I can't figure out how to open the forms or database in design mode. Most of the the menu & toolbars are hidden. I'm sure it's some kind of security thing, but I don't know Access well enough. The only file they gave me was an .MDB file. Is there more? Anyone wanna shed some light here? Thanks alot.

Everything makes sense in someone's mind

[N a v a n e e t h]

There is no easy way to do the conversion. You need to look at the code and write it in C#. All the forms has to be redesigned.

Navaneeth How to use google | Ask smart questions

[Kevin Marois]

Ya, but how do I look into the code? The menu & designer buttons are not there.

Everything makes sense in someone's mind

[kideve]

Use mssql managerment stdio. Choose "Import Data". Find your mdb file. Then it'll be taken by itself.

[riced]

KMAROIS wrote:

The only file they gave me was an .MDB file. Is there more?

Possible that there is a .MDW file that you need - this contains user/group data for security purposes. IIRC the default is System.MDW. IIRC there are some settings that disable menu options but if you hold down Ctrl when opening the mdb these are ignored. (It's a long time since I did Access stuff so it might be Shift not Ctrl - there's definitely a way to do it though.)

Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

[Kevin Marois]

Thanks. I'll give it a try

Everything makes sense in someone's mind

[Lost User]

He's right; there's some code that is run when you open the database. That code hide's the menu's and stuff. Hold down the shift-key to open it in design-mode :)

I are Troll :)