Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 3rd, 2003, 01:56 AM
Registered User
 
Join Date: Dec 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can someone help pleaze

Hi
Speaking of me, I'm not very new to Access, but I haven't worked on it as a professional.
I know that you can fire queries in Access, but I don't think you can create views.
i want to know that is there any way to create stored procedures or triggers in Access.
Also, I want to know that can we migrate data from any platform?
i downloaded this rdbms from http://www.vaman.net/vmndataserver.asp
i tried this s/w. It solved my most of problems (in context with user friendliness of Access)
these people claim that they have a data migration tool which can migrate data from any db to vaman & vice versa.
I tried this data migration tool, its working just fine.

i wud like others as well to atleast have a look at this particular software, b'coz this is really good.


 
Old December 3rd, 2003, 02:11 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

First of all, I do not think that "VARMAN" will stay in business long enough to provide you any support in the future.

Now, creating Stored procedures and view in access? that I can help with. You can create an Access Project (.adp), this are a front end for MS SQL Server. You can create one by opening access, go to
"New Access Project(existing database)" ---(if you have the database created already in SQL Server)

Whith this tool, access creates a file that strips the JET database engine out of access and uses, mostly ADO(I think, or maybe SQLDMO) to create procedures and views in SQL Server. You can create a full front end with this. I like to use this for my SQL Server databases because it allows me a more user friendly tool to create view and stored procedures.

After you create this, you can link to a view from a regular access .mdb same as a table. Now, stored procedures, this you can use via Pass Thruogu queries or ADO for a .mdb.

Do some searches in this forum for "adp" and you should find some info on this subject.

Remember, you will not be able to create regular queries with a adp because there is no JET engine (Jet is what access uses to crunch it's data). instead you will use SQL Server T-SQL, Not too hard to learn either.



Sal
 
Old December 18th, 2003, 03:57 AM
Registered User
 
Join Date: Dec 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Aparna

This is Siddharth. Even I am new to Access so wont be able to help you much. But from how much I know, you can create access project by going to new access project and from this you can link to a view from a regular access .mdb same as a table.
If I get to know more I will definitely get back to you.

Anywayz I have visited http://www.vaman.net/vmndataserver.asp and downloaded the prdt. I have migrated all my data to Vaman but have encountered 1 problem like just we tried dumping some data with 2 users connected to vaman server when i commit it,its not getting commited the entire thing what we have done..only my part is been updated ,butmy colleague will be lost if he rollsback..

Please let me know the solution if possible

Siddharth

 
Old December 19th, 2003, 02:10 AM
Registered User
 
Join Date: Dec 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to MrSpock1956 Send a message via Yahoo to MrSpock1956
Default

The first reply that I see to this talks about using the ADP, and SQLDMO. It also mentions that you no longer the the Jet Access. If you look on your MSOFFICE disc, you will find under the X86 directory a file called setupsql.exe. This installs the MSDE (Microsoft Data Engine) instead of the Jet Access Engine. It allows you to work with Access as if it were SQL Server 7. I quit using Jet when Office 97 came out. It will install on all Microsoft Operating Systems, and gives you much better SQL support. If you tell me what operating system you have, I can send you instructions for installing it.


Quote:
quote:Originally posted by mahajan_aparna
 Hi
Speaking of me, I'm not very new to Access, but I haven't worked on it as a professional.
I know that you can fire queries in Access, but I don't think you can create views.
i want to know that is there any way to create stored procedures or triggers in Access.
Also, I want to know that can we migrate data from any platform?
i downloaded this rdbms from http://www.vaman.net/vmndataserver.asp
i tried this s/w. It solved my most of problems (in context with user friendliness of Access)
these people claim that they have a data migration tool which can migrate data from any db to vaman & vice versa.
I tried this data migration tool, its working just fine.

i wud like others as well to atleast have a look at this particular software, b'coz this is really good.


Robert J. Taylor









Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.