Connection Strings

split_atom18 · #1 05-20-2009, 04:09 PM

I have split my database into a front end and a back end. I used the tool that is given via access 2007. After the split my be database is no longer encripted. I re-opened it exclusive and password protected it. However now when I open my "Front End" I get password is invalid. I am pretty sure it is because I don't have a connection string. I have never worked with connection strings, therefore don't really know where to begin. I do however have the string I need. I just don't know where to put it.

Code:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;

split_atom18 · #2 05-28-2009, 02:50 PM

Bump would be glad to provide more information if is needed. I am still stuck on this issue.

Thanks again,

Dan

ConneXionLost · #3 05-28-2009, 07:09 PM

Hi split_atom18,

I've never worked with a connection string before either, but hey, the worse that could happen is you just delete what I suggest.

First, you'll need a module (or create one) to put a Sub into.

Here's an example Sub I found in a book:

Code:

Public Sub Reconnect()
	Dim cnn As ADODB.Connection
	
	Set cnn = New ADODB.Connection
	cnn.ConnectionString = _
	"Provider=Microsoft.ACE.OLEDB.12.0;" & _
	"Data Source=C:\myFolder\myAccess2007file.accdb;" & _
	"Jet OLEDB:Database Password=MyDbPassword;"
	cnn.Open
	Debug.Print cnn.ConnectionString
	Set cnn = Nothing

End Sub

split_atom18 · #4 06-01-2009, 12:46 PM

Will try and give it a go today, thanks again for your help. Will let you know how it went.

Thanks,

Dan

split_atom18 · #5 06-02-2009, 02:07 PM

It isn't recognizing "ADODB.Connection" as valid. So far it isn't working, but I am still playing with it. Just wanted to give you a brief update.

Thanks again,

Dan

Welcome to the Excel Forum

Forum Statistics