Ad:

MS Access and FileMaker Pro Discussion Thread
Unsolved
Views: 3862

Feb 27th, 2005

This Database is a Monster

Expand Post »

Hi,

I am working on a project that entails one beast of a database. A friend asked me to write a program into which he could catalog all of his cards by sport and then further by player, team, manufacturer, etc.

The tools I will be using:
1) MS Access - For the database backend
2) VB.NET - For the GUI

I know MS Access will do the job as far as the database goes, but since my friend lives 6 states away, can I package the Access database inside the VB.NET deployment project? So, when he installs the program on his computer, the connection to the database is made automatically.

I have used VB.NET off-and-on for approximately a year, but have never had to build a database for use with the application.

If you have any suggestions, I would be really appreciative.

***If this is not the right forum for the question please let me know so I can
post elsewhere.

bcheath_1

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

20 posts
since Jan 2005

Permalink

Mar 1st, 2005

Re: This Database is a Monster

why do you need the VB.net front end?
Can't you just build the front end via Access, either as forms or as an DAP?

(Unless your friend lacks a copy of office, which would be unusual! LOL).

Seriously though, is there a set reason for the VB?

autocrat

Reputation Points: 63

Solved Threads: 12

Posting Pro in Training

Offline

427 posts
since Feb 2005

Permalink

Mar 1st, 2005

Re: This Database is a Monster

The only reason I don't use Access as the front end is the fact that I hate the Forms Designer for Access. I have been unable to figure out how the form sizes work. Access works in inches. How that breaks down to pixels I am not sure. Thus, I have not spent a ton of time working with the Access designer, or doing any research on it. I also dislike the rather small selection of controls it has to offer. Some, for me, are awkward to work with.

Using Visual Basic.NET, for me, is a lot easier, quicker, and opens up a lot more doors for a better looking product. I could do the forms in Access, but prefer not to.

I hope that answers your question.

bcheath_1

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

20 posts
since Jan 2005

Permalink

Mar 1st, 2005

Re: This Database is a Monster

hmmm... in that case, I don't blame you! If it is too restrictive for you, then use an alternative.

Not sure about connecting to an access db though...... should be able too, but not sure..... I think a friend connect standard vb to access, so I don't see why a net version would be unable to!

autocrat

Reputation Points: 63

Solved Threads: 12

Posting Pro in Training

Offline

427 posts
since Feb 2005

Permalink

Mar 1st, 2005

Re: This Database is a Monster

OK.....

http://www.freevbcode.com/ShowCode.asp?ID=2226
http://www.quepublishing.com/article...le.asp?p=26956

Two different approaches!

Goodluck.

autocrat

Reputation Points: 63

Solved Threads: 12

Posting Pro in Training

Offline

427 posts
since Feb 2005

Permalink

Mar 5th, 2005

Re: This Database is a Monster

I have a followup question that's somewhat related to this:

If I develop a front end with some tool, and connect it to an Access back end, could I distribute the result to someone who does NOT have access? Would I need to include some sort of runtime component and would I (or the user) need to pay for said component?

Toulinwoek

Reputation Points: 10

Solved Threads: 2

Posting Whiz in Training

Offline

274 posts
since Mar 2005

Permalink

Mar 7th, 2005

Re: This Database is a Monster

You'd need a DB engine!
Access has it's own engine... yet the saved files are only data, they don't contain anything else about from the basic tables, table records and the details for relationships and scripts/macro's etc. as well as forms/reports etc.
Sou you'd need to supply something that could access that file type (.mdb).
I remember that you could purchase something from MS to ship Access DB's..... you could export the DB as a standalone application... it would basically include an engine for it!

In short, I think you need a component, or something to access MDB files.

If you hold for a bit... I'll see what I can dig up!

autocrat

Reputation Points: 63

Solved Threads: 12

Posting Pro in Training

Offline

427 posts
since Feb 2005

Permalink

Mar 14th, 2005

Re: This Database is a Monster

No you do not need a component or anything. The .NET includes the JET driver for Access. This can be pretty handy if you want to create a database in Access and then create the frontend using .NET and not worry about your users messing with the database (if they do not have Access). It can also save your users money, you can create a frontend and the Access backend and the users will not have to pay for an Access license.

Chester

cpopham

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

65 posts
since Mar 2005

Permalink

Mar 17th, 2005

Re: This Database is a Monster

ah.... got there before I could!

Just read about .net having the jet engine!
Oh well... atleast it means you can do it!

autocrat

Reputation Points: 63

Solved Threads: 12

Posting Pro in Training

Offline

427 posts
since Feb 2005

Permalink

Mar 17th, 2005

Re: This Database is a Monster

Yeah, you can even find code snippets that show you how to create an access database, compact and repair an access database and use SQL statements to create your tables and relations all from your code!

Chester

cpopham

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

65 posts
since Mar 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: DBMS Questionnaire

Next Thread in MS Access and FileMaker Pro Forum Timeline: Creating a Database from scratch, need assistance

DaniWeb Message

Cancel Changes

User Name
Password