Creating Access Project and locating data on SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created an Access project and added 7600 records to the table. The size of
the data base did not increase, indicating that the data is definitely being
stored on the SQL server. When I checked the SQL server I could not locate
the database. Is there some particular area on SQL server where databases
created from Access projects are stored ?
 
The database name should be displayed in the title of the database window.
You can open the debug/immediate window (press ctrl+G) and type:
? currentproject.Connection.Properties("Initial Catalog")
or for more information
?currentproject.Connection
 
Thanks for the info. When I executed the command, I got the following:

?currentproject.Connection
Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data
Source=UMDPSMB7V;Integrated Security=SSPI;Initial Catalog=ProjectTestSQL;Data
Provider=SQLOLEDB.1

When I looked in SQL Server, I saw the following. Underneith Databases, I
expected to see ProjectTestSQL. I saw databases which came with SQL Server
and those I created on the server but not ProjectTestSQL. Is there some
other place on SQL server where it is stored ? :

- Microsoft SQL Servers
- SQL Server Group
-UMDPSMB7V\SQLINSTANCE (Windows NT)
-Databases
 
Did you right click the database and select Refresh?

I'm not sure on the "instance". With later versions of SQL Server, you can
run multiple instances of SQL Server on the same server. It may be that you
are having issues with this. You can search the data hard-drive for
ProjectTestSQL.MDF.
 
I clicked Refresh. In addition, I searched for file ProjectTestSQL.mdf and
found the following:

C:\Program Files\Microsoft SQL Server\MSQL\Data\ProjectTestSQL.ldf
C:\Program Files\Microsoft SQL Server\MSQL\Data\ProjectTestSQL.mdf

From the size of these files 1024 KB and 1048 KB, I don't think the data is
being stored here. In addition the files were encrypted. Do you know what
their function is ?

If everything is working correctly and an Access Project is created, should
I be able to see the table after -Databases when I sign in to SQL Server ?

- Microsoft SQL Servers
- SQL Server Group
-UMDPSMB7V\SQLINSTANCE (Windows NT)
-Databases
 
Back
Top