Re: How can access mdb ? - Database Discussion Boards

manuo56-Sep-07 22:36

6-Sep-07 22:36

HI ,
We have one webapplication which using this mdb file and this mdb
file reside in website folder,we donot know physical path of website and we are creating another window based aplication and want to use this mdb in my window aplication .How it is possible ? Please give me some Suggestion .Its urgent

Manu Sharma

Re: How can access mdb ?

pmarfleet6-Sep-07 23:07

pmarfleet

6-Sep-07 23:07

Is this an Access database?

Paul

Re: How can access mdb ?

manuo56-Sep-07 23:22

manuo5

6-Sep-07 23:22

yes this an Access database .

Re: How can access mdb ?

pmarfleet6-Sep-07 23:25

pmarfleet

6-Sep-07 23:25

A connection string for an Access database requires the physical path to the database file to be specified.

Paul

Re: How can access mdb ?

manuo56-Sep-07 23:28

manuo5

6-Sep-07 23:28

Problem is that website host in another server .so we donot know physical path of mdb .

Re: How can access mdb ?

pmarfleet6-Sep-07 23:32

pmarfleet

6-Sep-07 23:32

I don't think there is an easy solution to your problem.

You should probably consider migrating your database to SQL Server or something similar.

Paul

Re: How can access mdb ?

manuo56-Sep-07 23:45

manuo5

6-Sep-07 23:45

Thanks but web Aplication running now so it is not possible .

Manu

Re: How can access mdb ?

Paddy Boyd7-Sep-07 0:28

Paddy Boyd

7-Sep-07 0:28

How come you don't know the physical path to the webserver? Is it not on your network?

Do you need access to all the data in this database file? If you only need a small subset, you could create a couple of webservices to return the data you require, although this becomes very cumbersome for more than a couple of queries.

Re: How can access mdb ?

manuo57-Sep-07 1:50

manuo5

7-Sep-07 1:50

Thanks for reply
it is not on your network ,it is another server not on my network.I know Ip of this server only and name of mdb file . we want to fetch subset of all tables userwise data .

Re: How can access mdb ?

Paddy Boyd7-Sep-07 2:21

Paddy Boyd

7-Sep-07 2:21

So it's on another network that you don't have direct access to? I don't think you will be able to directly access this database.

Re: How can access mdb ?

manuo57-Sep-07 2:52

manuo5

7-Sep-07 2:52

They also provide one usename with full access on this mdb then it is possible to access or not ?

Manu

Re: How can access mdb ?

Paddy Boyd7-Sep-07 3:01

Paddy Boyd

7-Sep-07 3:01

Yes, but if you can't actually access the network to get to the mdb file to try and login to the DB with the provided username, it's not really going to help you, is it?

How to copy database from other database

C#Coudou6-Sep-07 21:19

C#Coudou

6-Sep-07 21:19

Dudes,

I have a new project using SQL database. Here`s my scenario.
I have two database.

Database Name: PCON_A
Database Used: 2006/01 to 2006/12

Database Name: PCON_B
Database Used: 2007/01 to 2007/08

I want to copy the database PCON_A to PCON_B using sql script.
How to do that?

Thanks in advance,
Jeof;)

******************************
I just want to
know everything

Re: How to copy database from other database

pmarfleet6-Sep-07 21:57

pmarfleet

6-Sep-07 21:57

Have a look at this article.

Paul

Re: How to copy database from other database

C#Coudou6-Sep-07 22:12

C#Coudou

6-Sep-07 22:12

link doesn`t work. Frown | :(

******************************
I just want to
know everything

Re: How to copy database from other database

pmarfleet6-Sep-07 22:17

pmarfleet

6-Sep-07 22:17

Oops. Copy-and-paste error. D'Oh! | :doh:

This link should work.

Paul

Re: How to copy database from other database

C#Coudou6-Sep-07 22:32

C#Coudou

6-Sep-07 22:32

got it. this is very helpful. Smile | :)

thanks so much.

******************************
I just want to
know everything

Re: How to copy database from other database

Frank Kerrigan7-Sep-07 5:06

Frank Kerrigan

7-Sep-07 5:06

<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />

or even

<br />
<br />
truncate table PCON_A.dbo.TABLE1<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Did u mean ??

samerh6-Sep-07 21:17

samerh

6-Sep-07 21:17

Can i implement the same concept that google use when u press search and gives u did u mean...

For example if i put Camille and press search it gives me the following possiblilities:
1- Camile
2- Kamil
3- Kameel

I was thinking of comapring first 4 characters and last 4 characters if we have 2 or 3 charcters common it displays it.

Re: Did u mean ??

pmarfleet6-Sep-07 21:54

pmarfleet

6-Sep-07 21:54

You could consider storing a dictionary of words in your database and using the SOUNDEX function to test for phonetic similarity.

Information on SOUNDEX can be found here.

Paul

INSERTING TWO TABLES IN ONE GRIDVIEW

shyne76-Sep-07 20:58

shyne7

6-Sep-07 20:58

How to insert two tables in one gridview?and how to connect it and to navigate...tnx;)

sunshine

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

Frank Kerrigan7-Sep-07 5:10

Frank Kerrigan

7-Sep-07 5:10

You could use a stored procedure with a temp table and use that

<br />
<br />
create proc myproc <br />
<br />
AS<br />
<br />
SELECT * INTO #TEMP<br />
FROM Table1<br />
<br />
<br />
SELECT * INTO #TEMP<br />
From * Table2 <br />
<br />
select * from #temp<br />
<br />
go<br />
<br />

or use a Union SELECT

<br />
<br />
SELECT * FROM TABLE1<br />
UNION ALL<br />
SELECT * FROM TABLE2<br />
<br />

You get the idea, use SQL to do it.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

shyne710-Sep-07 8:54

shyne7

10-Sep-07 8:54

Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb")
con.Open()

Dim da As New OleDbDataAdapter(sql, con)
sql = "Select * from Supplier_Information union all Select * from Products"
da.Fill(ds, "Supplier_Information and Products")
dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView

is this right?how will i assigned in my textboxes the table name?

txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0)

tnx

Can I modify ANSI_NULLS after table is created?

ckruger6-Sep-07 20:49

ckruger

6-Sep-07 20:49

I have a table that was created a few years ago (LIVE), but I need to change ANSI_NULLS from OFF to ON for this table. How can I do that without re-creating the table?

Thanks in advance!

Re: Can I modify ANSI_NULLS after table is created?

Frank Kerrigan7-Sep-07 5:11

Frank Kerrigan

7-Sep-07 5:11

Whats your database SQL Server ????????

You may have to change the value of any nulls in the table first

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Last Visit: 31-Dec-99 18:00 Last Update: 10-Jun-24 0:37

Refresh

ᐊ Prev 1...1423 1424 1425 142614271428 1429 1430 1431 1432 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.