BorlandTalk.com

Fatih Keles · Guest

hi,
I dont know whether here is the right place to ask this question so I am
sorry if I am posting the wrong group..

I have an application using database components like TTable, TQuery etc..
the database server is sql server and I connect it via ODBC..
so when I choose a table from the server (in design time) the name seems
with a dbo. prefix..
I mean lets say I have [Students] table in sql server, and the properties
view shows the name of that table as [dbo.Students]...
I have lots of tables in this way..
Now, I would like to move the database to an access file (please dont ask
why). Actually I have already moved the database with relations and I
thought that the application would work but it didnt..
This is because it didnt see dbo.Students table in access database, only
sees Students.
I tried to change the name of access file as dbo.Students but I failed..
the question is:
1 - How can I change the name of access file?
2- OR is there another way of saying to components that this is not
dbo.Students but Students..?

I hope I could explain the problem..
Thanks in advance..

Jayme Jeffman Filho · Guest

Hello,

"dbo" seems to be your database name on SQL server.
MS Access uses one only file (mdb extension) for each database that holds all the tables.
The operation you're should make is copy data from "dbo.Students" (at SQLServer) to "Students" on the Access database. If you are using a single TQuery to do the copy you should qualify both "Students" tables with their correspondent database names like dbo.Students and nAccess.Students, otherwise you'll get a SQL ambiguity error.

HTH

Jayme.

"Fatih Keles" <fatih (AT) satek (DOT) com.tr> wrote