Programming Access

[Bob Weiner]

I would like to create an access database for a small project so that I can
take advantage of its forms and reporting features. I often do development
work with C# and would like to create functions using this language inside
access.

I could use SQL 2005 Express and VS but then would have to start from
scratch. That would however, be easier than wrestling with VBA.

thanks,
bob

 

[Joseph Meehan]

I would like to create an access database for a small project so that
I can take advantage of its forms and reporting features. I often do
development work with C# and would like to create functions using
this language inside access.

I could use SQL 2005 Express and VS but then would have to start from
scratch. That would however, be easier than wrestling with VBA.

thanks,
bob

Have you looked at the domestic VB programming language built into
Access?

 

[Albert D. Kallal]

I would like to create an access database for a small project so that I can
take advantage of its forms and reporting features. I often do development
work with C# and would like to create functions using this language inside
access.

it seems to me that if you are comfortable with c#, then why not use the
rich Visual Studio tools to develop your application? While it is common
knowledge that using VB6, or vb.net, or c# to develop a data entry type
application will take 3 or MORE times as much effort as it does in ms-access
(so, that $5000 of work will become $15,000).

however, you forgetting that the learning curve in ms-access is just as
steep as c#.

I could use SQL 2005 Express and VS but then would have to start from
scratch. That would however, be easier than wrestling with VBA.

I thought you were staring from scratch? You mean you already have an
application?

You can create and use managed code for ms-access. Here is some starting
ideas:

http://msdn2.microsoft.com/en-us/library/aa902693.aspx

 

[James A. Fortune]

I would like to create an access database for a small project so that I can
take advantage of its forms and reporting features. I often do development
work with C# and would like to create functions using this language inside
access.

I could use SQL 2005 Express and VS but then would have to start from
scratch. That would however, be easier than wrestling with VBA.

thanks,
bob

If Access is connected to SQL Server you can use managed code to create
user-defined functions in managed code that can be included in SQL calls:

http://groups.google.com/group/comp.databases.ms-access/msg/7fe78a9af1084815

If Access is not connected to SQL Server you can still use managed code
to create some dll's that contain utility functions such as compression
or encryption for processes that are too slow when implemented in VBA.
Other than that I have not seen many opportunities for developing in
Access using C#.

James A. Fortune
(e-mail address removed)

 

[Bob Weiner]

I have used ADO in VS 2003 as an interface to existing databases but haven't
used it for actually creating new data. I just installed VS 2005 and
haven't played with it much yet maybe it is the way to go.

I want to minimize "grunt work" and get to my problem. I thought that
taking advantage of the features in Access may help with that since it will
probably be a small, single-user, single-computer implementation.

thanks,
bob

 

[Bob Weiner]

I thought it used VBA.

Have you looked at the domestic VB programming language built into
Access?

 

[Bob Weiner]

Thanks. I was hoping that all Office 2007 products would support managed
code natively. Writing .dll's may sometimes be useful but not what I want
for this project. And COM - No Thanks!

bob

 

[Joseph Meehan]

I thought it used VBA.

I noticed that FUBAR shortly after I wrote it. I have deleted the
message, but it does take a while for it to disappear from some servers and
never is deleted from others.

I have not looked into it, but it may be possible to use VB but I seem
recall hearing that not all the commands in VB are available in Access. I
don't really remember.

 

[Bob Weiner]

That's fine. I appreciate the reply nonetheless. bob

 

[Tony Toews [MVP]]

I noticed that FUBAR shortly after I wrote it. I have deleted the
message, but it does take a while for it to disappear from some servers and
never is deleted from others.

I have not looked into it, but it may be possible to use VB but I seem
recall hearing that not all the commands in VB are available in Access. I
don't really remember.

VB 6.0 and VBA in Office are virtually identical with the exception of
forms based differences. Most API calls work just fine in both.
AddressOf doesn't exist in VBA but that's pretty obscure I think
there's a work around for that anyhow.

There is one minor bug in the editor that is present in both.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm