Read SQL database from access

human_anomaly

Registered User.
Local time
Today, 07:55
Joined
Apr 12, 2004
Messages
69
I have created a program in vb.net that creates a sql database. I know need to open that database with access on a pc for user friendlyness. I have seen many programs that can take an access database and turn it into an sql database but I haven't found a way to turn an sql database into an access database. Can anyone help me out?
 
sql server ce

Sorry for the cofusion, I created the database on a pocket pc using SQL Server CE.
 
This looks like it may help. It looks like I have to send the database from the pocket pc database (sql server ce) to the main desktop side (sql server 2000). Is this correct? When I clicked to select a server it gave me two options, BETA and COMET. I am on the company's network so I am hoping that these are the names of their SQL servers. Unfortunatly I could not log in to the servers because I do not have the rights to be on the server. I will have to do some research and find out if in fact these are our SQL servers that I am seeing in the list and make sure I can get access to them. Since I believe I do have to trasfer the databases from the pocket pc to the SQL Server 2000, could you provide me with some information on how to do this. Thanks for the help.
 

Users who are viewing this thread

Back
Top Bottom