Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 10th, 2006, 04:59 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default creating Front - End

Hi,

 Guy's i have exported an MDB to SQL Server 2000 and i now want to know how can i get the front end in the SQL Server with its back-end pls give me some idea's in this issue . I have asked this Question in Pl/SQl forum but thier is no response ...

 pls do the need full. thanks in advance.

ur,
papraguv
Reply With Quote
  #2 (permalink)  
Old April 10th, 2006, 07:11 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   Did you use the upsizing wizard to move the back end to SQL server? If you had, then the upsizing wizard would have created the connection to the back end from your exisitng front end. I would recommend this for first timers.

   If not, there are a couple things you can do.

1. You can replace the tables in your front end with LINKS to the SQL Server. This will require your users to log in to the SQL server when they first access data if you are not using Windows NT Authentication. Alternatively you can log them in with your code. The downside is that your users have access directly to the server, and if they have the rights, they can start deleting data from the server.

2. You can import data from, and update to the SQL Server as your users carry out transactions. This requires a little more code instead of using a direct link, but allows you greater control as far as data validation and other issues. You can use the transferdatabase method and transfer data from views instead of tables and limit the amount of data brought over each time as well. This also requires a login, but you can put the credentials in the method if you are not using Windows NT Authentication on the server.

I have used both of these methods with both Windows NT authentication and SQL Server mixed authentication, but if you are a noob, I would suggest the upsizing wizard. If this is not possible, post some more details on your configuration and we can help get you hooked up.

HTH

mmcdonal
Reply With Quote
  #3 (permalink)  
Old April 10th, 2006, 07:13 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I forgot to mention, a downside to the first method is that the linked tables will have new names, usually "dbo_tblOldTableName" instead of "tblOldTableName" so your queries, forms, reports, code etc will need to be updated. If you import tables, this is not a problem.

mmcdonal
Reply With Quote
  #4 (permalink)  
Old April 12th, 2006, 01:40 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Hi,thanks for ur reply

  I have tried the 2. point which u have said the and after ur mail i have tried the upsizing wizard and i get the adp file now i want to know how to share the adp to the other system

pap

P.A.P.Raguv
Reply With Quote
  #5 (permalink)  
Old April 12th, 2006, 01:45 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

hi, thanks for ur reply,

  I tried the 2nd point mentions and after ur mail i tried the upsizing wizard and got the result now what i want to know is how to share the front end to the other User i.e. for the other systems..

 pls do the needfull..

bye,
pap

P.A.P.Raguv
Reply With Quote
  #6 (permalink)  
Old April 12th, 2006, 06:22 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You should be able to simply copy the adp and paste it to your user's computer, usually on the desktop. If you used a DSN, you will need to make sure that it is also installed on your user's PCs. That should work.



mmcdonal
Reply With Quote
  #7 (permalink)  
Old April 13th, 2006, 03:43 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Do u mean DNS ...?

  I ill explain wat i did 1st. i installed the SQL server 2000 in an system and now i then uploaded the MSDB using Upsizing wizard and now i want to share the frontend to the other user and let the user to update the data in the data base ..now when i paste the database front end in other desktops i got an mess that Sever didn't logged on !.. What does it mean.,,

 pls clarify my doubt

bye

P.A.P.Raguv
Reply With Quote
  #8 (permalink)  
Old April 13th, 2006, 06:39 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

There are two ways to log into SQL server:

1. Windows NT authentication, which is the default and probably what you used - used in a Microsoft environment and requires Windows NT/XP to pass login credentials to the server based on the credentials used to log the user into their desktop.

2. Mixed authentication - allows you to run SQL server in a non-Microsoft environment. This requires a seperate login to the server.

   Both of these methods require that a user account be created on the SQL server for each user, but with mixed authentication you can create a single login for users and make everyone login with those credentials, but this is shared username and password and your transaction logs won't be so accurate.

Anyway, you probably have Windows NT authentication and an account for yourself, and it works on your PC. But other users are not passing the proper credentials and so the SQL server does not have a login for them. When they open the app, SQL expects the user to have logged in and Windows to pass their credentials, but since there is no account for them on the SQL server, they are bounced.

You should create a user account for each of your users, using their account credentials either from ADS, or create the credentials yourself on the server. OR used mixed authentication and require each user to log in when they open your app. If the first case, they will open your app and it will work fine. In the second case, they will open your app and have to enter a username and password to log in to SQL server.

Also, please make sure you have installed a DSN for the app. It sounds like you have since SQL server is throwing the error, and that wouldn't happen unless you could talk to the server.

HTH


SInce I work in a NetWare environment, I must use mixed authentication and my users have to log in.

mmcdonal
Reply With Quote
  #9 (permalink)  
Old April 22nd, 2006, 04:11 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

hi,

 sorry for the delay , I having Window XP and i have installed in Window xp os now wat i want to say is i did every think in back end and i works inthe server and the probs headed while iam proposed to share with the user level..

 pls give me some idea and send me some related link that gives me the remeady..

pap
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Users through Front End feets SQL Server 2000 0 November 2nd, 2007 03:32 PM
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Oracle back-end MS-Access 2003 client front-end Corey Access 2 February 16th, 2007 08:31 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 06:00 AM
Creating Front-End Login Interface Ben Horne Beginning VB 6 1 April 15th, 2004 05:27 PM



All times are GMT -4. The time now is 10:45 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.