?
Solved

Database problems

Posted on 2003-03-17
5
Medium Priority
?
122 Views
Last Modified: 2010-05-03
OK, I am writing a database program.  So far I have been able to create a database using pure VB6 code, protect said database with a database password, create tables and fields.  The problem that i have is, I want to create user names and passwords for to gain access to the database.  Please note that i am using a pure code method for this application (i.e. there are no ADO/DAO controls on the form) and I want to be able to create/setup/modify user names and passwords from a pure code created database (using coded DAO modle 3.5).  I have tried this and I keep getting the same or similar message to 'database is open to with exclusive rights / MDE file not found'.  Do I need to created a MDE file (if so, how do I do this using pure VB code)?  How do I setup default user names and password when I first create the database (remember im using pure code to do this)?  How do I modify user names and passwords?

The part about MDE files is probable the most important part of my question(s).  I hope that someone can help me, as I have searched (vbcode.com, pscode.com, codeguru.com, google.com) the net for information on this subject and cant seem to find any.

I am a fairly novice programmer so please keep any answers that you have simple.  I thank you all in advance for your help.

PS. The database created is a Microsoft Access Database (*.mdb), 'Microsoft Jet workspaces'
0
Comment
Question by:BadgerUK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
Sweat earned 1000 total points
ID: 8155336
BadgerUK,

Here is a link on the Microsoft web site:

http://msdn.microsoft.com/library/en-us/off2000/html/acconAllAboutMDXFiles.asp

I did not go into each section to check it out but I think this is where you can go to get some information.

Hope it helps,

Sweat

0
 
LVL 2

Expert Comment

by:Sweat
ID: 8155358
BadgerUK,

Another MS link:

http://msdn.microsoft.com/library/en-us/off2000/html/acdecprotectmodules.asp

It's a little higher in the MSDN knowledgebase.

Sweat

0
 

Expert Comment

by:CleanupPing
ID: 8532168
Hi BadgerUK,
This old question (QID 20553831) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 8982927
This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in a week or two.  I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help/closing.jsp

GPrentice00
Cleanup Volunteer
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 9034002
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->Accept Sweat's comment as Answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month9 days, 8 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question