Access 2000 - Autonomous window possible?

[Briyun]

I've developed a relatively extensive database using Access 2000 as a front end, and will be converted to SQL before implementation at the office.

I started this as an independent study at school, and has since grown way beyond the scope of the course. The company I work for saw it and wanted it for their own.

My main aesthetic concern with the way the database looks, is that I'd like it to appear as a separate software/program...ie. NO MS Access window border, menus, taskbars, etc.

I've seen packaged software programs that were created initially with Access2000, and they most definitely didn't appear as though they were born of Microsoft.

Any suggestions, links, resources??

I'd be most grateful.

-Briyun

[strangerstill]

Most customization can be sorted by setting options in the Startup dialog (Tools->Startup); this lets you sort out the application title, icon, menus, toolbars, database window, special keys etc.

As for the 'window border' thing, you're somewhat restricted by the fact that Access uses an MDI, with just one top-level window per instance. This makes aesthetic and logical sense, but if you want forms to sit outside of the main application window, you'll need to write the app in VB (not too painful, but could be some work) as the Access 2000 flavour of VBA doesn't allow the creation of VBA forms.

[Rhino302]

Yeah, use VB 6.0. I'm not sure that it has the provisions for Access 2000. I was converting it back to 97 or whatever the prior version was. But its no bother, because you can add tables and queries from within VB anyways. If you want, p.m. me, and I'll send you this project I was working on at school. It's got a splash/copyright screen, main screen, buttons to other windows that pop up when records are added or changed, etc.

[Mr. Mojo Risin]

Yeah, VB6 can work with an access 97 or 2000 DB. I found this out by testing deferent controls the other week. although, It seems that you have to use the ADO controls to work with the 2000 DB.

I was curious about DB programming so I went to Barnes & Nobles to look for a book and I managed to find a 3" book thats called "Mastering Database Programming with Visual Basic 6"... wow, almost 1,000 pages devoted to this subject, comes with some sample code and an evaluation edition of SQL Server 7. It may take me a while to absorb all this information though, heh.