Discussion Locked

can i do this

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

can i make a two tables with same name.

(Vishal Mongia)

6 replies

by sl-campbell

Assume you mean 2 MDB database tables.
This is not possible with-in the same MDB. You could however create a 2nd database and craete a table with the same name and then access both MDBs as needed.

by sl-campbell

I am assuming the person who posted the question needs to know how to "make", or create, two tables WITH-IN the same, (again assuming), ACCESS MDB,(not knowing even which version), which have the same name. Accessing the same table with two different object ref. is of course another thing.

by andrew

You can have tables with the same names as long as they have different owners.

database.dbo.table1
and
database.fred.table1

are distinct.

This discussion is closed to new replies.